facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Navigating Excel Workbooks
& Excel Sheets Test
Excel 2016 Training - Learn Excel Basics Quiz

Free Online Microsoft Excel Tests

* Moving around rows and columns
* Selecting cell ranges
* Moving between worksheets
* Go to specific Excel cells
* Excel Find Function find numbers or words

10 Question Multiple Choice Quiz with Answers and Answer Explanations


Navigating Excel Workbooks & Excel Sheets Test

Question 1 - Navigating Excel Workbooks Excel Sheets Test Excel 2016 Test


1) Study the screenshot above. What would be the quickest way to select the entire row containing Lina Marx’s information?

a) By left clicking on the cell range labelled E.
b) By holding down the control key on your keyboard and selecting all the cells containing her information.
c) By clicking on row label 9.
d) None of the above options are correct.
2) What is the shortcut key combination for moving to the end of a column within an Excel worksheet?
a) Hold down the Shift key and click on the column label.
b) Hold down the Control key and press the down arrow on your keyboard.
c) Hold down the Spacebar whilst pressing the down arrow on your keyboard.
d) Hold down the Alt key and press the down arrow on your keyboard twice.


Question 3 - Navigating Excel Workbooks Excel Sheets Test Excel 2016 Test
3) In the screenshot example above, how can you select the Title, Initial and Surname columns, but leave the other columns unselected?
a) Hold down the Control key and left click the column labels: A, B and D.
b) Left click to select column A, then hold down the mouse button and select columns B and D.
c) Left click the column labels: A, B and D.
d) It is not possible to select columns which are not next to each other.

4) What is the short cut key combination for launching the Go To dialog box?
a) Hold down the Control key and press the F key. 
b) Hold down the Shift key and press the G key.
c) Hold down Control and Shift keys simultaneously and press the G key.
d) Hold down the Control key and press the G key.



5)Where will you find an option to quickly select the cell ranges that contain formulas in an Excel worksheet?
a) Select the whole worksheet and click on the Formulas tab on the Ribbon.
b) In the Go To Special dialog box, click on Formulas to select all cells containing formulas.
c) In the Go To dialog box, type Formulas into the Reference box.
d) Hold down the Control key on your keyboard and use the arrow keys to navigate to the formulas.

Question 6 - Navigating Excel Workbooks Excel Sheets Test Excel 2016 Test


6) Study the screenshot above.  What will happen if you left click the triangular shape outlined in orange?
a) The whole worksheet will be selected.
b) Both the row and column labels will be selected.
c) The column labels will all be selected.
d) Nothing will happen, this is not a button.

Question 7 - Navigating Excel Workbooks Excel Sheets Test Excel 2016 Test


7) Study the screenshot above. What is the purpose of the left and right pointing arrows outlined in orange?
a) These are the row scrolling buttons. They allow the user to move through all the cells in a row.
b) These are the column scrolling buttons. They allow the user to move through all the cells in a column.
c) These are the worksheet navigation tabs. They allow the user to move through all the worksheets in a workbook.
d) These are the row selector tabs. Hold down the Control key and press either of these arrows to move to the end of a row.


8) What happens when you hold down the Control key and press the F key on your keyboard?
a) This will launch the Find dialog box.
b) This will select the entire column F in the worksheet.
c) This will launch the Go To Special dialog box.
d) This will find all cells in a worksheet containing words that start with the letter F.



Question 9 - Navigating Excel Workbooks Excel Sheets Test Excel 2016 Test
9) Study the screenshot above.  How do you select the cell range outlined in orange, D4:G8 ?
a) Hold down the Control key on your keyboard, press the left mouse key and select the cells in that range.
b) Launch the Find dialog box and type D4:G8 into the Find What box.
c) Left click to select cell D4 and then hold down the left mouse button, dragging it to the right to column G and down to row 8.
d) Hold down the Control key and press the right arrow to select the cells between D4 and G8.


Question 10 - Navigating Excel Workbooks Excel Sheets Test Excel 2016 Test
10) Study the screenshot above.  Which worksheet is currently active in the Excel screen?
a) The Product List worksheet is selected.
b) The Shopping Items worksheet is selected.
c) The Shopping List worksheet is selected.
d) None of the worksheets are selected.

 

Captcha Image