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

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

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

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.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF