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 based on exam participation or grades, and how to handle multiple criteria by enclosing each in brackets. The tutorial also covers finalizing the filter formula and formatting the results.

What does the plus operator signify when used in a filter function?

• It applies OR logic.

• It applies AND logic.

• It applies NOT logic.

• It applies XOR logic.

When setting up a filter with multiple criteria, what must be done to each piece of criteria?

• Each must be followed by a semicolon.

• Each must be written in uppercase.

• Each must be enclosed in brackets.

• Each must be separated by a comma.

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

• To specify the default return value if no results are found.

• To add more criteria to the filter.

• To change the data type of the results.

• To apply a different logical operator.

How can you adjust the display format of the results in the filter function?

• By changing the cell format settings.

• By adding more criteria.

• By using a different logical operator.

• By using the plus operator.

What can be used to easily change the criteria in a filter function?

• Conditional formatting.

• Data validation drop-down lists.

• Cell references.

• Array formulas.