Dynamic arrays › SORT99 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeSORT

SORT: ranking tryout scores

Mr. Hendra, a math teacher at a junior high school in Semarang, wants to post the tryout scores on the class board, sorted from the highest. The original data stays in roll-call order so it still matches his grade book.

Task

In E2, write one SORT formula that returns the whole table A2:C9 (name, class, score) sorted by score from the highest. The result spills into E2:G9.

Cells to fillE2:G9

Required functionsSORT

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
The shape is SORT(array, sort_index, sort_order): array = the table to sort, sort_index = which column to sort by, sort_order = 1 (ascending) or -1 (descending).
Hint 2
The score is the 3rd column of A2:C9. Column numbers count from the left of the array (starting at 1), not the sheet column letter.
Hint 3
Pattern: =SORT(A2:C9, 3, …). Fill in the last argument so the order goes from largest to smallest.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

E2

=SORT(A2:C9,3,-1)

Explanation

=SORT(A2:C9,3,-1) sorts the rows by the 3rd column (score) in descending order, and each whole row moves along so names stay with their scores. Common mistakes: using 1 as the order (lowest score first), or selecting only C2:C9 so names and classes disappear. Because the result is a formula, the board list updates by itself when a score is corrected.

Starting worksheet: Sheet1
Row	A	B	C	E	F	G
1	Name	Class	Score	Name	Class	Score
2	Alya	8A	78
3	Bagas	8B	92
4	Cahya	8A	85
5	Dimas	8C	64
6	Elsa	8B	88
7	Farel	8C	71
8	Gita	8A	95
9	Hafiz	8B	59
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result