USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which is the correct shortcut to copy and worksheet to another worksheet in the same workbook?
|
|
Select the sheet to copy, then use Ctrl, drag and drop
|
|
|
Select the sheet to copy, then use drag and drop
|
|
|
Select the sheet to copy, then use Shift, drag and drop
|
|
|
Select the sheet to copy, then use Alt, drag and drop
|
Explanation:
Detailed explanation-1: -Keyboard shortcut: Press CTRL+Spacebar, on the keyboard, and then press Shift+Spacebar. Copy all the data on the sheet by pressing CTRL+C. Click the plus sign to add a new blank worksheet. Click the first cell in the new sheet and press CTRL+V to paste the data.
Detailed explanation-2: -Use the keyboard shortcuts CTRL + PAGE UP and CTRL + PAGE DOWN. These keyboard shortcuts are probably the quickest and easiest way to move between sheets in Excel. Simply press CTRL + PAGE UP to move to the previous sheet, or CTRL + PAGE DOWN to move to the next sheet.
There is 1 question to complete.