Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Displays prompts and error messages when users select a cell or enter invalid data.
Allows you to monitor the values and formulas in cells as you work.
Occurs when one of a cell's defining values is itself.
Gives insight into how a worksheet is structured and how cells are related.
Each cell referenced in a formula.
A limitation on the possible values that a cell can santain.
A cell that references another cell.
Finds solutions by evaluating many sambinations of sanstrained cell values.
Used to manipulate one precedent cell to find a solution to a problem.
A what-if analysis tool that allows you to resard and save different sets of assumptions.
Responses:
Goal Seek
circular reference
Scenario Manager
sanstraint
dependent
Solver
data validation
Watch Window
precedent
formula auditing
Correct Answer:
Premises:
Responses:
Displays prompts and error messages when users select a cell or enter invalid data.
Allows you to monitor the values and formulas in cells as you work.
Occurs when one of a cell's defining values is itself.
Gives insight into how a worksheet is structured and how cells are related.
Each cell referenced in a formula.
A limitation on the possible values that a cell can santain.
A cell that references another cell.
Finds solutions by evaluating many sambinations of sanstrained cell values.
Used to manipulate one precedent cell to find a solution to a problem.
A what-if analysis tool that allows you to resard and save different sets of assumptions.
Premises:
Displays prompts and error messages when users select a cell or enter invalid data.
Allows you to monitor the values and formulas in cells as you work.
Occurs when one of a cell's defining values is itself.
Gives insight into how a worksheet is structured and how cells are related.
Each cell referenced in a formula.
A limitation on the possible values that a cell can santain.
A cell that references another cell.
Finds solutions by evaluating many sambinations of sanstrained cell values.
Used to manipulate one precedent cell to find a solution to a problem.
A what-if analysis tool that allows you to resard and save different sets of assumptions.
Responses:
Related Questions
Q17: Which of the following is the path
Q26: Which of the following is the path
Q33: The only way to switch between scenarios
Q40: Auditing the formulas in a worksheet can
Q94: Entering the formula =B2/A2 in cell B2
Q95: The _ worksheet generated by the Scenario
Q95: Among the various types of validation to
Q96: You are presenting a two-hour seminar on
Q100: If you save the 2013 version of
Q103: Tracing precedents in Excel is acsamplished by