USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
CTRL
|
|
|
ESC
|
|
|
SHIFT
|
|
|
ALT
|
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. 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.