The Complete Excel Guide: Beginners to Advanced - Module 14 - Practice Exercise

The video tutorial guides students through exercises involving outlining and subtotaling in Excel. It begins with an introduction to the exercises, focusing on using the outlining feature in a file called 'book sales'. Students then work on calculating subtotals in a file named 'subtotals', including determining gross pay per department and using the outlining feature to display different levels. The tutorial concludes with a transition to module 15, which covers working with different views in Excel.

What is the first task you need to perform in the 'book sales' file?

• Calculate subtotals

• Enable the outlining feature

• Add a new worksheet

• Create a pivot table

In the 'subtotals' file, what is the first calculation you need to perform?

• Net pay per department

• Average sales per employee

• Gross pay per department

• Total sales per region

Which feature is used to display different levels of data in the exercises?

• Conditional formatting

• Pivot table

• Outlining feature

• Data validation

What additional feature is added to the 'subtotals' file after calculating gross pay?

• Data filtering

• Chart creation

• Account feature

• Data sorting

What is the next topic introduced after completing the exercises on outlining and subtotaling?

• Advanced formulas

• Data visualization

• Macros and automation

• Working with different views in Excel