Term
|
Definition
| powerful decision making thing. insert formula, it solves. |
|
|
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
|
|
Term
|
Definition
| formula is copied to other locations in a worksheet use... |
|
|
Term
|
Definition
| use the fill handle to copy a relative version of a formula. |
|
|
Term
|
Definition
| creating a formula by pointg is more accurate than typing the cell reference since a mistake can happen. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| beginning section of the formula =sum |
|
|
Term
|
Definition
| function operates on what is referred to as an... |
|
|
Term
|
Definition
| if a function is included in an arguement within a function, it is called a .... |
|
|
Term
|
Definition
| when a value calculated by the formula is inserted in a cell |
|
|
Term
|
Definition
| refers to inserting the value in the cell |
|
|
Term
|
Definition
| when you insert a function |
|
|
Term
|
Definition
| you can also display the insert function dialog box by clicking the down pointing arrow at thje right side of the sum button and then clicking MORE FUNCTIONS |
|
|
Term
|
Definition
| click the down pointing arrow at the right side of the sum button in the formulas tab and common functions display in a drop down list. |
|
|
Term
|
Definition
| displays a funtion arguements palette |
|
|
Term
|
Definition
| excel has over 200 functions divided into 11 categories. includes the formula autocomplete feature that displays stuff. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| used to count numberic values in a range |
|
|
Term
| displaying formulas summary |
|
Definition
| display all formulasi in a worksheet rather tan the results by pressing ctrl plus `. press ctrl + ` to turn off the display of formulas |
|
|
