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