Microsoft Excel 2021365 - Beginner to Advanced - Sorting a List (Multi-Level Sort)

Microsoft Excel 2021365 - Beginner to Advanced - Sorting a List (Multi-Level Sort)

Assessment

Interactive Video

Information Technology (IT), Architecture, Social Studies

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial explains how to perform a multi-level sort in Excel, allowing users to sort data by multiple columns. It covers the setup process, including selecting the data tab and using the sort dialog box. The tutorial provides examples of sorting by region, country, and sales amount, and discusses advanced options like case sensitivity and sort order. The video also highlights the use of right-click options for custom sorting.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What happens if you do not select the checkbox for headers when sorting?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What options do you have when choosing how to sort data in Excel?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you reorder the sort levels in Excel?

Evaluate responses using AI:

OFF