Problem 5: LOOKUP & COUNTIF functions On Worksheet #5, calculate and report: a) The average score of student #28 b) The class average for all students c) Number of students above or equal to class average d) Number of students below class average Student Exam 2 80 75 2 3 Exam 3 85 93 90 24 78 85 Exam 1 75 75 ro 58 To 78 so 50 55 55 76 76 QQ 00 92 02 28 00 53 85 02 93 100 100 05 92 03 52 30 22 25 83 53 95 58 88 0 63 4. 5 6 7 8 9 10 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 30 11 12 131 14 15 16 4 5 6 7 8 8 9 10 11 1 12 14 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 50 63 65 83 93 78 95 60 95 88 88 86 93 75 78 85 83 58 73 70 65 83 83 88 93 88 73 90 80 93 75 80 80 85 88 88 90 60 93 78 85 83 95 70 83 93 95 85 80 73 58 88 70 98 80 95 88 83 83 90 83 85 75 60 95 98 60 65 88 91 78 78 73 Class Average