Home
Microsoft Office Index
Excel
Word
PowerPoint
A~Z Quizzes
Computer Programming
Typing Index
Typing Speed Test
English Lessons & Practice Grammar Tests
Excel 2016
Word 2016
www.TestsTestsTests.com
Microsoft Excel FREE Resources Index Page
*45
Excel Tests & Quizzes
*
43 Excel Tutorials
*
Excel Training
*
43 Excel Tutorials with 42 Corresponding Tests
*
What is Excel?
*
What version of Excel?
*
Excel 2016 Tutorials & Excel Test Index
Moving Around the Worksheet Test
(with the Mouse, Keystrokes and Go To)
Free Online Microsoft Excel Tests
Excel 2010 - Getting Started
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.
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.
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.
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.
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.
* More from TestsTestsTests.com
1. Excel Keyboard Shortcuts
6 TUTORIALS & 7 TESTS
1.
Easy Excel Shortcuts
TEST
2.
Intermediate Excel Shortcuts
TEST
3.
Keyboard Shortcuts for Worksheets
TUTORIAL
3.
Keyboard Shortcuts for Worksheets
TEST
4.
Keyboard Shortcuts for Cell Contents
TUTORIAL
4.
Keyboard Shortcuts for Cell Contents
TEST
5.
Shortcuts for Inserting & Deleting Rows,
Columns & Cells
TUTORIAL
5.
Shortcuts for Inserting & Deleting Rows,
Columns & Cells
TEST
6.
Keyboard Shortcuts for Formatting Numbers
TUTORIAL
6.
Keyboard Shortcuts for Formatting Numbers
TEST
7.
Keyboard Shortcuts for Formulas
TUTORIAL
7.
Keyboard Shortcuts for Formulas
TEST
8.
30 second Shortcuts Video Part 1
TUTORIAL
2. Getting Started in Excel
6 TUTORIALS & 7 TESTS
1.
Excel Basics
TUTORIAL
1.
Excel Basics
TEST
2.
Using the File Tab
TUTORIAL
2.
Using the File Tab
TEST
3.
The Views in Excel
TUTORIAL
3.
The Views in Excel
TEST
4.
Moving Around the Worksheet
TUTORIAL
4.
Moving Around the Worksheet
TEST
5.
Using the Ribbon Excel
TUTORIAL
5.
Using the Ribbon Excel
TEST
6.
Customizing the Quick Access Toolbar
TUTORIAL
6.
Customizing the Quick Access Toolbar
TEST
7.
The Excel Screen
TEST
3. Entering Data in Excel
4 TUTORIALS & 4 TESTS
1.
Basic Data Entry & Navigation
TUTORIAL
1.
Basic Data Entry & Navigation
TEST
2.
Copying and Pasting Excel
TUTORIAL
2.
Copying and Pasting Excel
TEST
3.
Using Autofill Excel
TUTORIAL
3.
Using Autofill Excel
TEST
4.
Formatting Text Excel
TUTORIAL
4.
Formatting Text Excel
TEST
4. Formulas & Functions
8 TUTORIALS & 8 TESTS
1.
Excel Formula Basics
TUTORIAL
1.
Excel Formula Basics
TEST
2.
Copying Formulas & using Relative &
Absolute Cell References
TUTORIAL
2.
Copying Formulas & using Relative &
Absolute Cell References
TEST
3.
Excel Formatting Numbers Basics
TUTORIAL
3.
Excel Formatting Numbers Basics
TEST
4.
Understanding Functions
TUTORIAL
4.
Understanding Functions
TEST
5.
Using IF, SUMIF and COUNTIF
TUTORIAL
5.
Using IF, SUMIF and COUNTIF
TEST
6.
Nested IFs, SUMIFs & COUNTIFs
in Functions
TUTORIAL
6.
Nested IFs, SUMIFs & COUNTIFs
in Functions
TEST
7.
Using Nested Functions
TUTORIAL
7.
Using Nested Functions
TEST
8.
Using Financial Functions Excel
TUTORIAL
8.
Using Financial Functions Excel
TEST
5. Excel Worksheets
4 TUTORIALS & 4 TESTS
1.
Excel Basic Worksheet Formatting
TUTORIAL
1.
Excel Basic Worksheet Formatting
TEST
2.
Advanced Worksheet Formatting
TUTORIAL
2.
Advanced Worksheet Formatting
TEST
3.
Protecting Worksheets Excel
TUTORIAL
3.
Protecting Worksheets Excel
TEST
4.
Working with Multiple Worksheets
TUTORIAL
4.
Working with Multiple Worksheets
TEST
6. Excel Charts
1 TUTORIAL & 1 TEST
1.
Creating & Modifying Excel Charts
TUTORIAL
1.
Creating & Modifying Excel Charts
TEST
7. Printing Excel Worksheets
2 TUTORIALS & 2 TESTS
1.
Printing Basics Excel
TUTORIAL
1.
Printing Basics Excel
TEST
2.
Printing Large Excel Worksheets
TUTORIAL
2.
Printing Large Excel Worksheets
TEST
8. Macros in Excel
1 TUTORIAL & TEST
1.
Using Macros Excel
TUTORIAL
1.
Using Macros Excel
TEST
9. Working with Data in Excel
10 TUTORIALS & 10 TESTS
1.
Sort and Filter Data in Excel
TUTORIAL
1.
Sort and Filter Data in Excel
TEST
2.
Concatenate Function, Convert Text to Columns & Remove Duplicates
TUTORIAL
2.
Concatenate Function, Convert Text to Columns & Remove Duplicates
TEST
3.
Conditional Formatting Excel
TUTORIAL
3.
Conditional Formatting Excel
TEST
4.
Using Data Outline Tools
TUTORIAL
4.
Using Data Outline Tools
TEST
5.
What-If Analysis Excel
TUTORIAL
5.
What-If Analysis Excel
TEST
6.
Using Data Validation Tools
TUTORIAL
6.
Using Data Validation Tools
TEST
7. VLOOKUP & INDEX-MATCH
TUTORIAL
Using Formulas to Look Up Data
7. VLOOKUP & INDEX-MATCH
TEST
Using Formulas to Look Up Data
8.
Formulas to Manipulate & Clean Data
TUTORIAL
8.
Formulas to Manipulate & Clean Data
TEST
9.
Data Forms Excel
TUTORIAL
9.
Data Forms Excel
TEST
10.
Pivot Tables Excel
TUTORIAL
10.
Pivot Tables Excel
TEST
10. Images & Graphical Elements
1 TUTORIAL & 1 TEST
1.
Images & Graphical Elements
TUTORIAL
1.
Images & Graphical Elements
TEST
11. More Microsoft Excel
1. Excel Training & Excel MOS Exams Explained
2. What is Microsoft Excel?
3. What MS Excel Training is best for you?
QUIZ
4. What version of Excel are you using?
Excel Tutorials & Tests Index Page
Excel Tutorials Index Page
Excel Tests Index Page
Microsoft Office Index Page
EXCEL 2016 INDEX - TUTORIALS & TESTS
Excel 2016 Articles
1. Free Excel Templates - get organized
1. Learn Excel Basics - Excel 2016
7 TUTORIALS & 7 TESTS
1.
What’s New in Excel 2016?
TUTORIAL
1.
What’s New in Excel 2016?
TEST
2.
Parts of the Excel Screen
TUTORIAL
2.
Parts of the Excel Screen
TEST
3.
Navigating Workbooks & Sheets
TUTORIAL
3.
Navigating Workbooks & Sheets
TEST
4.
The File Tab & Backstage View
TUTORIAL
4.
The File Tab & Backstage View
TEST
5.
Making Excel View Types Work for You
TUTORIAL
5.
Making Excel View Types Work for You
TEST
6.
Mastering the Ribbon & QAT (Quick Access Toolbar)
TUTORIAL
6.
Mastering the Ribbon & QAT (Quick Access Toolbar)
TEST
7.
Window and Zoom Options in Excel 2016
TUTORIAL
7.
Window and Zoom Options in Excel 2016
TEST
2. Data Entry & Formatting - Excel 2016
5 TUTORIALS & 5 TESTS
1.
Adding Text & Numbers to a Worksheet
TUTORIAL - Excel 2016
1.
Adding Text & Numbers to a Worksheet
TEST - Excel 2016
2.
Formatting Text & Numbers
TUTORIAL - Excel 2016
2.
Formatting Text & Numbers
TEST - Excel 2016
3.
Aligning Cell Content
TUTORIAL - Excel 2016
3.
Aligning Cell Content
TEST - Excel 2016
4.
Customizing Number & Text Formats
TUTORIAL - Excel 2016
4.
Customizing Number & Text Formats
TEST - Excel 2016
5.
How to Add Excel Borders & Shading to Cells
TUTORIAL - Excel 2016
5.
How to Add Excel Borders & Shading to Cells
TEST - Excel 2016
3. Excel Formulas & Functions 2016
3 TESTS
1. VLOOKUP & INDEX-MATCH TEST
Excel 2016
2. HLOOKUP, VLOOKUP & INDEX-MATCH TEST Excel 2016
3. How to use VLOOKUP in Excel TEST 2016
4. Excel Data Analysis ToolPak
1 TUTORIAL & 1 TEST
1. t-Test in Excel, F-test and z-Test
TUTORIAL - Excel 2016
1. t-Test in Excel, F-test and z-Test
QUIZ - Excel 2016