DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Most workbooks in Excel contain multiple worksheets (noted on the tabs at the bottom right-hand side of the Excel screen). Which of the following is the keyboard shortcut to for switching between worksheet tabs?
|
Alt+Tab
|
|
Alt+PgDn/PgDn
|
|
Ctrl+UpArrow/DownArrow
|
|
Ctrl+PgDn/PgUp
|
Explanation:
Detailed explanation-1: -3) The correct answer is d. You can use either Ctrl+PgDn or Ctrl+PgUp to switch between the available worksheets in a workbook. Press this shortcut repeatedly to navigate through the available worksheets.
Detailed explanation-2: -Ctrl + Tab This shortcut will open up the Sheet Tabs dialog box, which allows you to quickly select the sheet you want to move to.
Detailed explanation-3: -Right Click in Excel Using the Keyboard (SHIFT + F10)
Detailed explanation-4: -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.
There is 1 question to complete.