USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ctrl+D
|
|
|
Ctrl+; (semicolon)
|
|
|
Ctrl+Shift+; (semicolon)
|
|
|
Ctrl+Shift+D
|
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: -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-3: -Shift + Alt + D shortcut key is used to insert the current date.
Detailed explanation-4: -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.