formulas and functions we need to know within a spreadsheet.
SUM - add 2 or more values together
AVERAGE - works out the mean of 2 or more values
MIN - finds the lowest value witin a set of data
MAX - finds the highest value within a set of data
IF - allows you to ask questios which wil have 2 possible answers
VLOOKUP - A procedure in which a table of values stored in a computer is searched until a specified value is.
ROUND - allows you to round your number to a number of decimal points
Spinners - linked to a cell to increase or decrease a value, this is a efficent way to input data.
Comments
No comments have yet been made