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:

  • 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!

scr1

scr3 scr2

Similar Posts:

Leave a comment

Your email address will not be published. Required fields are marked *