Microsoft Excel 2021365 - Beginner to Advanced - Using the Advanced Filter

What is one of the most underrated commands in Excel according to the video?

• Data Validation

• Conditional Formatting

• Advanced Filter

• Pivot Table

What is the primary purpose of using the advanced filter in the first example?

• To highlight duplicate entries

• To extract a unique list of sales reps

• To sort data alphabetically

• To calculate total sales

Which tab in Excel contains the advanced filter option?

• Home

• Data

• Insert

• Review

What criteria were used to filter data in the second example?

• Region is Africa and sales total is greater than 10000

• Region is America and sales total is exactly 7000

• Region is Asia and sales total is greater than 7000

• Region is Europe and sales total is less than 5000

What must be done to perform an OR filter using the advanced filter?

• Use a separate worksheet for each criterion

• List criteria one above the other

• Use a different filter for each criterion

• List criteria side by side

In the OR filter example, which sales reps were used as criteria?

• Tom and Jerry

• Ben and Deb

• Alice and John

• Mike and Sarah

What is a key benefit of using the advanced filter in Excel?

• It sends data via email

• It automatically updates data

• It creates charts and graphs

• It allows for complex criteria filtering