Matching
Match each of the following concepts to its best description:
Premises:
Circular reference
Logic error
Run-time error
Syntax error
Formula auditing
Responses:
Occurs when you reference the cell containing the formula in the formula
Occurs when you use the wrong cell reference in a formula
Occurs when a formula or function violates construction rules
Occurs when Excel tries to execute a formula or function that is syntactically correct
Tools to trace precedence and dependence
Correct Answer:
Premises:
Responses:
Circular reference
Logic error
Run-time error
Syntax error
Formula auditing
Premises:
Circular reference
Logic error
Run-time error
Syntax error
Formula auditing
Responses:
Related Questions
Q71: The TRIM function removes leading and trailing
Q72: What do you call characters that separate
Q73: Embedded data has no the link to
Q74: If you do not want to create
Q75: _are data fields and tables added to
Q77: A company changes name from Wally's Widgets
Q78: What does XML stand for?<br>A)Extensible Markup Language<br>B)Excel
Q79: A(n)_ contains a slash (/)and the name
Q80: Power BI is a _.<br>A)Business Integration tool
Q81: The _ function will change JILL JONES