Multiple choice

Which of the following can be used to put the current date and time in an excel sheet?

  1. TIME()

  2. =NOW()

  3. =DATE_TIME()

  4. =DATE_NOW()
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The NOW() function in Excel returns the current date and time as a serial number, which updates dynamically when the worksheet recalculates. It's one of Excel's built-in volatile functions that automatically refreshes. Options A, C, and D are not valid Excel functions - TIME() returns only the time portion if given hour, minute, second parameters, and there are no functions named DATE_TIME() or DATE_NOW() in Excel.

Keep practicing — related questions