Matching
Match each of the following terms to its description:
Premises:
Add-in
Binding constraint
Changing variable cell
Constraint
Solver
Responses:
Manipulates variables based on constraints to find the optimal solution to a problem
Cell containing a variable whose value changes until Solver optimizes the value in the objective cell.
Limit placed on the Solver model
Enhances functionality in Excel
Solver must enforce this to solve the model.
Correct Answer:
Premises:
Responses:
Add-in
Binding constraint
Changing variable cell
Constraint
Solver
Premises:
Add-in
Binding constraint
Changing variable cell
Constraint
Solver
Responses:
Related Questions
Q11: A(n)_ specifies the cell that contains a
Q12: A one-variable table may only be created
Q13: Solver does not support which of the
Q14: You do need to use an absolute
Q15: Solver is on the Formulas tab.
Q17: Goal Seek changes multiple variables to reach
Q18: Associate the following concepts with its corresponding
Q19: If Solver is installed on your computer,
Q20: Which of these would be a good
Q21: Goal Seek is a what-if analysis tool.