Term
|
Definition
| Excel is a powerful decision-making tool containing data that can be manipulated to answer "what if" situations. |
|
|
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
| From Left to right in a formuala is an order of operations. |
|
|
Term
|
Definition
| A situation where a formula is copied to another location in a worksheet. |
|
|
Term
|
Definition
| Use the fill handle to copy a relative version of a formula. |
|
|
Term
| Writing a Formula by Pointing |
|
Definition
| Creating a formual is more accurate than typing the cell reference since a mistake can happen when typing the cell reference. |
|
|
Term
|
Definition
| Pops up when you have a error it has a drop down list that displays options for updating the formual to include specific cells, getting help on the error, ignoring error, editing the error in the formula bar. and completing an error check. |
|
|
Term
|
Definition
| The display of the smart tag button varies depending on the action performed. |
|
|
Term
|
Definition
| Function is a built in formuala. for example =sum is a function |
|
|
Term
|
Definition
| An argument may consist of a constant, a cell reference, or another function (refered to as a nested function) |
|
|
Term
|
Definition
| If a function is includded in an argument within a function its called a nested function. |
|
|
Term
|
Definition
| When a value calculated by the formula is inserted in a cell, the process is referred to as returing the result. |
|
|
Term
|
Definition
| Refers to the process of calculating the formula. |
|
|
Term
|
Definition
| Refers to inserting the value in the cell. |
|
|
Term
|
Definition
| The formulas tab provided the insert function button as well as other buttons for inserting functions in a worksheet. |
|
|
Term
|
Definition
| You can also display the Insert 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 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
| A common function in a formual is the Average Function. |
|
|
