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.
Functions/skills include:
- CONCATENATE
- VLOOKUP
- IF (including nested IF’s)
- SUMIF
- COUNT (all variations)
- Creating and editing a graph
- Conditional formatting
- Absolute cell referencing/Cell naming
Where to find it
In the Resources section!
Be the first to comment