Question

function in excel display current date and time.
A) date()
B) now()
C) today()
D) time()​

Answer 1

Answer:

Insert a static date or time into an Excel cell

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

Explanation:

If you need to display the current date and time, use the NOW function. The Excel TODAY function returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY using any standard date format.