Ad
Sponsored by Sir Tauqeer
CLICK HERE TO JOIN SIR TAUQUEER WHATSAPP GROUP
FOR PREPARATION CLASSES AND JOBS UPDATES
Join Now

Which keyboard shortcut inserts the current date in Microsoft Excel?

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

Correct Answer: Ctrl + ;

In Microsoft Excel, pressing Ctrl + ; (semicolon) inserts the current system date into the selected cell as a fixed value. The inserted date does not automatically update when the workbook is reopened. If users want both the current date and time, they can press Ctrl + ;, followed by a space, and then Ctrl + Shift + ;. Excel also provides functions such as TODAY() and NOW(), which automatically update whenever the worksheet recalculates. Learning keyboard shortcuts like Ctrl + ; improves productivity by allowing users to enter dates quickly without manually typing them. This shortcut is widely used in accounting, finance, inventory management, and office documentation.

  • Shortcut: Ctrl + ;
  • Function: Inserts current date.
  • Updates Automatically: No.
  • Related Function: TODAY().
  • Correct Answer: Ctrl + ;

Leave a Comment

Join Our WhatsApp Channel ×
Scroll to Top