Microsoft Excel 2021365 - Beginner to Advanced - Using the Advanced Filter

Microsoft Excel 2021365 - Beginner to Advanced - Using the Advanced Filter

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is one of the most underrated commands in Excel according to the video?

Data Validation

Conditional Formatting

Advanced Filter

Pivot Table

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary purpose of using the advanced filter in the first example?

To highlight duplicate entries

To extract a unique list of sales reps

To sort data alphabetically

To calculate total sales

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which tab in Excel contains the advanced filter option?

Home

Data

Insert

Review

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What criteria were used to filter data in the second example?

Region is Africa and sales total is greater than 10000

Region is America and sales total is exactly 7000

Region is Asia and sales total is greater than 7000

Region is Europe and sales total is less than 5000

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What must be done to perform an OR filter using the advanced filter?

Use a separate worksheet for each criterion

List criteria one above the other

Use a different filter for each criterion

List criteria side by side

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the OR filter example, which sales reps were used as criteria?

Tom and Jerry

Ben and Deb

Alice and John

Mike and Sarah

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a key benefit of using the advanced filter in Excel?

It sends data via email

It automatically updates data

It creates charts and graphs

It allows for complex criteria filtering