Term
|
Definition
| Is a powerful decesion-making tool containing data that can be manipulate to asnwer "what if" situations. |
|
|
Term
|
Definition
| After typing a formula in a cell, press the enter, or click the enter button on the formala bar. |
|
|
Term
|
Definition
| From left to right in a formula |
|
|
Term
|
Definition
| Copys the formula containing relative cell references and the cell reference change. |
|
|
Term
|
Definition
| copy a relative version of a formula. |
|
|
Term
| Writing a formula by Pointing |
|
Definition
| You wrote formulas using cell reference such as =c3-b3.A method is to "point" to the specific cells that are part of the formula. |
|
|
Term
|
Definition
| You can use it to read information on what Excel percieves as the error. |
|
|
Term
|
Definition
| Is the another name for trace error. |
|
|
Term
|
Definition
| Is a built-in formulas. An example of a function is =sum. |
|
|
Term
|
Definition
| An argument may consist of a constant, a cell reference, or another function. |
|
|
Term
|
Definition
| Is a function that includes in an argument within the function. |
|
|
Term
|
Definition
| Is when a value calculated by the formula is inserted in a cell. |
|
|
Term
|
Definition
| Refers to the process of calculating the formula and the term result. |
|
|
Term
|
Definition
| Insert Function button on the Formula bar or in the Formulas tab to help you write the formula. |
|
|
Term
|
Definition
| You can also dispay the Insert Function dialog box by cliking the down-pointing arrow at the right side of the sum button and then cliking more button. |
|
|
Term
|
Definition
| Click the down-pointing arrow at the right side of the sum button in the Formulas tab and common functions dsplay a drop-down list. |
|
|
Term
|
Definition
| With the disired function category selected, choose a function in the select a function box and then click OK. |
|
|
Term
|
Definition
| Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text, Logical, Information, Engineering, and Cube. |
|
|
Term
|
Definition
| It returns the average of the argument. |
|
|
Term
|
Definition
| Returns teh maximum value in a cell range |
|
|
Term
|
Definition
| Returns the minimum value in a cell range. |
|
|
Term
|
Definition
| It counts the numeric values in a range. |
|
|
Term
|
Definition
| Displaying all formulas in a workseet rather than the result by pressing Ctrl + ' this turn off the formulas. |
|
|
Term
|
Definition
| Finds the periodic payment for a loan base on costant payments and a costant interest rate. |
|
|
Term
|
Definition
| It calculates the future value of a series of equal payments or annuity. |
|
|
Term
|
Definition
| Now function returns the serial number of the current date and time. The Date function returns the serial number that represents a particular date. |
|
|
Term
|
Definition
| Is the keyboard shortcut to insert the current date in the active cell. |
|
|
Term
|
Definition
| It consired the IF function |
|
|
Term
|
Definition
| a question that can be answered with true or false considered. |
|
|
