Matching
Match the following terms with the corresponding description.
Premises:
Non binding constraint
Objective cell
Add-in
Solver
Optimization models
Responses:
Programs that can be added to Excel to provide enhanced functionality
Specifies the cell that contains a formula that produces a value that you want to optimize
An add-in application 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
Add-in
Solver
Optimization models
Premises:
Non binding constraint
Objective cell
Add-in
Solver
Optimization models
Responses:
Related Questions
Q20: Which of the following tools has the
Q21: Solver can be set to maximize the
Q22: Which of the following tools has the
Q23: Which of the following what-if analysis tools
Q24: A(n)_ is used to compare the impacts
Q26: Multiple objective cells can be used with
Q27: Which of the following is not a
Q28: Where is Goal Seek located in Excel?<br>A)Formula
Q29: Scenario Manager can create PivotTable reports.
Q30: Which what-if analysis tool is best suited