facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Excel Keyboard Shortcuts for Worksheets Test

Free Online Microsoft Excel Tests
Excel 2010 & Excel 2013 Training

* Shortcuts for Moving Around Cells
* Shortcuts for Moving to The Beginning and End of Your Data
* Shortcuts for Selecting Rows and Columns
* Shortcuts for The Go To Dialogue Box
* Shortcuts to Undo and Redo


10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Excel Keyboard Shortcuts for Worksheets Test

1) To quickly move back to the first cell of your worksheet (usually A1), which shortcut combination would you use?
a) I would press Ctrl+Up Arrow Key.
b) I would press Ctrl+Page Up.
c) I would press Ctrl+Home.
d) I would press Ctrl+Space.

2) Study the screenshot below this question.  Which shortcut key combinations would you use to quickly select the column or the row that the selected cell (E11) is situated in?
a) Shift+Space and Ctrl+Space
b) Ctrl+Shift+Space and Ctrl+Space
c) Ctrl+Shift and Ctrl+Space
d) Ctrl+a and Ctrl+Shift+a
Question 2 - Microsoft Excel Tests -
            Keyboard Shortcuts for Worksheets

3) Study the dialogue box circled in yellow in the screenshot below this question.  Which of the following shortcut key combinations will launch this dialogue box?
a) Ctrl+f and/or F5
b) Shift+g and/or F5
c) Ctrl+Shift+F5 and/or Shift+g
d) Ctrl+g and/or F5
Question 3 - Microsoft Excel Tests -
            Keyboard Shortcuts for Worksheets

4) The ability to quickly move from the end of a row back to the first cell in a row, especially in a worksheet where rows span several columns. Which of the following shortcut keys will allow you to do this?
a) Ctrl+b and Ctr+h
b) Ctrl+Home and Ctrl+End
c) The Home key
d) None of the above options are correct.

5) What is the purpose of the Page Up and Page Down keys?
a) They do not have a purpose in Excel.
b) They move the visible sheet up a paper size or down a paper size.
c) They move to the next worksheet and back again.
d) They move the visible screen up or down.

6) If you quickly want to undo or redo an action in Excel, which shortcut keys would you use?
a) Ctrl+z and Ctrl+y
b) Ctrl+u and Ctrl+r
c) Ctrl+un and Ctrl+re
d) All of the above shortcut keys will work.

7) If you wanted to reformat your entire worksheet, for example to change the font, which shortcut key combination could you use to quickly select the whole worksheet?
a) Ctrl+Shift+Spacebar
b) Ctrl+a
c) Shift+a
d) Alt+a

8) When entering data in Excel it may be inconvenient to have to use the mouse to move to the left or right through cells in a row.  Which shortcut key combination could you use to move to the left or right through cells in a row?
a) Tab and Shift+Tab or the right and left arrows
b) Enter and Shift+Enter or the right and left arrows
c) Ctrl+l and Ctrl+r or the right and left arrows
d) All of the above options are correct.

9) Which shortcut key combination allows you to quickly select multiple adjacent groups of cells? 
a) Alt+Arrow Keys
b) Ctrl+a
c) Ctrl+Arrow Keys
d) Ctrl+Shift+Arrow Keys

10) Study the screenshot of a worksheet below this question.  The selected cells are the ones containing the heading “My Candy Shop Sales”. How can you quickly select only the data set that belongs to this heading (i.e. all the cells that contain data)? 

a) By pressing Ctrl+Shift+End
b) By pressing Ctrl+Shift+a
c) By pressing Shift+Down Arrow
d) All of the above options are correct.

Question 10 - Microsoft Excel Tests -
            Keyboard Shortcuts for Worksheets