Microsoft Excel formulas menu

The following table lists all the functions that you will learn in your three years of CAT.

FunctionGrade 10Grade 11Grade 12
AND
AVERAGE
CONCATENATE
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
TRUNC
UPPER
VALUE
VLOOKConquering Excel’s VLOOKUPUP
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.