A _____________ performs mathematical operations that produce a calculated result.
Formula
100
A _________ is a preconstructed formula that makes difficult computations less complicated.
function
100
The _____ _________ returns one value when a condition is met and returns another value when the condition is not met.
IF function
100
The ________ ___________ calculates the payment on a loan.
PMT function
100
The small black square in the bottom-right corner of a cell is called what?
fill handle
200
The __________ ____________ ___________ combines an absolute reference with a relative reference.
mixed cell referene
200
The _______ ____________ represented by the sigma, adds up or sums the numeric entries within a range of cells.
SUM function
200
The ________ ____________ looks up an answer from a table of possible answers.
VLOOKUP function
200
The _____________ ___________ returns the future value of an investment.
FV function
200
You just won free points!
Hey!
300
The _________ ____________ is a small black square in the bottom-right corner of a selected cell.
fill handle
300
___________ are values as input that perform an indicated calculation, and then return another value as output.
Arguments
300
The _______ ___________ is the value to look up in a reference table.
lookup value
300
What must be entered to start a formula?
=
400
A ________ _________ ___________ is a typical cell reference that changes when copied.
relative cell reference
400
The ____________ _____________ counts the number of cells in a range that are not blank.
COUNTA function
400
The ___________ ____________ ________ is the column number in the lookup table that contains return values.
column index number
400
If you want to determine the future value of an investment, what function would you use?
FV
500
An _________ __________ __________, indicated by dollar signs before the column letter and row number, stays the same regardless of where a formula is copied.
absolute cell reference
500
The ____________ ____________ finds the midpoint value in a set of values.
MEDIAN function
500
A ____________ is the lowest numeric value for a category or series in a lookup table to produce a corresponding result for a lookup function.
breakpoint
500
The MAX function is an example of what type of function?