Which keyboard shortcut inserts the current date in Microsoft Excel?

A. Ctrl+;
B. Ctrl+D
C. Ctrl+T
D. Ctrl+'
Correct Answer: A. Ctrl+;

The correct answer is Ctrl+;. In Microsoft Excel, the keyboard shortcut Ctrl+; (semicolon) inserts the current date into the active cell. This is a quick way to add today's date without typing it manually. Among the options:

  • Ctrl+; : Correct; this inserts the current date.
  • Ctrl+D: Fills down the cell content from the cell above.
  • Ctrl+T: Creates a table in Excel.
  • Ctrl+' : Copies the formula from the cell above (apostrophe).

Therefore, the correct answer is "Ctrl+;".

Leave a Comment

Scroll to Top