Using the information from the following table create a spreadsheet
to represent the data.
| Name |
Quiz 1 |
Quiz 2 |
Quiz 3 |
| Marge |
99 |
100 |
91 |
| John |
69 |
71 |
66 |
| Sue |
91 |
88 |
94 |
| Pam |
59 |
63 |
61 |
| Eric |
73 |
77 |
81 |
| Joy |
67 |
58 |
64 |
| Ben |
74 |
53 |
65 |
|
Add column and row headings.
First find out the total for each student /300.
Click into E2 to make it an active cell.
Click on the AutoSum button 
, the formula =SUM(B2:D2) comes up, this is correct, press enter.
Use the fill handle to populate the rest of the totals. Check
each cell to make sure it is correct.
Find out the Average of Quiz 1.
Make B9 the active cell.
Click on the Function Wizard 
Choose Statistical from the dropdown menu.
Choose Average from the right hand side. Press
OK
Make sure the range is B2:B8. Press OK
Use the Fill handle - format the decimals to whole numbers.
Find out the Average of each student. Follow
the same procedure as above from F2, but make
sure the range is changed to B2:D2.
Repeat using the function wizard for:
Minimum - MIN (active cell G2)
Maximum - Max (active cell H2)
