FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Use ____ to change the order of the worksheets in a workbook.
A
copy
B
hide
C
unhide
D
move
Explanation: 

Detailed explanation-1: -You can move a sheet to a different position, click and hold the sheet tab at the bottom of the screen with the mouse and drag it to its new position. select Edit → Sheet → Move/Copy from the main menu. Specify the new position of the sheet in the dialog.

Detailed explanation-2: -Use the keyboard shortcut CTRL + TAB This keyboard shortcut works similarly to the previous two, but it has the added benefit of allowing you to move between sheets in both directions. Simply press CTRL + TAB to move to the next sheet, or CTRL + SHIFT + TAB to move to the previous sheet.

Detailed explanation-3: -You can move worksheets with the keyboard by using Ctrl+PgUp and Ctrl+PgDown. Ctrl+PgUp moves toward the first worksheet in the workbook and Ctrl+PgDown moves toward the last.

Detailed explanation-4: -You can also use the “Ctrl+PgUp” and “Ctrl+PgDn” keyboard shortcuts to move between tabs. These shortcuts will move you to the previous or next tab, respectively.

Detailed explanation-5: -Press Ctrl+Page Down to move to the next worksheet. For example, if you’re currently in Sheet1, this key sequence jumps you to Sheet2.

There is 1 question to complete.