Asked by Mojarai Johnson on May 24, 2024
Verified
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
System Date
The current date according to the operating system of a computer or device.
- Understand the use of different Excel functions and formulae, including logical tests and the IF function.
Verified Answer
CE
Chitalu Esnart NakazweMay 25, 2024
Final Answer :
B
Explanation :
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.
Learning Objectives
- Understand the use of different Excel functions and formulae, including logical tests and the IF function.