Term
|
Definition
| reserved place in the computers memory that allows you to collect text and graphic items from an Office document and then paste them into any Office document |
|
|
Term
|
Definition
| using the mouse to move or copy cells |
|
|
Term
|
Definition
| indicates a cell reference error |
|
|
Term
|
Definition
| can be used when entering data to automatically format the data in the selected format; can use $, `, or % |
|
|
Term
|
Definition
| displays the row and column titles at the edges of your screen, no matter how far you scroll down |
|
|
Term
|
Definition
| shows date a worksheet, report, or other document was created |
|
|
Term
|
Definition
| one of 14 date & time functions; returns a number that corresponds to the system date and time |
|
|
Term
|
Definition
| instructs Excel to keep the cell reference constant in the formula as it copies it to the destination area |
|
|
Term
|
Definition
| cell reference with only one dollar sign before either the column or the row |
|
|
Term
|
Definition
| instructs Excel to adjust the cell reference as it copies to the destination area |
|
|
Term
|
Definition
| used to assign a value to a cell based on a logical test |
|
|
Term
|
Definition
| the action to be taken for the true or false case includes another IF function |
|
|
Term
|
Definition
| underlines only the characters in the cell |
|
|
Term
|
Definition
| identifies each data series of a chart |
|
|
Term
|
Definition
| separate worksheet that only contains a chart |
|
|
Term
|
Definition
| the data that the chart represents |
|
|
Term
|
Definition
| Pie chart with one or more slices offset |
|
|
Term
|
Definition
| shows the relationships or proportion of part to a whole |
|
|
Term
|
Definition
| separating a piece of the chart from the rest of it |
|
|
Term
|
Definition
| scrutinizes the impact of changing values in cells that are referenced by a formula in another cell |
|
|
Term
|
Definition
| another name for sensitivity analysis |
|
|
Term
|
Definition
| another name for what-if analysis |
|
|
Term
|
Definition
| determines the value of a cell on which the formula depends |
|
|
