Term
|
Definition
| Is a powerful decision-making tool containing data that can be manipulated to answer "what if" situation. |
|
|
Term
|
Definition
| After typing a formula in a cell, press the Enter key, the Tab key, Shift+Tab, or click the Enter button on the Formula bar. |
|
|
Term
|
Definition
| When writing your own formula, begin the formula with the equlas sign. |
|
|
Term
|
Definition
| If a formula conatins two or more operators, Excel uses the same order of operations used in algebra. |
|
|
Term
|
Definition
| If you want to change the order of operations, use parenthesis around the part of the formula you want calculated first. |
|
|
Term
|
Definition
| In a situation where a fromula is copied to toher location in a worksheet. |
|
|
Term
| Fill Button or Fill Handle |
|
Definition
| Top copy s formula relatively in a worksheet, use the Fill button (you used a fill handle to copy a formula in Chapter 1) |
|
|
Term
|
Definition
| Hold down the left mouse button, drag and select the desired data in the cell (text. value, formula, etc.). |
|
|
Term
| Writing a Formula by Pointing |
|
Definition
|
|
Term
|
Definition
| A button pop up near the active cell |
|
|
Term
|
Definition
| A small dark green triangle also displays in the upper left corner of the cell. |
|
|
Term
|
Definition
| The beggining of the section of the formula, =SUM, is called a function, which is a built-in formula. |
|
|
Term
|
Definition
| It consist of a constant, a cell reference, or another function. |
|
|
Term
|
Definition
| If a function is included in a argument within a function it is called a nested function |
|
|
Term
|
Definition
| When a value calcuted by the formula is inserted in a cellm this process is referred as returning the result. |
|
|
Term
|
Definition
| You can type a function in a cell in a worksheet or you can use the Insert function button on the Formula bar or in the Formulas tab to help you write the formula. |
|
|
Term
|
Definition
| At the Insert Function dialog box display in the select a function |
|
|
Term
|
Definition
| By clicking the down-pointing arrow at the right side of the select a category list box and the clicking the desired category at the drop-down list. |
|
|
Term
|
Definition
| You can also display the Insert Function dialoque box by clicking the down-pointing arrow at the right side of the select a category list box and the clicking the desired category at the drop-down list. |
|
|
Term
|
Definition
| Feature that displays a drop-down list of functions. |
|
|
Term
|
Definition
| AVERAGE, MAX, MIN, and COUNT |
|
|
Term
|
Definition
| A range of cells is added togfether and then divided by the number of cell entries. |
|
|
Term
|
Definition
| For not applicable or leave the cell blank |
|
|
Term
|
Definition
| It returns the maximum value in a cell range. |
|
|
Term
|
Definition
| Returns the minimum value in a cell range. |
|
|
Term
|
Definition
| Function to count the numeric values in a range. |
|
|
Term
|
Definition
| Ctrl+' to display formulas. |
|
|
