| 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. |
| Active cell | The cell in which you are currently working. |
| Argument | value needed to calculate a function. For example, the function COUNT needs cell references as the arguments:=COUNT(A2:D6). |
| Bar graph | type of graph that represents different quantities by using bars. |
| Cell | point at which a column and a row intersect or meet. |
| Cell address/cell reference | location of a cell as identified by the column letter and row number. |
| Circular reference | Occurs when a formula in a spreadsheet refers to itself. No result is possible and a warning appears. |
| Column | Vertical sections of a spreadsheet. Identified by a letter. |
| COUNT | spreadsheet function that counts the number of cells in a range that contains data. |
| Formula | Statement that performs a calculation. |
| Formula bar | bar below the standard and formatting toolbars where data entered from the keyboard is displayed as it is entered into the cell. |
| 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. |
| Label | Alphabetical text in a spreadsheet. |
| Landscape orientation | paper orientation that is wider than it is tall. |
| Line graph | A type of graph that shows changes in data over a period of time. |
| MAX | spreadsheet function that indicates the highest value in a range. |
| MIN | spreadsheet function that indicates the lowest value in a range. |
| Operator | symbol that represents a mathematical function. Examples: greater than, less than, greater than or equal to |
| Pie graph | type of graph that divides the total into the parts of a circle. |
| Portrait orientation | paper orientation that is taller than it is wide. |
| Range | group of cells closely related. |
| Relative cell reference | Adjusts the cell references in a formula while retaining the mathematical processes. |
| Row | Horizontal sections of a spreadsheet. Identified by a number. |
| Spreadsheet | row and column arrangement of data used to enter, calculate, manipulate, and analyze numbers. |
| SUM | function used to add numbers in a range. |
| Value | number entered on a spreadsheet. |
| What-if analysis | spreadsheet tool used to play out different situations to determine outcome. |
