FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

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?
A
Alt+Tab
B
Alt+PgDn/PgDn
C
Ctrl+UpArrow/DownArrow
D
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: -Ctrl + End-This shortcut key will take you to the bottom of your spreadsheet, no matter how many rows you have. Ctrl + Home-This shortcut key will take you to the top of your spreadsheet. Ctrl + Page Down-This shortcut key will take you to the next page of your spreadsheet.

There is 1 question to complete.