Free computer Tutorials

HOME Stay at Home and Learn

Microsoft Excel 2007

 
Computer Tutorials List

 

 

 

 

 

Review Number Three

 

Study the following spreadsheet:

Student Grades

The spreadsheet is the school exam marks of 8 students. A total of 8 subjects were taken. For this review, work out the Averages for all 8 subjects studied, which is in the K column above. Also, work out the Overall Averages for each student (row 11 above).

The first thing to do is to recreate the spreadsheet above. You can then use one of the methods for working out Averages that you have explored in this section. You're going to be needing your completed spreadsheet in the next section - so don't skip it!