The Complete Excel Guide: Beginners to Advanced - Filter Data

The Complete Excel Guide: Beginners to Advanced - Filter Data

Assessment

Interactive Video

Information Technology (IT), Architecture, Life Skills

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers sorting and filtering options in Excel. It begins with an introduction to filtering, explaining how to apply basic filters to data. The tutorial then progresses to advanced filtering techniques, including number filters and conditions, and concludes with text filters and advanced filtering options. The video provides practical examples using payroll data, demonstrating how to filter by department, division, and specific criteria such as hours worked or benefits.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you filter to find employees who worked more than 40 hours?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the difference between AND and OR conditions in filtering?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What are text filters and how can they be used in Excel?

Evaluate responses using AI:

OFF