Grade 10 Functions
Function What it does How to use Data
Sum Adds everything you’ve selected =Sum(Select range to add) Numbers
together
Min Finds the smallest number =Min(Select range) Numbers
Max Finds the largest number =Max(Select range) Numbers
Average Works out the average =Average(Select range) Numbers
Mode Finds the number that occurs the =Mode(Select range) Numbers
most
Median Finds the middle number in a range =Median(Select range) Numbers
Count Counts all the numbers =Count(Select range) Numbers
CountA Counts all the cells that are NOT blank =CountA(select range) Any data
CountBlank Counts all the Blank cells =CountBlank(Select Range) Any data
CountIF Only counts cells that meet your =CountIF(Select Range , “Criteria”) Any data
criteria *Criteria is placed between inverted
commas “A” , “>10” , “<2”
Now Shows today’s date and time =Now() NA
Today Shows today’s date =Today() NA
Rand Generates a random num between 0 =Rand() NA
– 1 e.g. 0.154
RandBetween Generates a random between a =RandBetween(low num , High num) Numbers
selected range
Grade 11 Functions
Function What it does How to use Data
Round Rounds decimals up or down =Round(num , decimal places) Numbers
RoundUp Rounds decimals up =RoundUp(num , decimal places) Numbers
RoundDown Rounds decimals down =RoundDown(num , decimal places) Numbers
Large Helps find 2nd largest, 3rd largest etc. =Large(range , place value) Numbers
values *Place value e.g. 3 for 3rd largest
Small Helps you find 2nd smallest, 3rd =Small(range , place value) Numbers
smallest etc. values *Place value e.g. 5 for 5th smallest
Power Used to calculate num to the power of =Power(num , to the power of) Numbers
SumIF Sum’s values together IF it meets a =SumIF(range , criteria , sum range) Any data
certain criteria
AverageIF Average’s values IF it meets a certain =AverageIF(range , criteria , Average Any data
criteria range)
IF Condition matches – True (Values in =IF(cell = criteria , TRUE , FALSE) Any data
true will appear) *Cell > criteria
Condition does not match – False *Cell <= criteria
(Value in false will appear) *Cell <> criteria
CountIFs Applies criteria to cells across multiple =CountIFS(range1, criteria1, range2, Any data
ranges and counts the number of criteria 2)
times all criteria are met. *can continue to larger ranges and criteria
SumIFs Function adds all numbers in a range =SumIFS(range1, criteria1, Any data
of cells, based on multiple criteria sumRange1,range2, criteria2, sumRange2)
*can continue to larger ranges and criteria
Function What it does How to use Data
Sum Adds everything you’ve selected =Sum(Select range to add) Numbers
together
Min Finds the smallest number =Min(Select range) Numbers
Max Finds the largest number =Max(Select range) Numbers
Average Works out the average =Average(Select range) Numbers
Mode Finds the number that occurs the =Mode(Select range) Numbers
most
Median Finds the middle number in a range =Median(Select range) Numbers
Count Counts all the numbers =Count(Select range) Numbers
CountA Counts all the cells that are NOT blank =CountA(select range) Any data
CountBlank Counts all the Blank cells =CountBlank(Select Range) Any data
CountIF Only counts cells that meet your =CountIF(Select Range , “Criteria”) Any data
criteria *Criteria is placed between inverted
commas “A” , “>10” , “<2”
Now Shows today’s date and time =Now() NA
Today Shows today’s date =Today() NA
Rand Generates a random num between 0 =Rand() NA
– 1 e.g. 0.154
RandBetween Generates a random between a =RandBetween(low num , High num) Numbers
selected range
Grade 11 Functions
Function What it does How to use Data
Round Rounds decimals up or down =Round(num , decimal places) Numbers
RoundUp Rounds decimals up =RoundUp(num , decimal places) Numbers
RoundDown Rounds decimals down =RoundDown(num , decimal places) Numbers
Large Helps find 2nd largest, 3rd largest etc. =Large(range , place value) Numbers
values *Place value e.g. 3 for 3rd largest
Small Helps you find 2nd smallest, 3rd =Small(range , place value) Numbers
smallest etc. values *Place value e.g. 5 for 5th smallest
Power Used to calculate num to the power of =Power(num , to the power of) Numbers
SumIF Sum’s values together IF it meets a =SumIF(range , criteria , sum range) Any data
certain criteria
AverageIF Average’s values IF it meets a certain =AverageIF(range , criteria , Average Any data
criteria range)
IF Condition matches – True (Values in =IF(cell = criteria , TRUE , FALSE) Any data
true will appear) *Cell > criteria
Condition does not match – False *Cell <= criteria
(Value in false will appear) *Cell <> criteria
CountIFs Applies criteria to cells across multiple =CountIFS(range1, criteria1, range2, Any data
ranges and counts the number of criteria 2)
times all criteria are met. *can continue to larger ranges and criteria
SumIFs Function adds all numbers in a range =SumIFS(range1, criteria1, Any data
of cells, based on multiple criteria sumRange1,range2, criteria2, sumRange2)
*can continue to larger ranges and criteria
