| A | B |
| absolute refernces | formulas that contain cell references that will not change because dollar signs have been used with the cell name |
| argument | used by a function to perform a set of calculations |
| AVERAGE | function that adds the values of the cells in a range and divides the result by the number of cells in the range |
| bar chart | data graphed as a series of vertical bars |
| cell | where a row and column intersect, identified by its column letter and row number |
| cell reference | the column letter and row number used to identify a cell |
| chart | a graphical representation of data stored in a spreadsheet |
| column | vertical line of data identified by a letter |
| column chart | data graphed as a series of horizontal bars |
| COUNT | function that counts all thenon-blank cells in a range |
| fill handle | used to copy the cell's contents to adjacent cells |
| formula | mathematical statement used to calculate values |
| functions | used in formulas to perform common calculations |
| label | words or characters stored in a cell that cannot be used in calculations |
| legend | contains labels that identify the series in a chart |
| line chart | data graphed using a continuous line |
| mathematical operators | examples are +, *, -, / |
| MAX | function that displays the largest value in a range of cells |
| MIN | function that displays the smalles value in a range of cells |
| numeric label | a number that will not be used in calculations, example is social security number |
| pie chart | data graphed as segments of a circular pie |
| range | partial row or column of adjacent cells |
| relative reference | excel automatically changes the cell references of a copied formula to apply to the new row or column |
| row | horizontal line of data identifed by a number |
| spreadsheet | rows and columns of data on which calculations can be performed |
| SUM | function that adds the vlues in a range of cells |
| values | numeric data that can be stored in cells and used in calculations |
| workbook | the name given to a spreadsheet by Excel |