Matching
Match each of the following concepts to its best description:
Premises:
Logic error
Formula auditing
Syntax error
Run-time error
Circular reference
Responses:
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 a formula or function violates construction rules
Tools to trace precedence and dependence
Occurs when you reference the cell containing the formula in the formula
Correct Answer:
Premises:
Responses:
Logic error
Formula auditing
Syntax error
Run-time error
Circular reference
Premises:
Logic error
Formula auditing
Syntax error
Run-time error
Circular reference
Responses:
Related Questions
Q10: What would be the return of the
Q15: There are a total of _ text
Q20: Each data field or table added to
Q27: Power Pivot can import XML data.
Q32: Tab-delimited files use tabs to separate data
Q33: If you import web data directly into
Q61: _ is a business intelligence tool that
Q74: If you do not want to create
Q84: XML is _.<br>A)Excel's version of HTML<br>B)a method
Q87: Where can you open XML files in