Intro Score Ranks

This intro problem practices RANK. RANK compares a number to a list and returns its position, with rank 1 meaning the highest score when the order is 0. Update the output cells so each row ranks the score in column C against all scores in C3:C7. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

Need help with RANK details and syntax? Review the RANK function guide first.

RANK
A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50