10 Questions
What is the purpose of clicking 'Add' in the dialogue box?
To display the add Constraint box
What is the purpose of the 'int' option in the add Constraint box?
To restrict variables to integer or binary values
Why may the default precision of .000001 be problematic?
It may incorrectly return the message 'Solver could not find a feasible solution'
What is the purpose of checking 'Assume Linear Model' in the Solver Options?
To assume a linear model with non-negative constraints
What is the purpose of using descriptive Excel range names?
To enhance readability
What happens if the default precision is too 'high'?
Solver returns the message 'Solver could not find a feasible solution'
What is the purpose of the 'bin' option in the add Constraint box?
To restrict variables to binary values
Why may the problem be infeasible?
The problem is incorrectly defined
What must be specified if the default precision is too 'high'?
Less precision (i.e., a larger value)
What should be done if Solver does not appear under the Data menu?
Click Excel Office Button > Excel Options > Add-ins > Solver Add-in > OK
Solve optimization problems involving the minimum number of moves, cost, and time. Includes problems on inverting triangles, making bracelets, and finding hidden rewards on a rectangular board.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free