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

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