Revision for the different topics within a spreadsheet

HideShow resource information

## VLOOKUP

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.

1 of 2

## VLOOKUP

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.

2 of 2