| A | B |
|---|
| absolute cell reference | the cell reference does not change when you copy the formula |
| circular reference | Occurs when a formula directly or indirectly refers to the cell in which the formula is located |
| formula autocomplete | Displays a list of functions and defined names that match letters as you type a formula |
| function | Predefined computation that simplifies creating a complex calculation |
| mixed cell reference | Combines both an absolute cell reference and a relative cell reference in a formula |
| range name | A word or string of characters that represents one or more cells and can be used in formulas instead of cell references |
| relative cell reference | Indicates a cell’s relative location from the cell containing the formula; the cell reference changes when the formula is copied |
| sum function | Calculates total of values contained in two or more cells and displays the result in the cell containing the function |
| today function | Displays the current date |
| min function | Displays the lowest value in a range |
| median function | Identifies the midpoint value in a set of values |
| max function | Identifies the highest value in a range |
| if function | Evaluates a condition and returns one value if the condition is true and a different value if the condition is false |
| average function | Calculates the arithmetic mean, or average, of values in a range |
| argument | An input, such as a cell reference, value, or arithmetic expression needed to complete a function |
| chart | Visual representation of numerical data that compares data and assists to reveal trends or patterns to help people make informed decisions |
| chart area | Contains the entire chart and all of its elements |
| chart element | A component that completes or helps clarify the chart. Some chart elements, such as chart titles, should be included in every chart |
| data labels | Descriptive labels that show the exact value of the data points on the value axis |
| data point | Numeric value that describes a single value on a chart |
| data series | Group of related data points |
| legend | Key that identifies the color, gradient, picture, texture, or pattern assigned to each data series |
| sizing handles | Enables you to adjust the size of the chart; indicated by eight small white-filled squares |
| sparkline | Small line, column, or win/loss chart contained in a single cell |
| gridline | Horizontal or vertical line that extends from the horizontal or vertical axis through the plot area |
| chart title | Label that describes the entire chart; should reflect the purpose of the chart |
