Final Student Grades

Update the output cells so that each student's final grade is calculated using the assignment weights provided in row 3 (all weights sum to 100). The final grade should be rounded to the nearest whole number. 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