Term
|
Definition
- a predefined formula that uses the values in the cells you select to calculate the answer
- a preprogrammed Excel formula for a complex calculation
|
|
|
Term
|
Definition
| the name given to one of Excel's predefined formulas |
|
|
Term
|
Definition
- the parts of a formula that are variable
- a variable used in a function; a comma separates each of these in a function
|
|
|
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 w/o making you write a formula: AVERAGE, COUNT, COUNTA, MAX, MIN, or SUM |
|
|
Term
|
Definition
| data arranged in columns & specially formatted with column headers that contain commands that allow you to sort, filter, & perform other functions on the table |
|
|
Term
|
Definition
| special labels that refer to specific data in an Excel table, such as all the data in a column or all the data in the table |
|
|
Term
|
Definition
| a text note attached to a worksheet cell |
|
|
Term
|
Definition
an identification label assigned to a group of cells;
AKA-defined name |
|
|
Term
|
Definition
| a value, some text, or an expression that defines the type of cells you are 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 & SUMIF |
|
|
Term
|
Definition
| using a function as an argument within another function |
|
|
Term
|
Definition
| a graphic that allows you to compare & 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, this is the info in a worksheet column; if you select multiple columns of data for a chart, you'll create multiple of these; 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 the value of each category is plotted |
|
|
Term
|
Definition
| the vertical series of a chart on which the value of each category is plotted |
|
|
Term
|
Definition
| for most charts, this is info in a worksheet row; if you select multiple rows of data for a chart, you'll create multiple of these, & these will be listed along the X-axis |
|
|
Term
|
Definition
| the area defined by the X & Y axes |
|
|
Term
|
Definition
| an item that is treated separately from the main document; in the case of a chart, each chart element is this then can be manipulated independently |
|
|
Term
|
Definition
| the total area occupied by a chart |
|
|
Term
|
Definition
| lines measurement along the value & category axes |
|
|
