USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
<Ctrl+Page up>
|
|
|
<Shift+Page up>
|
|
|
<Ctrl+Spacebar>
|
|
|
<Alt+Page down>
|
Detailed explanation-1: -CTRL+PAGE UP Move to the previous sheet in the workbook. SHIFT+CTRL+PAGE DOWN Select the current and next sheet. To cancel selection of multiple sheets, press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP.
Detailed explanation-2: -Detailed Solution. The correct answer is Ctrl and Home. CTRL + home brings you back to the top of the sheet.
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: -The “SHIFT + F11” key is the shortcut key to insert a new worksheet. We can use the “Ctrl + Drag” keys.