Which function is used to create a Date with year, month,...
Which function is used to create a Date with year, month, and day in Excel?
DATE()
DATEDIF()
DATEVALUE()
CURDATE()
Correct answer is A
The DATE() function is used to create a date with year, month, and day.
Syntax:
=DATE (year, month, day)
Example:
=DATE(2022,8,26) // returns Aug 26, 2022
What is the correct syntax of IF() function in Excel? ...
What are the tabs that appear at the bottom of each workbook called? ...
Which of the following is a type of checkbox available in MS Word? ...
Which commands are present in Quick Access Toolbar? ...
The shortcut key to close PowerPoint is? ...
Which of the following is a type of Page Orientation? ...
Microsoft Excel is used for? ...
With which view can you see how text and graphics will appear on the printed page? ...