The Complete Excel Guide: Beginners to Advanced - Subtotals

Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Hard
Quizizz Content
FREE Resource
Read more
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary purpose of the subtotal feature in Excel?
To create pivot tables
To divide a list by repeated values and calculate subtotals
To format cells with colors
To create charts and graphs
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which column should you sort by to calculate gross pay totals for each division?
Column B
Column E
Column G
Column A
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the outlining feature in Excel allow you to do?
View different levels of information and expand or collapse data
Create new worksheets
Add comments to cells
Change the font size
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you view only the grand total using the outlining feature?
Click on level 1
Click on level 2
Click on level 4
Click on level 3
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function would you use to count the number of employees paid in a pay period?
Count
Average
Sum
Max
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you ensure both sum and count functions are displayed in the subtotal feature?
Select only the count function
Select only the sum function
Uncheck the 'Replace current subtotals' box
Check the 'Replace current subtotals' box
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What option should you select to remove all subtotals and return to the original data view?
Add page break between groups
Remove all
Replace current subtotals
Expand all
Similar Resources on Wayground
8 questions
Salesforce Platform App Builder Certification Training - Lightning Report Builder

Interactive video
•
University
3 questions
The Complete Excel Guide: Beginners to Advanced - Module 14 - Practice Exercise

Interactive video
•
University
2 questions
The Complete Excel Guide: Beginners to Advanced - Creating an Outline

Interactive video
•
University
6 questions
Business Intelligence with Microsoft Power BI - with Material - Sub-Total and Total in a Matrix

Interactive video
•
University
6 questions
Microsoft Excel 2021365 - Beginner to Advanced - Applying Subtotals and Grand Totals

Interactive video
•
University
6 questions
Microsoft Excel 2021365 - Beginner to Advanced - Creating a PivotTable from Scratch

Interactive video
•
University
6 questions
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - copy-paste data in the blank worksheet

Interactive video
•
University
6 questions
The Complete Excel Guide: Beginners to Advanced - Advanced Filters

Interactive video
•
University
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade