Excel Chapter 2 key terms -
Spreasheet skills fully solved &
updated
A set of rules that governs the structure and components for
properly entering a function. - answer Syntax
Displays the current date. - answer TODAY function
Indicates a cell's specific location; the cell reference does not
change when you copy the formula. - answer Absolute cell reference
Occurs when a formula directly or indirectly refers to itself. - answer
Circular reference
An input, such as a cell reference or value, needed to complete a
function. - answer Argument
Identifies the highest value in a range. - answer MAX function
Tallies the number of cells in a range that contain values. - answer
COUNT function
Looks up a value in a vertical lookup table and returns a related
result from the lookup table. - answer VLOOKUP function
A range that contains data for the basis of the lookup and data to
be retrieved. - answer Lookup table
, Calculates the arithmetic mean, or average, of values in a range. -
answer AVERAGE function
Identifies the midpoint value in a set of values. - answer MEDIAN
function
Displays the current date and time. - answer NOW function
Evaluates a condition and returns one value if the condition is true
and a different value if the condition is false. - answer IF function
Calculates the total of values contained in two or more cells. -
answer SUM function
Calculates the periodic payment for a loan with a fixed interest rate
and fixed term. - answer PMT function
Indicates a cell's location from the cell containing the formula; the
cell reference changes when the formula is copied. - answer Relative
cell reference
Contains both an absolute and a relative cell reference in a formula;
the absolute part does not change but the relative part does when
you copy the formula. - answer Mixed cell reference
A word or string of characters that represents one or more cells. -
answer Range name
An expression that evaluates to true or false. - answer Logical test
Displays the lowest value in a range. - answer MIN function
Spreasheet skills fully solved &
updated
A set of rules that governs the structure and components for
properly entering a function. - answer Syntax
Displays the current date. - answer TODAY function
Indicates a cell's specific location; the cell reference does not
change when you copy the formula. - answer Absolute cell reference
Occurs when a formula directly or indirectly refers to itself. - answer
Circular reference
An input, such as a cell reference or value, needed to complete a
function. - answer Argument
Identifies the highest value in a range. - answer MAX function
Tallies the number of cells in a range that contain values. - answer
COUNT function
Looks up a value in a vertical lookup table and returns a related
result from the lookup table. - answer VLOOKUP function
A range that contains data for the basis of the lookup and data to
be retrieved. - answer Lookup table
, Calculates the arithmetic mean, or average, of values in a range. -
answer AVERAGE function
Identifies the midpoint value in a set of values. - answer MEDIAN
function
Displays the current date and time. - answer NOW function
Evaluates a condition and returns one value if the condition is true
and a different value if the condition is false. - answer IF function
Calculates the total of values contained in two or more cells. -
answer SUM function
Calculates the periodic payment for a loan with a fixed interest rate
and fixed term. - answer PMT function
Indicates a cell's location from the cell containing the formula; the
cell reference changes when the formula is copied. - answer Relative
cell reference
Contains both an absolute and a relative cell reference in a formula;
the absolute part does not change but the relative part does when
you copy the formula. - answer Mixed cell reference
A word or string of characters that represents one or more cells. -
answer Range name
An expression that evaluates to true or false. - answer Logical test
Displays the lowest value in a range. - answer MIN function
