Which of the following function is used to enter current time in a worksheet cell ........

Computer GK MS Office

Download Solution PDF

Which of the following function is used to enter current time in a worksheet cell?

=today()

=now()

=time()

=currentTime()

छोटे Courses बड़े Results

Master MS Office

Prepare through Micro-courses

Try Now

Explanation:

The Excel NOW function returns the current date and time, updated continuously when a worksheet is changed or opened. The NOW function takes no arguments. You can format the value returned by NOW as a date, or as a date with time by applying a number format.
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).