Matching
Match the following terms to their description.
Premises:
Scenario Manager
Changing cells
Scenario
Scenario summary report
Scenario PivotTable report
Responses:
The cell that contains the formula-based value that you want to optimize
A rule that Solver has to enforce to reach the optimal solution
An application that can be added to a primary program,such as Excel,that is not automatically activated
A limitation that imposes restrictions on Solver
A cell containing a variable whose value changes until Solver optimizes the objective cell
Correct Answer:
Premises:
Responses:
Scenario Manager
Changing cells
Scenario
Scenario summary report
Scenario PivotTable report
Premises:
Scenario Manager
Changing cells
Scenario
Scenario summary report
Scenario PivotTable report
Responses:
Related Questions
Q25: By selecting the Scenario Summary option,you can
Q26: A(n)_ is an application with specific functionality
Q27: To compare scenarios,create a scenario _ report.
Q28: When using Solver,the constraint cell contains a
Q29: The Simplex LP,Generalized Reduced Gradient Nonlinear,and Evolutionary
Q31: To create scenario summary reports,click the _
Q32: A(n)_ allows you to build a what-if
Q33: Match the following terms to their description.
Q34: The Goal Seek command is located in
Q35: To add a scroll bar,you first need