Multiple Choice
A relative cell reference
A) indicates a cell's specific location and the reference does not change when you copy the formula.
B) contains both an absolute and a relative cell reference.
C) indicates a cells relative location from the cell containing the formula; the reference changes when you copy the formula.
D) occurs when a formula directly or indirectly refers to the cell containing the formula.
Correct Answer:
Verified
Correct Answer:
Verified
Q32: The COUNTA function<br>A) evaluates a condition and
Q33: A _ name is a word or
Q34: Semi-selection is often called _ because you
Q35: The NPER<br>A) is the total number of
Q36: The MAX function identifies the highest value
Q38: The MAX function<br>A) tallies the number of
Q39: A function is a predefined formula that
Q40: The _ value is a reference to
Q41: The lookup value<br>A) is the argument in
Q42: The HLOOKUP function<br>A) is the periodic interest