The following table presents the gradebook for a class. Importantly, this class uses a weighted grading scheme to calculate grades. 40% of the class grade is determined by assignments, while 60% of the class grade is determined by exams. In cells I7:I25 caluculate the final grade for each student. Answer the two questions to the right is cells L2, L3.*Please show formulas, thank you*

Question 3: The following table presents the gradebook for a class. Importantly, this class uses a weighted grading scheme calculate grades. 40% of the class grade is determined by assignments, while 60% of the class grade is determined by exams. In cells 17:125 caluculate the final grade for each student. Answer the two questions to the right is cells L2, L3. What was the final grade for Andy? What was the final grade for Susan? Final Grade Student Andy Barbara Bob Charles Daniel Edward Frank Heather Jason Kathy Nancy Oscar Paul Rick Susan Tammy Tom Warren Zach Assignment 1 Assignment 2 99 75 81 75 69 98 70 99 88 88 85 89 78 67 71 91 81 76 60 79 60 81 82 71 78 64 61 64 99 83 69 90 78 76 70 83 59 59 Assignment 3 Assignment 4 85 91 74 64 BO 88 73 92 70 55 93 96 76 BO 68 97 89 73 90 80 55 81 64 63 88 95 84 88 91 87 66 94 77 83 70 65 63 0 Exam 1 87 58 78 84 91 87 71 77 74 64 91 63 62 94 99 96 71 62 68 Exam 2 94 63 68 86 100 96 70 94 68 77 70 68 55 78 91 66 91 86 61