Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: + Operator (OR)

The video tutorial explains how to use the filter function in spreadsheets to apply multiple criteria using the plus operator, which acts as an OR formula. It demonstrates filtering students who sat the maths exam or achieved a grade of C, and how to extend this logic to other criteria. The tutorial includes a step-by-step example, showing how to select data, apply criteria, and format results.

What does using the plus operator in a filter function allow you to do?

• Apply AND logic to the criteria

• Apply OR logic to the criteria

• Sort the data in ascending order

• Filter only for students who failed

When setting up multiple criteria in a filter function, what must you do with each criterion?

• Encase each in brackets

• Write them in a single line

• Place them in separate cells

• Use a comma to separate them

What is the purpose of the optional argument in the filter function?

• To sort the results alphabetically

• To change the data type of the results

• To add more criteria to the filter

• To specify the default value if no results are found

How can you apply different criteria using data validation lists in the filter function?

• By using a separate filter function for each criterion

• By selecting different criteria from the drop-down lists

• By manually entering each criterion

• By using a different operator for each criterion

What is the result of applying the filter function with the plus operator to a dataset?

• It returns records that meet any of the specified criteria

• It returns records that meet all specified criteria

• It returns records in a random order

• It returns only the first matching record