facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Easy Excel Shortcuts Test

Free Online Microsoft Excel Tests
Excel 2010 & Excel 2013

Easy  Excel Shortcuts Everyone Should Know
* Shortcuts make performing tasks that you frequently perform in Excel, quick and easy. 
* A number of keyboard combinations provide quick access to specific tasks. 

10 Question Multiple Choice Quiz with Answers
and Answer Explanations



Easy Excel Shortcuts Test

Question 1 - Easy Excel Shortcuts Test
1) Study the screenshot above. You will note Row 2 is selected.  What happens when you press Ctrl+Shift++(plus) with a row selected?
a) The SUM of the values in the row is calculated.
b) The contents of the row is copied.
c) A new row is inserted above the selected row.
d) A new column is inserted to the right of the selected row.
2) What is the keyboard shortcut to select a row of active cells?
a) Shift + Spacebar
b) Ctrl + Spacebar
c) Shift + End
d) Ctrl + End
3) 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

4) What happens when you select cells and press Ctrl+2?
a) Text in the selected cells are underlined.
b) Bold formatting is applied to the text in the selected cells.
c) Italic formatting is applied to the text in the selected cells.
d) A duplicate of the selected cells will be inserted directly below the selection.


5) What is the keyboard shortcut for reversing (undoing) your last action?
a) Ctrl+U
b) Ctrl+X
c) Ctrl+Y
d) Ctrl+Z

6) Which shortcut key combination can be used to insert the current date into a cell?
a) Ctrl+D
b) Ctrl+; (semicolon)
c) Ctrl+Shift+; (semicolon)
d) Ctrl+Shift+D

7) What happens when you press the shortcut combination Ctrl+i while you have cells, containing content such as text or numbers, selected?
a) This italicizes the selected content.
b) This launches the Excel Information and Help dialogue box.
c) This inserts a new row or column depending on the selection.
d) This hides the selected cell range.

8) What is the shortcut key to save a workbook?
a) Ctrl+Enter
b) Ctrl+Shift+S
c) Alt+S
d) Ctrl+S



9) Selecting multiple columns, especially if they run into the hundreds, can take a long time if you do this the manual way by using your mouse.  What is a shortcut for quickly selecting a range of contiguous columns?
a) Select the first column.  Hold down Ctrl and press the right arrow on the keyboard.
b) Select the first column.  Hold down Ctrl and drag the mouse cursor towards the right.
c) Select the first column.  Hold down Shift and press the right arrow on the keyboard.
d) All of the above options are correct.


Question 10 - Easy Excel Shortcuts Test
10) Study the screenshot of the Format Cells dialogue box above.  Which of the following shortcut combinations launches this dialogue box?  

a) Ctrl+1
b) Ctrl+Shift+F
c) Ctrl+F
d) Ctrl+F1