A) Ctrl + Shift + ;
B) Ctrl+!
C) Ctrl+*
D) None of these
This keyboard shortcut is a handy way to insert the current time, including seconds, into the active cell of your Excel workbook. It’s a quick and efficient method for capturing the moment.
Here’s why the other options aren’t used for inserting the current time:
- B. Ctrl+!: This keyboard shortcut doesn’t have a predefined function in Excel related to time insertion.
- C. Ctrl+*: While Ctrl+* is a common keyboard shortcut used for copying formatting in Excel, it’s not used for inserting the current time.
For the current date, you can use another helpful shortcut:
- Ctrl+;: This inserts the current date in the format defined by your system settings.