Matching
Match each of the following concepts to its best description:
Premises:
Formula auditing
Logic error
Circular reference
Syntax error
Run-time error
Responses:
Occurs when a formula or function violates construction rules
Occurs when Excel tries to execute a formula or function that is syntactically correct
Occurs when you use the wrong cell reference in a formula
Occurs when you reference the cell containing the formula in the formula
Tools to trace precedence and dependence
Correct Answer:
Premises:
Responses:
Formula auditing
Logic error
Circular reference
Syntax error
Run-time error
Premises:
Formula auditing
Logic error
Circular reference
Syntax error
Run-time error
Responses:
Related Questions
Q61: Which is not an option for arranging
Q62: A Warning error style prevents the user
Q63: By default, _ text appears underlined in
Q64: The _ function checks a cell to
Q65: An icon of stacked sheets displays on
Q67: If you cannot immediately see the source
Q68: Match each of the following terms to
Q69: All of the following could produce a
Q70: What do blue arrows mean when tracing
Q71: Which error message would be the result