CAT MS Excel exercise

Excel-iconI 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:

  • IF (including nested IF’s)
  • COUNT (all variations)
  • Creating and editing a graph
  • Conditional formatting
  • Absolute cell referencing/Cell naming

Where to find it

In the Resources section!


scr3 scr2

Be the first to comment