C29 v :XV fx A B C D E F G H K M N O P Q R S Student Grades Student Grades IN Max score Max score Test #1 Test #2 W 75 95 Joe 52 Joe 54 Louise 67 Louise 91 Paul 26 Paul 57 Stephanie 32 Stephanie 48 8 Erica 48 Erica 67 9 Peter 56 Peter 89 10 John 44 John 77 11 Mary 71 Mary 64 12 Alfe 45 Alfe 86 13 Richard 64 Richard 74 14 Pierrette 59 Pierrette 65 15 Lucy 63 Lucy 83 16 Min Min 17 Max Max 18 Average Average 19 20 21 22 Complete all highlighted cells in the tables above. 23 Calculate the percentage score for each student in the 24 right-hand column. Make use of the MIN, MAX, and 25 AVG functions to complete the bottom 6 cells. 26 27 28 29 30 31 32 33 34 35