Excel functions you need to know for IGCSE & AS for Cambridge students.
The following table lists all the Microsoft Excel functions that you will learn in your three years of CAT (DBE CAPS curriculum). The table below is searchable and sortable, and most function names hyperlink to a post on that specific function.
Please note that the SUBTOTAL function is NOT included in the syllabus, the Subtotal feature is included! Have a look at the functions listed with an asterisk (*) if you are searching for extra functions for bonus marks in your PAT!
| Function | Grade 10 | Grade 11 | Grade 12 | Extras |
|---|---|---|---|---|
| AND | ✓ | |||
| ARABIC | ✱ | |||
| AVERAGE | ✓ | ✓ | ✓ | |
| CLEAN | ✱ | |||
| CONCATENATE | ✓ | |||
| CONVERT | ✱ | |||
| COUNT | ✓ | ✓ | ✓ | |
| COUNTACOUNTA | ✓ | ✓ | ||
| COUNTBLANK | ✓ | ✓ | ||
| COUNTIF | ✓ | ✓ | ✓ | |
| COUNTIFS | ✓ | |||
| DATE | ✓ | |||
| DAY | ✓ | |||
| DAYS | ✓ | |||
| FIND | ✓ | |||
| HLOOKUP | ✓ | |||
| HOUR | ✓ | |||
| Using Excel’s IF function | ✓ | ✓ | ||
| Using Excel’s INT function | ✓ | |||
| LARGE | ✓ | ✓ | ||
| LEFT | ✓ | |||
| LEN | ✓ | |||
| LOWER | ✓ | |||
| MAX | ✓ | ✓ | ✓ | |
| MEDIAN | ✓ | |||
| MID | ✓ | |||
| MIN | ✓ | ✓ | ✓ | |
| MINUTE | ✓ | |||
| MODE | ✓ | ✓ | ✓ | |
| MONTH | ✓ | |||
| NOW | ✓ | |||
| PIPI | ✱ | |||
| POWER | ✓ | ✓ | ||
| PROPER | ✱ | |||
| RAND | ✓ | ✓ | ✓ | |
| RAND | ✓ | ✓ | ||
| RIGHT | ✓ | |||
| ROMAN | ✱ | |||
| ROUND | ✓ | ✓ | ✓ | |
| ROUNDDOWN | ✓ | |||
| ROUNDUP | ✓ | |||
| SMALL | ✓ | ✓ | ||
| SUM | ✓ | ✓ | ✓ | |
| SUMIF | ✓ | ✓ | ||
| SUMIFS | ✓ | |||
| TIME | ✓ | |||
| TODAY | ✓ | ✓ | ✓ | |
| TRIM | ✱ | |||
| TRUNC | ✓ | |||
| Using Excel’s UPPER() function | ✓ | |||
| VALUE | ✓ | |||
| VLOOKUP | ✓ | |||
| YEAR | ✓ |
Here are some additional, important Excel posts:
- Nested IF statements
- Advanced criteria in Excel logic functions
- Selecting function criteria in Excel