Solver Quiz - Attempt 1
A formula that represents the objective, or goal, of the problem a decision variable
Complete the sentence. The target cell (or objective cell) contains __________________
NOT: Iterations
If Solver cannot find a solution, you can click on the __________ button to control the aspects of how Solver solves a problem
Set the objective box to "value of"
If the target cell must equal a specific value, what action should be taken on the Solver dialog box?
NOT: Set the objective box to "max" and do not check the assume non-negative box in options
If you are using solver to determine how many of each item should be produced to maximize profit you should...
True
True or false: Solver may yield a solution that indicates less than a whole number of items to be produced
False
True or false? Solver solutions are based on probability.
A cell reference, an operator, and a constraint value
What three fields are located on the add constraint dialog box?
Target cell, decision variables, and constraints
What three things do you need to specify before running Solver?
Determines the values that you need to enter in multiple input cells to produce a result that you want
Which of the following is the best description of how Solver works?
NOT: Management defining minimum outputs
Which of the following would not result in a constraint being added to the programming for Solver?