Question: 3. (Spreadsheets) Given the following spreadsheet: A B D F G . E Grades Exam 2 Students Exam 1 Exam 3 Total Average 1 2

3. (Spreadsheets) Given the following spreadsheet: A B D F G . E Grades Exam 2 Students Exam 1 Exam 3 Total Average 1 2 3 4 5 89 90 6 7 8 9 66 50 80 83 33 50 60 75 80 84 89 98 90 90 67.3333 71.6666 65.3333 67.3333 80 84 Bill Bob Chris Jim Judy June Mari Mary Phil Sarah Susy Total Average 10 11 12 13 87 99 89 80 202 75 215 70 196 77 202 80 240 85 252 90 266 90 287 85 264 85 250 95 270 912 2644 82.9090 240.3635 88.6666 95.6666 88 83.3333 90 75 90 14 15 16 85 893 81.1818 839 76.2727 881.333 80.1212 a. [2] Write the formula that is likely in cell G4 in such a way that it can be copied to cells G5:G14 and correctly compute their values too. b. [2] Write the formula that is likely in cell 016 in such a way that it can be copied to cells E16:H16 and correctly compute their values too
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
