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
| where a formula is copied to other locations in a worksheet |
|
|
Term
|
Definition
| Use the fill handle to copy a relative version of a formula |
|
|
Term
|
Definition
| is more accurate than typing the cell reference since a mistake can happen when typing the cell reference |
|
|
Term
|
Definition
| if something goes wrong then the tract error button appears |
|
|
Term
|
Definition
| trace your errors that were recently done on excel worksheet |
|
|
Term
|
Definition
| a shortcut to enter a function |
|
|
Term
|
Definition
| may consist of a constant, a cell reference, or another funtion. |
|
|
Term
|
Definition
| if a funstion is included in an argument within a function is it called this |
|
|
Term
|
Definition
| the term returning refers to the process of calculation the formula and then term result means instering the value in the cell |
|
|
Term
|
Definition
| button which you press to enter a function |
|
|
Term
|
Definition
| you can also display the inster function dialog box by clicking the down-pointing arrow at the right side of the sum button and then clicking more functions |
|
|
Term
|
Definition
| click the downpointing arrow at the eight side of the sum button the formulas tab and common funtions display in a dropdown list |
|
|
Term
|
Definition
| displays a function argument palette |
|
|
Term
|
Definition
| easily manupulate data to answer questions by adding together a range of cells and divied by the number of cells added together |
|
|
Term
|
Definition
| max value in a cell range |
|
|
Term
|
Definition
| min value in a cell range |
|
|
Term
|
Definition
| ctrl+` to display and turn off display of formula |
|
|
Term
|
Definition
|
|
Term
|
Definition
| ctrl+; is the keyboard shortcut to insert the current date in the active cell |
|
|
