Year Seven Task 6

1. Create a spreadsheet like the task 6 below

2. use the formula below to find out whether the students passed or failed

NB. FORMULA 

=IF(AV5<50,"fail", IF(AV5>=50,"pass"))

3. type the functions to find the biggest, smallest, and average scores.