Sorting data (single and multi-level) in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to sort the data in column A in ascending order.

Excel

Sort data by selecting column A and then clicking on the [1] button in the Data tab.

Drag options to blanks, or click blank then click option'

ASort A to Z

BFilter

CSort Z to A

DRemove Duplicates

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Sort Z to A' which sorts in descending order.

Selecting 'Filter' instead of sorting.

To sort data in ascending order, use the Sort A to Z button.

2fill in blank

medium

Complete the code to sort data by column B in descending order.

Excel

Select column B and click on the [1] button in the Data tab to sort from highest to lowest.

Drag options to blanks, or click blank then click option'

ASort Z to A

BSort A to Z

CSort Smallest to Largest

DSort Largest to Smallest

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Sort A to Z' which sorts ascending.

Confusing 'Sort Smallest to Largest' with descending order.

To sort in descending order, use the Sort Z to A button.

3fill in blank

hard

Fix the error in the steps to sort data by multiple columns.

Excel

Go to Data tab, click on Sort, then add Level. For the first level, choose column C and sort [1]. For the second level, choose column A and sort [2].

Drag options to blanks, or click blank then click option'

AAscending

BDescending

CFilter

DClear

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Filter' or 'Clear' instead of sorting order.

Mixing ascending and descending orders without reason.

When sorting by multiple columns, you can choose ascending or descending for each level. Here, ascending is the correct choice for both levels.

4fill in blank

hard

Fill both blanks to create a multi-level sort: first by column D descending, then by column B ascending.

Excel

In the Sort dialog, set the first level to column D and sort [1]. Add a level, set it to column B and sort [2].

Drag options to blanks, or click blank then click option'

ADescending

BAscending

CFilter

DClear

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Filter' or 'Clear' instead of sorting options.

Mixing up ascending and descending orders.

The first level sorts column D in descending order, and the second level sorts column B in ascending order.

5fill in blank

hard

Fill all three blanks to write a formula that sorts data in range A2:C10 by column 2 ascending and column 3 descending.

Excel

=SORT(A2:C10, [1], [2], [3])

Drag options to blanks, or click blank then click option'

A2

BTRUE

CFALSE

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 instead of 2 for the first sort column.

Mixing TRUE and FALSE values incorrectly.

The formula sorts by the 2nd column ascending (TRUE) and then by the 3rd column descending (FALSE).