FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

What keyboard shortcut moves you “up” a spreadsheet?

A	shift + enter
B	shift + control
C	alt + enter
D	alt + control

Explanation:

Detailed explanation-1: -CTRL+PAGE UP Move to the previous sheet in the workbook. SHIFT+CTRL+PAGE DOWN Select the current and next sheet. To cancel selection of multiple sheets, press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP. SHIFT+CTRL+PAGE UP Select the current and previous sheet.

Detailed explanation-2: -1. Use the keyboard shortcuts CTRL + PAGE UP and CTRL + PAGE DOWN. These keyboard shortcuts are probably the quickest and easiest way to move between sheets in Excel. Simply press CTRL + PAGE UP to move to the previous sheet, or CTRL + PAGE DOWN to move to the next sheet.

Detailed explanation-3: -Shift+Enter Create a soft break instead of a new paragraph.

Detailed explanation-4: -To switch between sheets in Excel using a keyboard shortcut, just press Ctrl+Page Up or Ctrl+Page Down. This will move you to the previous or next sheet in your workbook, respectively. You can also use the Ctrl+Tab shortcut to cycle through all the sheets in your workbook.

Detailed explanation-5: -When you press Ctrl+Shift+Enter, Excel automatically inserts the formula between (a pair of opening and closing braces).

There is 1 question to complete.