| A | B |
|---|
| Absolute cell address | A cell reference in Excel that does not change when copied to a new cell, identified by adding a “$” before the cell address (example: $B$5). |
| Area chart | Type of Excel chart that represents data as the area under a trend line. |
| AutoSum | Excel function that automatically adds a set of numbers and places the sum in a specified cell. |
| AVERAGE | Excel function that calculates the average of a set of numbers. |
| Bar chart | Type of Excel chart that represents each data point as a horizontal bar. |
| Cell range | Group of cells selected or identified in Excel specified by listing the top-left cell of the range followed by a colon and the cell in the lower-right corner of the range. |
| Chart | Graphical representation of a series of data. |
| Chart title | Heading at the top of a chart. |
| Chart Tools tab | Tab that appears in the Excel Ribbon when the user creates a chart; provides additional commands for customizing a chart; includes the sub-tabs Design, Layout, and Format. |
| Circular reference | Error that occurs when a formula directly or indirectly refers back to its own cell. |
| Column chart | Type of Excel chart that represents each data point as a vertical bar. |
| COUNT | Excel function that counts the number of cells in a range (that contain numbers). |
| Data label | The X and Y axis titles. |
| Filter | Spreadsheet application feature that hides unwanted information. Also a program or feature used to block spam or e-mail messages from specific senders. |
| Formula | Calculation using functions to spreadsheet.find mathematical results in a |
| Function | Mathematical calculation or other set of instructions that performs a pre-designed action such as add, subtract, and so on. |
| Gridline | Lines between cells in a Word table or Excel spreadsheet. Also the lines that go across the plot area in a chart and represent each axis value. |
| Legend | Area that shows what each data line represents. |
| Line chart | Type of Excel chart that represents each set of data as a line. |
| MAX | Excel function that determines the largest value in a list of values. |
| MIN | Excel function that determines the smallest number in a list of values. |
| Mixed cell reference | Cell reference in Excel where either the column is fixed and the row is relative or the row is fixed and the column is relative but not both. Examples include $B5 and B$5. |
| Pie chart | Type of Excel chart that represents a data point as a pie shaped piece of the whole. |
| Plot area | Central part of a chart that contains a diagram of the data. |
| Precedence | Order in which the operations of an Excel formula should be performed. |
| Print area | Range of cells or section of an Excel spreadsheet that the user wants to print. |
| Relative cell address | Cell reference in Excel that changes when the formula is copied to a new location. |
| Sort | Function that allows data in a table, spreadsheet, or e-mail to be re-ordered either alphabetically or numerically. |
| SUM | Excel function that adds all the numbers in a range of cells. |
| Trendline | Lines that represent the data in an Excel chart. |
