The following table lists all the Microsoft Excel functions that you will learn in your three years of CAT (DBE curriculum). The table below is searchable and sortable.
| Function | Grade 10 | Grade 11 | Grade 12 | Extras |
|---|---|---|---|---|
| AND | ✓ | |||
| AVERAGE | ✓ | ✓ | ✓ | |
| CLEAN | ✱ | |||
| CONCATENATE | ✓ | |||
| CONVERT | ✱ | |||
| COUNT | ✓ | ✓ | ✓ | |
| COUNTA | ✓ | ✓ | ||
| COUNTBLANK | ✓ | ✓ | ||
| COUNTIF | ✓ | ✓ | ✓ | |
| COUNTIFS | ✓ | |||
| TODAY | ✓ | |||
| DAY | ✓ | |||
| DAYS | ✓ | |||
| FIND | ✓ | |||
| HLOOKUP | ✓ | |||
| HOUR | ✓ | |||
| IF | ✓ | ✓ | ||
| INT | ✓ | |||
| LARGE | ✓ | |||
| LEFT | ✓ | |||
| LEN | ✓ | |||
| LOWER | ✓ | |||
| MAX | ✓ | ✓ | ✓ | |
| MEDIAN | ✓ | |||
| MID | ✓ | |||
| MIN | ✓ | ✓ | ✓ | |
| MINUTE | ✓ | |||
| MODE | ✓ | ✓ | ✓ | |
| MONTH | ✓ | |||
| NOW | ✓ | |||
| POWER | ✓ | ✓ | ||
| RAND | ✓ | ✓ | ✓ | |
| RANDBETWEEN | ✓ | ✓ | ||
| RIGHT | ✓ | |||
| ROUND | ✓ | ✓ | ✓ | |
| ROUNDDOWN | ✓ | |||
| ROUNDUP | ✓ | |||
| SMALL | ✓ | ✓ | ||
| SUBTOTAL | ✓ | |||
| SUM | ✓ | ✓ | ✓ | |
| SUMIF | ✓ | ✓ | ||
| SUMIFS | ✓ | |||
| TIME | ✓ | |||
| TODAY | ✓ | ✓ | ✓ | |
| TRIM | ✱ | |||
| TRUNC | ✓ | |||
| UPPER | ✓ | |||
| VALUE | ✓ | |||
| VLOOKUP | ✓ | |||
| YEAR | ✓ |
You also need to be able to work with Nested IF statements…