Matching
Match each of the following terms to its best description:
Premises:
Non-binding constraint
Optimization model
Solver
Binding constraint
Objective cell
Responses:
A constraint that does not restrict the target value that Solver finds
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
Cell that contains the formula to produce a value to be optimized
Find the highest, lowest, or exact value for one particular result by adjusting values for selected variables
A limit that Solver must follow to find the optimal value
Correct Answer:
Premises:
Responses:
Non-binding constraint
Optimization model
Solver
Binding constraint
Objective cell
Premises:
Non-binding constraint
Optimization model
Solver
Binding constraint
Objective cell
Responses:
Related Questions
Q51: Solver has the ability to generate an
Q52: Which of the following is not a
Q53: Which is not true about Scenario Manager?<br>A)Is
Q54: If cell B5 contains the value 6
Q55: Scenario Manager is not an Excel Add-in.
Q57: Where does Excel create a Scenario Summary
Q58: Which of these is not part of
Q59: A Scenario Manager Summary report displays the
Q60: How many scenarios can Scenario Manager manage?
Q61: Select _ from the File menu to