ICT

working with excel and using codes and enquiries

HideShow resource information
to add up a range of values
SUM
1 of 12
to find the average of a range of values
AVERAGE
2 of 12
to find the smallest (minimum) value in a range of values
MIN
3 of 12
to find the largest (maximum) value in a range of values
MAX
4 of 12
to count the number of numeric values in a range of values
COUNT
5 of 12
to count the number of items (text or numbers) in a range of values
COUNTA
6 of 12
to find the whole partof a number - the integer part
INT
7 of 12
to find the nearest whole number to a numeric value - rounding it up or down
ROUND
8 of 12
to find the meaning of a particular value. It does this by 'looking up' the value in a lookup table
VLOOKUP
9 of 12
to count the number of specific values in a range of cells
COUNTIF
10 of 12
to add up values in a range of cells when cells in another, parallel range match a given specific criteria
SUMIF
11 of 12
to make choices or decisions about what will appearin a cell
IF
12 of 12

Other cards in this set

Card 2

Front

AVERAGE

Back

to find the average of a range of values

Card 3

Front

MIN

Back

Preview of the back of card 3

Card 4

Front

MAX

Back

Preview of the back of card 4

Card 5

Front

COUNT

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Data and Information resources »