I have added an Excel spreadsheet exercise for Grade 12 but it can also be used for Grade 11 as well. I used some data from an old exam paper and modified it a bit. Included is a partly self-marking worksheet for the teacher, a solution spreadsheet and a Word doc with all the instructions. Everything is completely editable by the teacher.
I have tried to include as many functions as possible. I have not included some functions such as ROUND for example. But it is pretty easy to edit and add some questions yourself.
- IF (including nested IF’s)
- COUNT (all variations)
- Creating and editing a graph
- Conditional formatting
- Absolute cell referencing/Cell naming