Exercise of Quiz in Spreadsheet
1. Enter column headings in the
first row and center them.
2. Enter students' names in column A and
all other scores in columns B to E.
3. Use SUM function to compute
the total of quizzes for WELL in cell F2.
4. Use Fill Down feature to copy
a formula from F2 to the rest of cells in column F.
5. Add your name. Use any numbers
for the quizzes (Maximum is 25)
6. Show me.
7. Sort sheet according to a descending
order of total.
8. Show me..
| A | B | C | D | E | F | |
| 1 | NAME | QUIZ 1 | QUIZ 2 | QUIZ 3 | QUIZ 4 | TOTAL |
| 2 | WELL | 19 | 24 | 20 | 22 | |
| 3 | SUE | 20 | 21 | 25 | 20 | |
| 4 | JUSTIN | 18 | 18 | 20 | 24 | |
| 5 | MARY | 23 | 24 | 19 | 20 | |
| 6 | KIM | 22 | 16 | 25 | 25 |