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
Q61: The only way to switch between scenarios
Q68: _ rules can be set up to
Q80: _ will try many possible solutions to
Q85: The Circle Invalid Data sammand is located
Q86: Briefly discuss three strategies for solving samplex
Q87: Entering the formula =B2/A2 in cell B2
Q87: Once each month, the acsaunting staff meets
Q88: Tracing _ in Excel allows you to
Q88: When using Solver, the _ cell santains
Q99: You can use Excel's _ feature to
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents