When assigned to a cell,the ____ function returns a number that corresponds to the system date and time beginning with December 31,1899.
A) SYSDATE
B) NOW
C) DATETIME
D) CURRENT

Question

Quizplus · Accepted Answer

The NOW function returns the current system date and time in Excel. It starts counting from January 1, 1900, but can also include fractional values for the time. Using NOW in a cell will update the value to the current date and time whenever the worksheet is opened or recalculated. SYSDATE and DATETIME are not valid Excel functions, and CURRENT is not a function at all.

When Assigned to a Cell,the ____ Function Returns a Number