Created by Linda (tutor)
about 6 years ago


Question  Answer 
Formula: Subtraction  =A1B1 
Formula: Multiplication  = A1 * B1 
Formula: Division  = A1 / B1 
Function: to find the lowest (smallest) contents of a range of cells  =Min(A1 : F1) 
Function: to find the largest contents of a range of cells  =Max(A1 : F1) 
Function: to find the Average contents of a range of cells  =Average(A1 : F1) 
MathsSymbolsSubtraction.jpeg (image/jpeg)  The mathematical operator used to subtract cells in a formula 
MathsSymbolsDivide.jpeg (image/jpeg)  The mathematical operator used to divide cells in a formula. Use / on your keyboard 
MathsSymbolsEquals.jpeg (image/jpeg)  All formula and functions must start with = 
MathsSymbolsAddition.jpeg (image/jpeg)  The mathematical operator to add cells together in a formula 
MathsSymbolsTimes.jpeg (image/jpeg)  The mathematical operator used to multiply cells in a formula 
Formula: Addition  = A1 + B1 