Question

When assigned to a cell, the __________ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
a. todayb. date and timec. dated. NOW

Answer 1

Answer:

Option D: NOW

Explanation:

In Microsoft Excel, NOW function can be used to return a serial number that  corresponds to the system date and time beginning with December 31, 1899.

The NOW function is useful when a date and time is required for calculation or display. The value will be updated each time we open the Excel worksheet.  To use the NOW function, we can type in the formula as follows:

=NOW()