Microsoft Excel 2021365 - Beginner to Advanced - The FILTER Function - 2

This video tutorial introduces the filter function in Excel 2021, explaining its basic use and potential applications. It covers preparing data by converting it into a table and creating data validation drop-down lists using the unique function. The tutorial demonstrates how to apply the filter function to display specific data based on criteria such as exam type, date, and grade. It also touches on advanced filtering techniques using multiple criteria and logic to refine results.

What is the primary purpose of the filter function in Excel 2021?

• To calculate the sum of a range

• To filter data based on specified criteria

• To sort data alphabetically

• To format cells with colors

What is the first step to make filtering easier before using the filter function?

• Create a pivot table

• Convert the data into a table

• Use conditional formatting

• Apply a color scheme

Which Excel function is used to create a list of unique exam names for a drop-down list?

• SUM

• AVERAGE

• VLOOKUP

• UNIQUE

What is the optional third argument in the filter function used for?

• To highlight the filtered data

• To specify a default value if no results are found

• To sort the filtered data

• To calculate the average of the filtered data

How can you change the date format in the filtered results?

• By using the SUM function

• By creating a new table

• By applying a short date format

• By using the UNIQUE function

What additional criteria can be used to refine filter results beyond just the exam name?

• Teacher's name

• Exam date and grade

• Exam location

• Student's age

What will the upcoming lessons focus on regarding the filter function?

• Building logic into the filter function

• Creating charts

• Using macros

• Formatting cells