USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ctrl +:(colon)
|
|
|
Ctrl + ; (semi-colon)
|
|
|
Ctrl + T
|
|
|
Ctrl + CT
|
Detailed explanation-1: -To insert the current date, press Ctrl+; (semi-colon). To insert the current time, press Ctrl+Shift+; (semi-colon). To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).
Detailed explanation-2: -Insert Current Date Just like with inserting the current time, inserting the current date is as simple as hitting a hotkey combination on a cell. Press Ctrl + Colon and you’ll have the current date.
Detailed explanation-3: -To use this shortcut, simply hold down the Ctrl key and then press the semicolon key, and it will instantly add the current date. Similarly, if you need to add the current time, you can use the Ctrl+Shift+; shortcut. Just hold down the Ctrl and Shift keys, then press the semicolon key.
Detailed explanation-4: -Excel current date and time formulas (static) “Ctrl +; ” – inserts the date (Windows) “Ctrl + Shift +; ” – inserts the date and time (Windows)
Detailed explanation-5: -The shortcut to format a cell as a date is CTRL + SHIFT + 3, and to format it as time, the shortcut is CTRL + SHIFT + 2.