FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

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: -Alternatively, you can press Ctrl+Tab to bring up the Workbook Tabs dialog box, which allows you to select a sheet from a list. You can also quickly switch between sheets using the Sheet Tab bar at the bottom of the Excel window. Just click on the tab of the sheet you want to switch to.

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: -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.

There is 1 question to complete.