Matching
Match the formulas to their descriptions:
Premises:
=($C5+D5)*$E5
=(C5+D5)*E5
=(C5+D5)*$E$5
Responses:
includes a circular reference
uses a mixed reference
uses only an absolute reference
uses only relative references
includes an absolute reference
Correct Answer:
Premises:
Responses:
includes a circular reference
uses a mixed reference
uses only an absolute reference
uses only relative references
includes an absolute reference
Premises:
includes a circular reference
uses a mixed reference
uses only an absolute reference
uses only relative references
includes an absolute reference
Responses:
Related Questions
Q21: A relative cell _ indicates a cell's
Q68: The IF function:<br>A)contains data for the basis
Q69: The _ function category performs tests and
Q70: The pv of a PMT function refers
Q71: Match the range names to their descriptions:
Q72: Match the argument types to their function:
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