0
0
Google Sheetsspreadsheet~10 mins

Sorting (single and multi-column) in Google Sheets - Interactive Code Practice

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Practice - 5 Tasks
Answer the questions below
1fill in blank
easy

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

Google Sheets
=SORT(A2:A[1])
Drag options to blanks, or click blank then click option'
AA
B10
C1
D20
Attempts:
3 left
💡 Hint
Common Mistakes
Using a column letter instead of a row number in the range.
Leaving the range incomplete.
2fill in blank
medium

Complete the formula to sort the data in range A2:B20 by the second column in descending order.

Google Sheets
=SORT(A2:B20, [1], FALSE)
Drag options to blanks, or click blank then click option'
A1
B2
CTRUE
D0
Attempts:
3 left
💡 Hint
Common Mistakes
Using 1 instead of 2 for the column number.
Using TRUE instead of FALSE for descending order.
3fill in blank
hard

Fix the error in the formula to sort range A2:C15 by the first column ascending and second column descending.

Google Sheets
=SORT(A2:C15, [1], TRUE, [2], FALSE)
Drag options to blanks, or click blank then click option'
A1
B2
C3
D4
Attempts:
3 left
💡 Hint
Common Mistakes
Using wrong column numbers for sorting.
Mixing up TRUE and FALSE for sort order.
4fill in blank
hard

Fill both blanks to sort range B2:D25 by column 3 ascending and column 1 descending.

Google Sheets
=SORT(B2:D25, [1], TRUE, [2], FALSE)
Drag options to blanks, or click blank then click option'
A3
B1
C2
D4
Attempts:
3 left
💡 Hint
Common Mistakes
Swapping the column numbers.
Using incorrect sort order values.
5fill in blank
hard

Fill all three blanks to sort range A1:C30 by column 2 descending, column 3 ascending, and column 1 descending.

Google Sheets
=SORT(A1:C30, [1], FALSE, [2], TRUE, [3], FALSE)
Drag options to blanks, or click blank then click option'
A2
B3
C1
D4
Attempts:
3 left
💡 Hint
Common Mistakes
Mixing up the order of columns.
Using TRUE/FALSE incorrectly for sort order.