Matching
Match each of the following terms to its best description:
Premises:
Goal Seek
Solver
Scenario Manager
One-variable data table
Two-variable data table
Responses:
Finds the best way to optimize values within specified constraints.
A structured range that contains different values for two variables to compare how these differing values affect the results for one calculated value.
A structured range that contains different values for one variable to compare how these values affect one or more calculated results
Sets up and compares multiple situations
Solves for a desired result of a formula by changing values
Correct Answer:
Premises:
Responses:
Goal Seek
Solver
Scenario Manager
One-variable data table
Two-variable data table
Premises:
Goal Seek
Solver
Scenario Manager
One-variable data table
Two-variable data table
Responses:
Related Questions
Q6: Match each of the following terms to
Q16: Match each of the following terms to
Q21: Goal Seek is a what-if analysis tool.
Q31: A(n)_ is the changeable input value used
Q33: To add a column header of<b> Payment
Q35: _ analysis enables you to compare how
Q51: Solver has the ability to generate an
Q67: What-if analysis always provides a definitive solution
Q95: _ is an add-in application that searches
Q96: A(n)_ is a structured report organized as