The Complete Excel Guide: Beginners to Advanced - Subtotals

This video tutorial covers the outlining and subtotaling features in Excel. It begins with an introduction to the subtotal feature, explaining how to prepare data by sorting it. The tutorial then provides a step-by-step guide on using the subtotal feature, exploring various options and functions available. Advanced techniques for subtotaling are also discussed, including how to use multiple functions and manage page breaks. The video concludes with a summary and a transition to the next module on different Excel views.

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

Which column should you sort by to calculate gross pay totals for each division?

• Column B

• Column E

• Column G

• Column A

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

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

What function would you use to count the number of employees paid in a pay period?

• Count

• Average

• Sum

• Max

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

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