Wednesday, November 19, 2008

Week 9 Class 2

EXCEL

Exercise
Create a table with student names and scores for 2 assignments

Format the data as table

Use conditional formatting to highlight fails

Add columns to work out the average, max and min

Count the number of students who passed
Count the number of students who failed

Tip: Use AutoSum

No comments: