Intro Rank Labels

This intro problem practices CHOOSE. CHOOSE uses a position number to return the matching item from a list you provide. Update the output cells so each row converts the rank number in column B into its medal label: rank 1 returns "Gold", rank 2 returns "Silver", and rank 3 returns "Bronze". See Examples

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

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

CHOOSE
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