Sorting data (single and multi-level) in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does sorting data in Excel mean?

Sorting data means arranging your rows based on the values in one or more columns, either from smallest to largest (ascending) or largest to smallest (descending).

beginner

How do you sort data by a single column in Excel?

Select any cell in the column you want to sort by, then go to the Data tab and click either 'Sort A to Z' for ascending or 'Sort Z to A' for descending order.

intermediate

What is multi-level sorting in Excel?

Multi-level sorting means sorting your data by more than one column. For example, first by 'City' and then by 'Name' within each city.

intermediate

How do you perform multi-level sorting in Excel?

Go to the Data tab, click 'Sort', then add levels by clicking 'Add Level'. Choose the first column to sort by, then the second, and so on. Click OK to apply.

beginner

Why is it important to select the entire data range before sorting?

Selecting the entire data range ensures that all related information in each row stays together. Otherwise, only one column might sort, mixing up your data.

What happens if you sort only one column without selecting the entire data range?

A All columns sort automatically.

B Excel will prevent sorting.

C Only that column sorts, and other columns stay the same, causing mismatched rows.

D The data will be deleted.

Sorting only one column rearranges that column alone, which breaks the relationship between columns in the same row.

Which Excel tab contains the sorting options?

A Data

B Insert

C Home

D Review

The Data tab has all the sorting and filtering tools in Excel.

If you want to sort first by 'Department' and then by 'Employee Name', what type of sorting is this?

A Single-level sorting

B Conditional sorting

C Filter sorting

D Multi-level sorting

Sorting by more than one column is called multi-level sorting.

What does 'Sort A to Z' do in Excel?

A Sorts numbers from largest to smallest

B Sorts text alphabetically from A to Z

C Deletes the data

D Sorts dates from newest to oldest

'Sort A to Z' arranges text in alphabetical order from A to Z.

How can you add another sorting level in Excel's Sort dialog?

A Click 'Add Level' button

B Right-click the column header

C Use the filter dropdown

D Press Ctrl + S

The 'Add Level' button lets you add more columns to sort by in order.

Explain how to sort data by multiple columns in Excel step-by-step.

Think about the Sort dialog and how you add columns.

Why should you select the entire data range before sorting, and what can happen if you don't?

Consider what happens to related data in the same row.