Multiple Choice
A range name:
A) indicates a cell's specific location and the reference does not change when you copy the formula.
B) is a word or a string of characters that represent one or more cells.
C) indicates a cell's relative location from the cell containing the formula.
D) always begins with an equal sign (=) .
Correct Answer:
Verified
Correct Answer:
Verified
Q21: A relative cell _ indicates a cell's
Q41: The lookup value<br>A) is the argument in
Q75: The nper in a PMT function is:<br>A)the
Q76: What is a lookup table used for?<br>A)It
Q77: Match the terms to their descriptions:
Q78: The first argument in a PMT function
Q80: The _ function returns one value if
Q82: The =DATE(year,month,day)function returns a(n)_ for a date.
Q83: If you change a range name,you must
Q84: Excel displays a red arrow in the