Matching
Match each of the following terms to its description:
Premises:
Solver
Add-in
Constraint
Binding constraint
Changing variable cell
Responses:
Cell containing a variable whose value changes until Solver optimizes the value in the objective cell.
Manipulates variables based on constraints to find the optimal solution to a problem
Limit placed on the Solver model
Solver must enforce this to solve the model.
Enhances functionality in Excel
Correct Answer:
Premises:
Responses:
Solver
Add-in
Constraint
Binding constraint
Changing variable cell
Premises:
Solver
Add-in
Constraint
Binding constraint
Changing variable cell
Responses:
Related Questions
Q11: Match each of the following terms to
Q14: You do need to use an absolute
Q17: Match each of the following terms to
Q20: Which of these would be a good
Q25: A one-variable data table can be built
Q33: To add a column header of<b> Payment
Q51: Solver has the ability to generate an
Q66: What is an Excel Add-in?<br>A)All what-if analysis
Q67: What-if analysis always provides a definitive solution
Q95: _ is an add-in application that searches