| Keyword | Definition |
|---|---|
| AVERAGE | spreadsheet function which works out the mean value from a range of cells |
| cell reference | the location of an individual cell in a spreadsheet |
| COUNTA | spreadsheet function which counts how many cells in a range are not empty |
| function | a useful piece of code within a formula that can calculate and return a value |
| MAX | spreadsheet function which works out the largest value from a range of cells |
| MIN | spreadsheet function which works out the smallest value from a range of cells |
| parameter | an input to a function such as a value, range or cell reference |
| range | multiple values from more than one spreadsheet cell |
| SUM | spreadsheet function which adds up each value in a range and returns the total |
| value | an individual number or data item in a spreadsheet cell |
