The Complete Excel Guide: Beginners to Advanced - Module 13 - Practice Exercise

The Complete Excel Guide: Beginners to Advanced - Module 13 - Practice Exercise

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers sorting and filtering data in Excel. It explains how to perform single and double level sorts, such as sorting by last name or by division and last name. The tutorial also teaches how to filter data based on specific criteria and how to clear filters. The module concludes with a transition to the next topic, outlining and subtotaling in Excel.

Read more

5 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What are single level sorts and can you provide an example?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain what double sorts are and give an example of how to perform one.

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What does filtering data mean and how does it work?

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the process of clearing filters in a data set.

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

What topics will be covered in module 14 following this one?

Evaluate responses using AI:

OFF