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
In Excel, hyperlinks can be ...
MailTips can provide you with the following pieces of information, except for: ...
How can you tell the email that you have read from the email that you have not read? ...
When a label is too long to fit within a worksheet cell, you typically must ...
In MS Access, a primary key in any table has the following properties ? ...
What is the default file extension of MS Access? ...
A composite key in Access is ...
Which technique prevents invalid data being saved in Access table ? ...