USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To enter the current date into a worksheet cell
|
|
Ctrl +:(colon)
|
|
|
Ctrl + ; (semi-colon)
|
|
|
Ctrl + D
|
|
|
Ctrl + CD
|
Explanation:
Detailed explanation-1: -On a worksheet, select the cell into which you want to insert the current date or time. Do one of the following: To insert the current date, press Ctrl+; (semi-colon). To insert the current time, 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.
Detailed explanation-3: -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.
There is 1 question to complete.