shortcut key to enter current date in MS Excel.
-
Ctrl + ;
-
Ctrl + Shift + ;
-
Ctrl + :
-
Ctrl + Shift + '
A
Correct answer
Explanation
In Microsoft Excel, pressing Ctrl + ; (semicolon) inserts the current system date into the active cell. Ctrl + Shift + ; (or Ctrl + :) inserts the current time, and Ctrl + Shift + ' copies the formula from the cell above.