Microsoft Excel functions banner image.

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.

FunctionGrade 10Grade 11Grade 12Extras
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

By MisterFoxOnline

CAT Educator

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.