How to Insert a Subtotal in an Excel Worksheet


Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

What is an important first step before using the Subtotal command?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. In the lesson, I gave you a tip. Where should the information that you want Excel to group together be?

2. Where in the ribbon will you find the Subtotal command?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

This quiz and corresponding worksheet will help you see what you know about using subtotals in Microsoft Excel. To pass the quiz you will need to know things like the first step before using the subtotal command and where the information should be for Excel to group.

Quiz & Worksheet Goals

These assessments will help you review the following aspects of using Excel:

  • First step before using the subtotal command
  • Where information needs to be for Excel to group it
  • Location of the subtotal command
  • Functions of the subtotal command
  • How to get Excel to count the number of names in a column

Skills Practiced

This worksheet and quiz also help you practice these skills:

  • Reading comprehension - ensure that you draw the most important information from the related lesson on inserting subtotals in Excel
  • Interpreting information - verify you can read information regarding the functions of the subtotal command and interpret it correctly
  • Knowledge application - use your knowledge to answer questions about how to get Excel to count the number of names in a column

Additional Learning

To learn more about how to make this tricky feature easy, review the corresponding lesson called How to Insert a Subtotal in an Excel Worksheet. This lesson will help you:

  • Define what subtotals are
  • Identify the common functions of subtotals
  • Describe how to use the subtotal command
  • Understand the process to insert subtotal rows into worksheet data
  • Appreciate the benefits that can be gained by using subtotals