| A | B |
|---|
| Absolute cell reference | Keeping a cell reference constant when copying a formula. |
| AVERAGE | A spreadsheet function that indicates the average of a group of numbers in a range |
| Argument | A value needed to calculate a function. For example, the function COUNT needs cell references as the arguments:=COUNT(A2:D6) |
| Bar graph | A type of graph that represents different quantities by using bars |
| Circular reference | Occurs when a formula in a spreadsheet refers to itself. No result is possible and a warning appears |
| COUNT | A spreadsheet function that counts the number of cells in a range that contains data |
| Formula | Statement that performs a calculation |
| Function | Built-in formulas used with a range to perform calculations |
| IF statement | A logical function (formula) that allows the user to set up a condition to test data |
| Line graph | A type of graph that shows changes in data over a period of time |
| MAX | A spreadsheet function that indicates the highest value in a range |
| MIN | A spreadsheet function that indicates the lowest value in a range |
| Operator | A symbol that represents a mathematical function. Examples: greater than, less than, greater than or equal to |
| Pie graph | A type of graph that divides the total into the parts of a circle |
| Range | A group of cells that are next to each other |
| Relative cell reference | Adjusts the cell references in a formula while retaining the mathematical processes |
| ROUND | A spreadsheet function that rounds numbers to the nearest whole number |
| SUM | A function used to add numbers in a range |
