Created by Linda (tutor)
over 6 years ago


Question  Answer 
Function to return a value dependent on specific criteria  =IF(A1>50, "Yes", "No") 
BODMAS  The order of precedence when calculating numerical data 
Function used to calculate the AVERAGE value of a range of cells  =Average(cellref:cellref) 
Function used to calculate the MAXIMUM value in a range of cells  =MAX(cellref:cellref) 
Function used to calculate the MINIMUM value in a range of cells  =MIN(cellref:cellref) 
Function used to calculate the SUM (total) of a range of cells  =SUM(cellref:cellref) 
Function used to COUNT a range of cells which contain NUMERIC data  =COUNT(cellref:cellref) 
Function used to ROUND the value in a range of cells to a set number of decimal places (e.g. 0, 1, 2)  =ROUND(cellref,0) 
Function used to COUNT a range of cells which contain data  =COUNTA(cellref:cellref) 
Function used to COUNT a range of cells which do not contain data  =COUNTBLANK(cellref:cellref) 
Formula to MULTIPLY cells  =cellref * cellref 
Formula to SUBTRACT data in cells  =cellref  cellref 
Formula to DIVIDE numeric data in cells  = cellref / cellref 
Formula to ADD numeric data together  =cellref + cellref 