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


The rest of this content is available to full members. Full membership of the site is available by either donating R100 on the Donation page, or uploading an activity or assessment that you yourself have created to share with others (on the Upload page).

scr1

scr3 scr2

Similar Posts: