DocMCQs Educational Banner

Which of these key are used in ms excel to insert current time In workbook.

Question: Which of these key are used in ms excel to insert current time In workbook.
  • A. A) Ctrl + Shift + ;
  • B. B) Ctrl+!
  • C. C) Ctrl+*
  • D. D) None of these
Correct Answer: A. A) Ctrl + Shift + ;
Explanation: 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.

Leave a Comment

Your email address will not be published. Required fields are marked *

Join Our WhatsApp Channel ×
Scroll to Top