Question

Which function will you use to enter current time in a worksheet cell?
a. =today()
b. =now()
c. =time()
d. =currenttime?

Answer 1

Answer:

On a worksheet, select the cell into which you want to insert the current date or time. Do one of the following: To insert the current date, press Ctrl+; (semi-colon). To insert the current time, press Ctrl+Shift+; (semi-colon).

=TODAY(): Current date (varies)

=NOW(): Current date and time (varies)

Explanation: