Question

Which of the following functions returns the current date and time in MS-Excel? 
1. NOW
2. DATEVALUE 
3. TIME
4. DATE

Answer 1

Correct Answer - Option 1 : NOW

The correct answer is NOW.

• If a current date and time are required, the NOW function is used.

• The TODAY function takes no arguments and returns the current date, updated whenever a worksheet is changed or opened.
• One can also use F9 to force the worksheet to recalculate and update the value.
• In the Excel sheet, the Date and Time entry is very easy and can be updated as under.
• Select the cell where the date and time are to be inserted.
• For Date, Select Ctrl+; and press enter.
• For Time select Shift+Ctrl+; and press enter.