Spreadsheet Level 1 Formula and Functions

Question	Answer
Formula: Subtraction	=A1-B1
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)
Image: MathsSymbolsSubtraction (image/jpeg)	The mathematical operator used to subtract cells in a formula
Image: MathsSymbolsDivide (image/jpeg)	The mathematical operator used to divide cells in a formula. Use / on your keyboard
Image: MathsSymbolsEquals (image/jpeg)	All formula and functions must start with =
Image: MathsSymbolsAddition (image/jpeg)	The mathematical operator to add cells together in a formula
Image: MathsSymbolsTimes (image/jpeg)	The mathematical operator used to multiply cells in a formula
Formula: Addition	= A1 + B1

Resource summary

	Created by Linda (tutor) over 12 years ago