Solved

Match the Formulas to Their Descriptions

Question 95

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:

includes a circular reference
uses a mixed reference
uses only an absolute reference
uses only relative references
includes an absolute reference
Related Questions

Q90: What are the rules for creating range

Q91: Match the function categories to their descriptions:

Q92: Match the terms to their descriptions:

Q93: Match the math and statistical functions to

Q94: Match the terms to their descriptions:

Q96: Match the date/time function syntax to their

Q97: Match the argument types to their function:

Q98: Match the descriptions with correct portions of

Q99: Match the range names to their descriptions:

Q100: Match the following Excel buttons with their

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents