Matching
Match the following terms with the corresponding description.
Premises:
One-variable data table
Two-variable data table
Solver
Scenario Manager
Goal Seek
Responses:
A structured range that contains different values for two variables to compare how these differing values affect the results for one calculated value.
A what-if analysis tool that enables you to define and manage up to 32 scenarios to compare their effects on calculated results
A structured range that contains different values for one variable to compare how these values affect one or more calculated results
A tool that enables you to specify a desired result from a formula
An Excel Add-in
Correct Answer:
Premises:
Responses:
One-variable data table
Two-variable data table
Solver
Scenario Manager
Goal Seek
Premises:
One-variable data table
Two-variable data table
Solver
Scenario Manager
Goal Seek
Responses:
Related Questions
Q6: Match the following terms with the corresponding
Q9: Solver can solve linear and nonlinear problems.
Q12: _ has the ability to generate Answer
Q30: Which what-if analysis tool is best suited
Q33: Which what-if analysis tool is the best
Q50: Solver models can be saved and restored.
Q64: This analysis tool has the ability to
Q77: Which of the following tools is best
Q92: Which of the following what-if analysis tools
Q94: If not specified by the user,Solver optimization