Suman Murasing
8 years ago

Which function will you use to enter current time in a worksheet cell?

A. =today()

B. =now()

C. =time()

D. =currentTime()

Answer: Option B

Solution (By Examveda Team)

To enter the current date and time in a worksheet cell, you should use the =now() function. This function returns the current date and time based on your system's clock.

Key Points:
=now(): Provides both the current date and time.

=today(): Returns only the current date, not the time.

=time(): Used to create a time based on hour, minute, and second values, but does not return the current time.

=currentTime(): This is not a valid function in Excel.

This Question Belongs to User Ask Question >> Miscellaneous

Join The Discussion

Related User Ask Questions