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

If you think there is any confusion in the given MCQs, you can comment below.

Follow us on WhatsApp

docmcqs.com is Pakistan's No.1 online platform for preparing for all types of exams including PPSC, FPSC, KPSC, SPSC, Ministry of Defence, and for one-paper MCQs. This includes Pedagogy MCQs, general knowledge MCQs, current affairs MCQs, and much more.

Leave a Comment

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

Scroll to Top