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?