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, and some of the function names hyperlink to additional posts on that specific function.
| Function | Grade 10 | Grade 11 | Grade 12 | Extras |
|---|---|---|---|---|
| AND | ✓ | |||
| ARABIC | ✱ | |||
| 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 | ✓ |
Here are some additional, important Excel posts: