The flashcards below were created by user
davecowman
on FreezingBlue Flashcards.
-
Relative Cell Reference (p. 158)
Indicates a cell's relative location, such as five rows up and one column to the left, from the cell containing the formula.
-
Absolute Cell Reference (p. 158)
Provides a permanent reference to a specific cell.
-
Mixed Cell Reference (p. 160)
Combines an absolute cell reference with a relative cell reference.
-
Circular Reference (p. 160)
A formula that contains a direct or indirect reference to the cell containing the formula.
-
Function (p. 166)
Predefined computation that simplifies creating a formula that performs a complex calculation.
-
Argument (p. 166)
An input, such as a cell reference or value, needed to complete a function
-
Syntax (p. 166)
A set of rules that governs the structure and components for properly entering a function.
-
Formula AutoComplete (p. 166)
Displays a list of functions and defined names that match letters as you type a formula.
-
Function ScreenTip (p.167)
A small pop-up description that displays the function's arguments.
-
SUM function (p. 168)
Totals values in two or more cells and displays the result in the cell containing the function.
-
AVERAGE function (p. 170)
Calculates the arithmetic mean, or average, for the values in a range of cells.
-
MEDIAN function (p. 170)
Finds the midpoint value, which is the value that one half of the data set is above or below.
-
MIN function (p. 171)
Displays the lowest value in a range.
-
MAX function (p. 171)
Identifies the highest value in a range.
-
COUNT function (p. 171)
Tallies the number of cells in a range that contain values.
-
COUNTBLANK function (p. 171)
Tallies the number of cells in a range that are blank.
-
COUNTA function (p. 171)
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.
-
TODAY function (p. 173)
Displays the current date.
-
NOW function (p. 173)
Uses the computer's clock to display date and military time.
-
IF function (p. 181)
Evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
-
Logical Test (p. 182)
An expression that evaluates to true or false.
-
Lookup Table (p. 184)
A range that contains data for the basis of the lookup and data to be retrieved.
-
Breakpoint (p. 184)
The lowest value for a category or in a series.
-
VLOOKUP function (p. 184)
Looks up a value in a vertical lookup table and returns a related result from the lookup table.
-
PMT function (p. 187)
Calculates the periodic payment for a loan with a fixed interest rate and fixed term.
-
Rate (p. 187)
Is the periodic interest rate, the interest rate per payment period.
-
NPER (p. 187)
Is the total number of payment periods.
-
PV (p. 187)
Is the present value of the loan.
-
Range Name (p. 192)
A word or string of characters that represents one or more cells.
|
|