DATABASE FUNDAMENTALS
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: -To switch between sheets in Excel using a keyboard shortcut, just press Ctrl+Page Up or Ctrl+Page Down. This will move you to the previous or next sheet in your workbook, respectively. You can also use the Ctrl+Tab shortcut to cycle through all the sheets in your workbook.
Detailed explanation-3: -Select File > Save As > Download a Copy.
There is 1 question to complete.