Matching
Match each of the following concepts to its best description:
Premises:
Syntax error
Logic error
Run-time error
Circular reference
Formula auditing
Responses:
Occurs when you use the wrong cell reference in a formula
Occurs when Excel tries to execute a formula or function that is syntactically correct
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:
Syntax error
Logic error
Run-time error
Circular reference
Formula auditing
Premises:
Syntax error
Logic error
Run-time error
Circular reference
Formula auditing
Responses:
Related Questions
Q10: Excel determines the messages returned when a
Q18: =SUM('1st Quarter:4th Quarter'!B4:B12)is a function using a
Q21: A Split Window has three panes by
Q64: The _ function checks a cell to
Q67: If you cannot immediately see the source
Q74: _ cells are referenced by a formula
Q76: A(n)_ error alert accepts invalid data but
Q83: Validation _ are the rules that dictate
Q84: A(n)_ window has two or four panes
Q95: You can drag a split bar off