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

This video tutorial covers sorting and filtering data in Excel. It explains how to perform single and double level sorts, such as sorting by last name or by division and last name. The tutorial also teaches how to filter data based on specific criteria and how to clear filters. The module concludes with a transition to the next topic, outlining and subtotaling in Excel.

What is the primary focus of single-level sorting?

• Sorting by multiple criteria

• Sorting by a single criterion

• Filtering data based on conditions

• Clearing all sorts and filters

Which of the following is an example of a double sort?

• Sorting by last name only

• Sorting by date of birth

• Sorting by first name and age

• Sorting by division and then last name

What does filtering data allow you to do?

• Sort data by multiple levels

• Display only data that meets certain criteria

• Remove duplicates from the dataset

• Highlight specific data points

How can you clear filters applied to your data?

• By applying a new sort

• By selecting 'Clear Filters' option

• By closing the spreadsheet

• By saving the document

What is the next module about after completing this one?

• Data visualization

• Outlining and subtotaling in Excel

• Creating pivot tables

• Advanced filtering techniques