How do you display current date and time in MS Excel ?

470ComputerMedium

AYear()

BDate()

CTime()

DNow()

Correct answer

D. Now()

Explanation

To display the current date and time in MS Excel, type the formula =NOW() into a cell; this will automatically update to show the current date and time whenever the spreadsheet is recalculated. Key points: Function: Use the “NOW” function. Shortcut: You can also quickly insert the current date by pressing “Ctrl + ;” and the current date and time by pressing “Ctrl + Shift + ;”.