DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Hold down the ____ key to while dragging a worksheet tab to make a copy of it.
|
|
CTRL
|
|
|
ESC
|
|
|
SHIFT
|
|
|
ALT
|
Explanation:
Detailed explanation-1: -Simply hold down the Ctrl key, then click and drag the sheet’s tab. When you release the mouse, Excel will create an exact copy of the sheet.
Detailed explanation-2: -Keyboard shortcut: Press CTRL+Spacebar and then press Shift+Spacebar. Copy all the data on the sheet by pressing CTRL+C.
Detailed explanation-3: -To copy cells using the mouse, first select the cells you want to copy. Then press and hold down the Ctrl key on your keyboard while you drag the cells to their new location.
Detailed explanation-4: -To use this shortcut, simply hold down the Ctrl key and then press the semicolon key, and it will instantly add the current date.
There is 1 question to complete.