ORDER BY clause in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to sort the data by the first column in ascending order.

Google Sheets

=SORT(A2:B10, [1], TRUE)

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

A2

B0

C1

DTRUE

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 as the column number, which is invalid.

Confusing TRUE/FALSE with column numbers.

The SORT function sorts the range by the column number given. Here, 1 means the first column.

2fill in blank

medium

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

Google Sheets

=SORT(A2:C15, [1], FALSE)

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

A2

B1

C3

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRUE instead of FALSE for descending order.

Using the wrong column number.

The second argument 2 tells SORT to use the second column. The third argument FALSE means descending order.

3fill in blank

hard

Fix the error in the formula to sort by the third column ascending.

Google Sheets

=SORT(A1:D20, [1], TRUE)

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

A3

B4

C2

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 4 instead of 3 for the third column.

Using 0 which is invalid.

The third column is column number 3. Using 3 correctly sorts by that column.

4fill in blank

hard

Fill both blanks to sort the range by the first column descending and then by the second column ascending.

Google Sheets

=SORT(A2:C20, [1], FALSE, [2], TRUE)

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

A1

B2

C3

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up column numbers.

Using TRUE for descending order.

The first blank is the first column (1) sorted descending (FALSE). The second blank is the second column (2) sorted ascending (TRUE).

5fill in blank

hard

Fill all three blanks to sort the data by the second column ascending, then by the third column descending, and finally by the first column ascending.

Google Sheets

=SORT(A1:D30, [1], TRUE, [2], FALSE, [3], TRUE)

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

A2

B3

C1

D4

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong column numbers.

Mixing up TRUE and FALSE for sort order.

The blanks correspond to the columns to sort by in order: second column ascending (2, TRUE), third column descending (3, FALSE), first column ascending (1, TRUE).