Term
|
Definition
| A graphic that allows you to compare and contrast data in a visual format. |
|
|
Term
|
Definition
| A chart placed as an object within a worksheet. |
|
|
Term
|
Definition
| A chart that occupies its own worksheet. |
|
|
Term
|
Definition
| To position data points on a graph. |
|
|
Term
|
Definition
| For most charts, the information in a worksheet column. Each is then represented by its own color bar, line, or column. |
|
|
Term
|
Definition
| A key that identifies each of the data series in a chart. |
|
|
Term
|
Definition
| The horizontal scale of a chart on which categories are plotted. |
|
|
Term
|
Definition
| The vertical scale of a chart on which the value of each category is plotted. |
|
|
Term
|
Definition
| For most charts, information in a worksheet row. These will be listed along the x-axis. |
|
|
Term
|
Definition
| The area defined by the x and y axes. |
|
|
Term
|
Definition
| An item that is treated separately from the main document. In the case of a chart, each chart element can be manipulated independently. |
|
|
Term
|
Definition
| The total area occupied by a chart. |
|
|
Term
|
Definition
| Lines of measurement along the value and category axes. |
|
|
Term
|
Definition
| A cell address expressed in relation to the cell containing the formula. For example, rather than naming a specific cell in a formula, a relative cell reference might identify a cell three columns to the left of the cell containing the formula. When such a formula is copied, the relative cell references are adjusted to reflect the new location of the formula cell. |
|
|
Term
|
Definition
| A cell address, such as $E$14, referenced in a formula that does not change based on the location of the cell that contains the formula. |
|
|
Term
|
Definition
| The parts of a formula that are variable. You select the cell or cells, and Excel calculates the answers based on their values. |
|
|
Term
|
Definition
| To use a function as an argument within another function. |
|
|
Term
|
Definition
| A feature that speeds up the manual entry of functions. |
|
|
Term
|
Definition
| A feature that temporarily performs the following calculations on a range of cells without making you write a formula. For example, SUM, MIN, MAX, AVERAGE. |
|
|
Term
|
Definition
| A text note attached to a worksheet cell. |
|
|
Term
|
Definition
| A preprogrammed Excel formula for a complex calculation. |
|
|
Term
|
Definition
| A value, some text, or an expression that defines the type of cells you’re looking for. |
|
|
Term
|
Definition
| A sort of equation (such as B6>25) that returns a value, such as TRUE or FALSE. Excel uses these to identify cells to include in certain formulas, such as IF and SUMIF. |
|
|
