Student Admission Exams

In order to be admitted to a prestigious university, students must take 3 tests. The students' 3 test scores are added together to calculate their total score. The students with the 3 highest total scores are admitted. Update the output cells so that each student's Admission status ("Yes" or "No") is displayed. See Examples

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

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