facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Moving Around the Worksheet Test

Free Online Microsoft Excel Tests
Excel 2010 - Getting Started

(with the Mouse, Keystrokes and Go To)
10 Question Multiple Choice Quiz with Answers



Moving Around the Worksheet Test

1) Study the image of a sample worksheet below this question.  If you wanted to navigate to the cell reference G29, which of the following methods could you use?
a) Use the Control key together with the scrolling wheel on your mouse to scroll down to cell G29.
b) Use the down arrow direction key on the keyboard, holding it down or pressing it repeatedly to get to cell G29.
c) Use the vertical scroll bar on the right-hand side of the screen to scroll down so that you may view and select cell G29.
d) All of the above are correct.
Question 1 - Moving Around the Worksheet Test

2) Jenny's boss asks her to highlight all the formulas in a spreadsheet for him so that he could look at them before using the worksheet in a presentation.  How can Jenny quickly find all these formulas?
a) Use the arrow directional buttons on the keyboard to move through the cells in the worksheet and marking all cells individually that contain a formula.
b) Use the Go To Special function located in the Editing group under Find & Select and select 'Formulas' from the list.
c) Use the Go To function and insert the cell reference into the References box.
d) Press the Select All button to select the entire worksheet, formulas will automatically be selected.

3) Study the image below this question.  What do the list of words (circled in orange) in the Go To dialogue box represent?
a) These represent named cell references in the worksheet.  Clicking on an item in the list and pressing OK will select the named cell reference.
b) These represent column headings in the worksheet.  Clicking on an item in the list and pressing OK will take you to that heading.
c) These represent formulas in the worksheet.  Clicking on an item in the list and pressing OK will take you to that formula.
d) None of the above options are correct.
Question 3 - Moving Around the Worksheet Test

4) Which of the options below is a method for selecting multiple non-adjacent cells/ rows or columns?
a) Click on the row/column label, hold the left mouse button down whilst dragging through all the cells/ rows or columns you wish to select.
b) Open the Go To dialogue box.  In the Reference box type all the references you wish to select separated by a semicolon and press OK.
c) Hold down the Control key on your keyboard whilst using your mouse to select cells/rows or columns.
d) All of the above options are correct.
5) Study the image below this question.  What happens if you press the icon circled in orange located at the top left-hand corner of the worksheet?
a) Nothing, this is just an image that separates the row and column labels.
b) This will select all the cells in the region that contain data.
c) This will select all the row and column labels.
d) This will select the entire worksheet.
Question 5 - Moving Around the Worksheet Test

6)Which of the following shortcut keys represent a method of moving to the last cell containing data in a section/region?
a) Press the End key.
b) Press Control + End on your keyboard.
c) Press Control + Shift + End on your keyboard.
d) All of the above are correct.

7) Which of the following is the quickest method for selecting an entire column?
a) Hold down the Control key whilst pressing the down arrow on your keyboard to select the column.
b) Select a cell in the column, click and hold down your left mouse button whilst dragging down through the column to select it.
c) Click on the column label using your mouse.
d) Select the first cell in the column, press Control + Shift + End.

8) Which of the following is the quickest method for navigating to the beginning and/or end of data in a worksheet region?
a) Using the shortcut combination: Control + Home to go to the beginning; or Control + End to go to the end.
b) Scroll up or down using the vertical navigation bar located on the right-hand side of the screen. 
c) Scroll down using your mouse wheel.
d) Press the Home key to go to the beginning and End key to go to the end of the region.

9) Matt is a new HR manager.  He inherited an Excel workbook that contains employee information.  He wants to view the worksheet that contains the employees' salaries, but this worksheet appears to be missing from his workbook.  The HR head insists that the workbook DOES contain this worksheet.  Study the image of Matt's workbook below this question.  How can Matt find the missing worksheet?
a) Matt can use the Go To function to find the missing worksheet by typing 'Salaries' into the Go To reference box.
b) Matt can scroll to the end of the current worksheet by pressing Control + End (twice).  The next worksheet will be visible from there.
c) Matt can use the navigation buttons located to the left of the worksheet tabs to scroll through the available worksheets.
d) Matt can use the horizontal scrollbar to navigate to the end of the list of available worksheets.
Question 9 - Moving Around the Worksheet Test

10) What is a quick way of finding any blank cells in a region of data?
a) Use the Go To Special function and select 'blanks' from the list.
b) Use the Go To Special function and select 'current region' to highlight only cells containing data.
c) Use the Select All button to select the entire worksheet (it will automatically exclude blank cells).
d) Use the Go To function and type 'Blank' into the Reference box to find empty cells.