Term
|
Definition
| where a formula is copiedto other locations in a wrksheet |
|
|
Term
|
Definition
| click the desired direction |
|
|
Term
|
Definition
| a button that pops up near the active cell. |
|
|
Term
|
Definition
| may consit of a sonstant, a cell reference, or another function(referred to as a rested function). |
|
|
Term
|
Definition
| if a function is included in an argument within a function |
|
|
Term
|
Definition
| when a value calculated by the formula is inserted in a cell |
|
|
Term
|
Definition
| refers to the process of calculating the formula |
|
|
Term
|
Definition
| refers to inserting the value in the cell. |
|
|
Term
|
Definition
| dialog box by clicking the down-pointing arrow at teh right side of Sum button adn then clicking More Functions. |
|
|
Term
|
Definition
| click the down pointing arrow at teh right side of trhe ?Sum button in the Formulas tab adn common functions display in a drop down list. |
|
|
Term
|
Definition
| is included in teh Math&Trig category |
|
|
Term
| Formula Auto-Complete feature |
|
Definition
| that displays a drop-down list of functions |
|
|
Term
|
Definition
| the beginning of the formula, =SUM |
|
|
Term
| Formulas with Statistical Functions |
|
Definition
| AVERAGE,MAX,MIN, AND COUNT. |
|
|
Term
|
Definition
| returns teh average (arithmetic mean) of the arguments. which will add all of teh test scores for a student and then divide that number by the total number of tests. |
|
|
Term
|
Definition
| returns teh largest value in a set of values. |
|
|
Term
|
Definition
| returns the smallest value in a set of values. |
|
|
Term
|
Definition
| to count the number of cells that contain numbers within the list of arguments. |
|
|
Term
|
Definition
| to turn off the diplay of formulas |
|
|
Term
|
Definition
| finds the periodic payment for a loan based on constant interest rate. contains the arguments Nper, Pv, Fv, and Type. |
|
|
Term
|
Definition
| is the number of payments that will be made to an investment or loan. |
|
|
Term
|
Definition
| is the current value of amunts to be recieved or paid in teh future. |
|
|
Term
|
Definition
| is the value of a loan or investment at the end of all periods, use this funcion to determine information such as how much money can be earned in an investment account with a specific interest rate adn over a specific period of time. |
|
|
Term
|
Definition
| determines whether calculations will be based on payment made in arrears (at the end of each period) or in advance (at the beginning of each period). |
|
|
Term
|
Definition
| returns the serial number of thecurrent date and time. |
|
|
Term
|
Definition
| returns the serial number that represents a particular date. |
|
|
Term
| Aligning or Indenting Data |
|
Definition
| you can align adn indent data in cells using buttons in the Alignment group in the Home tab or with options at the Format cells dialog box with teh Alignment tab. |
|
|
Term
|
Definition
| specifies horizontal and vertical alignment with options |
|
|
Term
|
Definition
| to calcualte sales bonuses, determine letter grades based on test averages, adn identify discounts and discount amounts. |
|
|
Term
|
Definition
| a queation that can be answered with true or false. |
|
|
Term
|
Definition
| by makin active the cell containing the formula adn then editing the formula in the cell or in teh Formula bare text box. |
|
|
Term
|
Definition
| insert symbols such as commas, quotations marks, and parentheses in teh proper locations. formula begins with =IF() |
|
|
Term
|
Definition
| refer to cells in a specific location. |
|
|
Term
|
Definition
| either the column remains absolute adn teh row is relative, absolute, and mixed cell references using the dollar sign ($) |
|
|
