# 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

AVERAGE

#### Back

to find the average of a range of values

MIN

MAX

COUNT