# functions and formulas

The flashcards below were created by user girl1tweety on FreezingBlue Flashcards.

1. Absolute cell reference
A designation that provides a permanent reference to a specific cell. When you copy a formula containing an absolute cell reference, the cell reference in the copied formula does not change, regardless of where you copy the formula. An absolute cell reference appears with a dollar sign before both the column letter and row number, such as \$B\$5.
2. Argument
A variable or constant input, such as a cell reference or value, needed to complete a function. The entire group of arguments for a function is enclosed within parentheses.
3. AVERAGE function
A predefined formula that calculates the arithmetic mean, or average, of values in a range.
4. Breakpoint
The lowest value for a specific category or series in a lookup table.
5. Circular reference
A situation that occurs when a formula contains a direct or an indirect reference to the cell containing the formula.
6. Column index number
The number of the column in the lookup table that contains the return values.
7. COUNT function
A predefined formula that tallies the number of cells in a range that contain values you can use in calculations, such as numerical and date data, but excludes blank cells or text entries from the tally.
8. COUNTA function
A predefined formula that tallies the number of cells in a range that are not blank; that is, cells that contain data whether a value, text, or a formula.
9. COUNTBLANK function
A predefined formula that tallies the number of cells in a range that are blank.
10. Formula AutoComplete
A feature that displays a list of functions and defined names that match letters as you type a formula.
11. Function
A predefined computation that simplifies creating a complex calculation and produces a result based on inputs known as arguments.
12. Function ScreenTip
A small pop-up description that displays the arguments for a function as you enter it.
13. HLOOKUP function
A predefined formula that looks up a value in a horizontal lookup table where the first row contains the values to compare with the lookup value.
14. IF function
A predefined logical formula that evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
15. Logical test
An expression that evaluates to true or false.
16. Lookup table
A range that contains data for the basis of the lookup and data to be retrieved.
17. Lookup value
The cell reference of the cell that contains the value to look up within a lookup table.
18. MAX function
A predefined formula that finds the highest value in a range.
19. MEDIAN function
A predefined formula that finds the midpoint value, which is the value that one-half of the population is above or below.
20. MIN function
A predefined formula that finds the lowest value in a range.
21. Mixed cell reference
A designation that combines an absolute cell reference with a relative cell reference. When you copy a formula containing a mixed cell reference, either the column letter or the row number that has the absolute reference remains fixed, whereas the other part of the cell reference that is relative changes in the copied formula. A mixed cell reference appears with the \$ symbol before either the column letter or row number, such as \$B5 or B\$5.
22. Nested function
A function that contains another function embedded inside one or more of its arguments.
23. NOW function
A predefined formula that uses the computer’s clock to display the current date and time in a cell.
24. Nper
The number of payment periods over the life of the loan.
25. PMT function
A predefined formula that calculates the periodic payment for a loan with a fixed interest rate and fixed term.
26. Pointing
The process of using the mouse pointer to select cells while building a formula. Also known as semi-selection.
27. Pv
The present value of the loan or an annuity.
28. Range name
A word or string of characters assigned to one or more cells. It can be up to 255 letters, characters, or numbers, starting with a letter.
29. Rate
The periodic interest rate; the percentage of interest paid for each payment period.
30. Relative cell reference
A designation that indicates a cell’s relative location within the worksheet using the column letter and row number, such as B5. When a formula containing a relative cell reference is copied, the cell references in the copied formula change relative to the position of the copied formula.
31. Semi-selection
The process of using the mouse pointer to select cells while building a formula. Also known as
32. SUM function
A predefined formula that calculates the total of values contained in two or more cells.
33. Syntax
The rules that dictate the structure and components required to perform the necessary calculations in an equation or evaluate expressions.
34. Table array
The range that contains the body of the lookup table, excluding column headings. The first column must be in ascending order to find a value in a range, or it can be in any order to look up an exact value.
35. TODAY function
A predefined formula that displays the current date in a cell.
36. VLOOKUP function
A predefined formula that looks up a value and returns a related result from the lookup table.
 Author: girl1tweety ID: 123768 Card Set: functions and formulas Updated: 2011-12-15 02:41:18 Tags: functions formulas Folders: Description: functions and formulas Show Answers: