Matching
Match each of the following terms to its best description:
Premises:
Non-binding constraint
Objective cell
Optimization model
Binding constraint
Solver
Responses:
Cell that contains the formula to produce a value to be optimized
A limit that Solver must follow to find the optimal value
An Excel add-in that searches for the best or optimum solution to a problem by manipulating the values for several variables within restrictions that you impose
Find the highest:lowest:or exact value for one particular result by adjusting values for selected variables
A constraint that does not restrict the target value that Solver finds
Correct Answer:
Premises:
Responses:
Non-binding constraint
Objective cell
Optimization model
Binding constraint
Solver
Premises:
Non-binding constraint
Objective cell
Optimization model
Binding constraint
Solver
Responses:
Related Questions
Q11: 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
Q35: _ analysis enables you to compare how
Q57: Where does Excel create a Scenario Summary
Q60: How many scenarios can Scenario Manager manage?
Q64: If you are analyzing how much a
Q70: Where would you setup the two substitution
Q87: If Solver is loaded, it will appear
Q96: A(n)_ is a structured report organized as