Share/Like This Page
Print Instructions

NOTE: Only your test content will print.
To preview this test, click on the File menu and select Print Preview.




See our guide on How To Change Browser Print Settings to customize headers and footers before printing.

Excel Shortcuts (Grade 8)

Print Test (Only the test content will print)

Excel Shortcuts

Instructions: Choose the appropriate Excel shortcuts for the tasks described.

1. 
Which shortcut allows you to move to the next worksheet (on the right)?
  1. CRTL + PgDn
  2. Shift + PgDn
  3. CRTL + PgUp
  4. Shift + N
2. 
If a ribbon is taking up too much space on your page you can collapse (or expand) it by selecting
  1. CTRL+ C.
  2. Alt+ C.
  3. CRTL + F1.
  4. Alt + F1.
3. 
Which shortcut allows you to switch between showing excel formulas or their values in a cell?
  1. CTRL + #
  2. CTRL + ~
  3. CTRL + V
  4. CTRL + Z
4. 
Which shortcut allows you to select all of the cells in a row from top to bottom?
  1. CRTL + PgDn
  2. Shift + CRTL + Down arrow
  3. Shift + Down Arrow
  4. CRTL + S
5. 
The fastest way to rename a worksheet is to
  1. double click it.
  2. select Shift + R.
  3. select CRTL + Right Arrow.
  4. right click and then choose rename.
6. 
Which shortut will enter the current date?
  1. CRTL + :
  2. CTRL + D
  3. CRTL + ;
  4. CTRL + C
7. 
Which shortcut allows you to undo your last action?
  1. CTRL + Z
  2. CTRL+X
  3. CTRL+ C
  4. CRTL + S
8. 
To move between two or more open Excel files
  1. Tab + Shift
  2. Tab + Alt
  3. CTRL + Tab
  4. Tab + 2
9. 
To open a search box
  1. Shift + F4
  2. Shift + F3
  3. Shift + F8
  4. Shift + F6
10. 
The icon in the red box below allows you to
  1. delete an entire worksheet.
  2. select the first cell in a worksheet.
  3. go to the next worksheet.
  4. select an entire workbook.
11. 
To move between worksheets in the same document
  1. CTRL + Page Up
  2. CTRL + Page Down
  3. CTRL + Tab
  4. CTRL + Z
12. 
To go to cell A1 select
  1. CTRL + A.
  2. CTRL + Page Down.
  3. CTRL + Home.
  4. CTRL + 1.
13. 
To spell check a selected cell or spreadsheet, press the function key           .
14. 
To create a chart from the selected data, press the function key             .
15. 
To go to a specific cell, press the function key           .
16. 
To insert a new column press                                       .
17. 
To bold whatever is in your cell, click                + B.
18. 
To create repeat your last action, press the function key           .
19. 
To make your values into currency click CTRL +                  + $.
20. 
CRTL + A is an easy way to "select all" in an Office program, but in Excel what is selected depends upon where your cursor is. If the cursor is in an empty cell, Control + A selects the                                       .
You need to be a HelpTeaching.com member to access free printables.
Already a member? Log in for access.    |    Go Back To Previous Page