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 + ;