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
Free Excel Test – Using Data Outline Tools – Excel 2010 Training
Using Data Outline Tools Excel Test
Free Online Microsoft Excel Test
Excel 2010 Training – Working with Data
* Creating an Outline
* Viewing Sections of an Outline
* Inserting Subtotals
* Clearing an Outline
10 Question Multiple Choice Quiz with Answers
and Answer Explanations
Using Data Outline Tools Excel Test
1)
Study the screenshot above. James wishes to automatically outline sections in a worksheet and display a sum total for each section. He keeps clicking on the button highlighted in yellow in the screenshot above, but this is not having the desired effect. What is he doing wrong?
a) He didn’t select the cell ranges to outline before trying to AutoSum them.
b) He needs to first create an Outline using the Group button and then use the AutoSum function.
c) He needs to use the Subtotal function in the Outlining group, not the AutoSum function.
d) None of the options listed above are correct.
2)
Study the screenshot above. What happens when you press the minus symbol (circled in yellow)?
a) This will expand the section of the Outline that has been applied to the worksheet.
b) This will collapse the section of the Outline that has been applied to the worksheet.
c) This will close the section of the Outline that has been applied to the worksheet.
d) This will restore the section of the Outline that has been applied to the worksheet.
3)
Where would you find the Subtotal function?
a) Under the Formula tab on the Ribbon in the Function Library group.
b) Under the Home tab on the Ribbon in the Quick Sum gallery.
c) Under the Insert tab on the Ribbon in the Outlining group.
d) Under the Data tab on the Ribbon in the Outlining group.
4)
Sally impressed her boss by creating an Outline of data in a worksheet with each section containing a Subtotal. Her boss wishes to print each of the 300 sections and their totals on a separate page. Which of the following options will succeed in doing this in most EFFICIENT way?
a) This is a print setting. Set the printer to print each page on a separate piece of paper.
b) Insert manual page breaks by using the
Insert Page Break
function located under the Page Layout tab on the Ribbon.
c) Select the data, launch the Subtotal dialog box and tick the box for
Page Break Between Groups
.
d) All of the options listed above are correct.
5)
Study the screenshot above. What are the numbers circled in yellow?
a) These are column and row level symbols. Pressing them will expand/collapse sections that have been grouped together.
b) These are column and row labels. They indicate in which row or column the cursor is located.
c) These are worksheet minimizing and maximizing buttons. They allow you to view multiple worksheets at the same time.
d) These are Subtotal buttons. They allow you to quickly sum and subtract sections that have been grouped together.
6)
How can you remove Subtotals that have been applied using the Outline tool?
a) Select the worksheet, click on the Ungroup button and select
Remove Outline.
b) Select the worksheet, click on the Ungroup button and select
Remove All.
c) Click on the Subtotal button and in the Subtotal dialog box select
Remove All.
d) All of the options listed above are correct.
7)
Kristy wishes to add the average sales for each sales person per product to a worksheet. Where can she find the option to insert Subtotals as averages?
a) In the Subtotal dialog box she needs to change the option below the label,
Use Function,
to Average.
b) After grouping sections using the outline tools, she needs to change the function in each formula from Sum to Average.
c) She needs to insert the formula: =Average() into the Outline dialog box.
d) None of the options listed above are correct.
8)
Study the screenshot above. Are the options listed in the area circled in yellow the ONLY options for places to add a Subtotal to in Excel?
a) Yes, these are built into the Outline function in Excel and cannot be changed.
b) No, these are the default options only. If you right-click and select
Add Option
, you can manually add more options.
c) It only applies to the current worksheet. New worksheets will allow you to create new options.
d) No. These options are based on the column headings in the worksheet which are included in the cell range selection. If you change the column headings, these options will change to match the new column headings.
9)
Study the screenshot above. Will pressing Ungroup CLEAR only the Outline applied to the selected cell range (shaded in blue and circled yellow) or the entire worksheet?
a) It will remove all the outlines, groups and subtotals applied to the worksheet.
b) It will remove all the outlines and groups applied to the worksheet.
c) It will remove all the outlines and groups applied to the selected cell range only.
d) It will not remove any outlines or groups as the whole worksheet is not selected.
10)
Study the worksheet above. Grace is trying to insert a Subtotal for each client, but the sections are not grouping together correctly and not adding up the totals for each client. What appears to be the problem?
a) The worksheet has been sorted according to
Contractor
and not
Client.
b) The subtotals have been added to the
Client
instead of the
Contractor
column.
c) The worksheet has been grouped incorrectly with outlines applied to all the data.
d) The worksheet has been sorted from highest to lowest amounts in the
Last Year
and
Current Year
columns.
* More from TestsTestsTests.com
Please leave this field empty.
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
TEST
8.
Using Financial Functions Excel
TUTORIAL
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
1. Free Excel Templates – get organized
Excel 2016 Articles
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
TEST
7.
Window and Zoom Options in Excel 2016
TUTORIAL
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