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

This video tutorial demonstrates how to use the filter function in Excel 2021. It starts with basic filtering using a single criterion and progresses to more complex filtering with multiple criteria. The tutorial also covers how to combine the filter and sort functions to create dynamic, sorted lists. The examples use student data to illustrate filtering by exam type, location, and pass marks.

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

• To format cells

• To create charts

• To perform calculations

• To filter data based on criteria

Which of the following is a mandatory argument for the filter function?

• Sort order

• Font size

• Array

• Cell color

When using multiple criteria in the filter function, how are they separated?

• With a comma

• With a semicolon

• With a multiplication sign

• With a plus sign

What happens if the filter function does not find any matching records?

• It returns a blank cell or specified text

• It highlights the cell in red

• It displays a default message

• It returns an error

In the advanced example, what additional function is combined with filter?

• SUM

• AVERAGE

• SORT

• COUNT

How can you sort the filtered results in descending order?

• By using the SORT function with a descending argument

• By applying conditional formatting

• By manually rearranging the cells

• By using the AVERAGE function

What is the correct way to specify a sort index in the SORT function?

• By using the sheet name

• By using the column name

• By using the row number

• By using the column number