Reference no: EM132412076

Question 1:

To determine how many items should be produced, you program Solver to produce a minimum value as a target cell objective. Solver indicates that zero items should be produced. What programming error listed below would lead to this result?

• Setting the Objective box to "max"
• Setting the Objective box to "max" and not checking the Assume Non-Negative box in Options
• Not setting a minimum number of items to be produced in Constraints
• Setting the Objective box to "max" and checking the Assume Non-Negative box in Options

Question 2:

Which of the following are Solver options available in the Options dialog box? Select all that apply.

a) Show Iteration Results

b) Restore Original Values

c) Max Time

d) Constraint Precision

Question 3

Which of the following would not result in a constraint being added to the programming for Solver?

• Management defining minimum outputs
• A limited inventory of raw materials needed for production
• A limited availability of a machine to produce a specific item
• Marketing changing the selling price of the items produced

Question 4

If you are using Solver to determine how many of each item should be produced to maximize profit you should . . . .

• Set the Objective box to "min" and check the Assume Non-Negative box in Options
• Set the Objective box to "max" and check the Assume Non-Negative box in Options
• Set the Objective box to "max" and do not check the Assume Non-Negative box in Options
• Set the Objective box to "min" and do not check the Assume Non-Negative box in Options

Question 5:

If Solver cannot find a solution, you can click on the ___________ button to control the aspects of how Solver solves a problem.

• Retry
• Methods
• Options
• Iterations

Question 6:

What three fields are located on the Add Constraint dialog box?

• A Cell Reference, an operator, and a Constraint value
• A Cell Reference, a Units Cell, and a Table Reference
• A Units Cell, an operator, and a Constraint value
• A Target Cell, a Units Cell, and a Table Reference

Question 7:

True or false? Solver will correct programming errors in your spreadsheets.

TrueFalse

Question 8:

True or false: Solver may yield a solution that indicates less than a whole number of items to be produced.

TrueFalse

Question 9:

 If the target cell must equal a specific value, what action should be taken on the Solver dialog box?

• Selection options and check the Assume Non-Negative box
• Set the objective box to "max"
• Set the objective box to "min"
• Set the objective box to "value of"

Question 10:

True or false? If you change the programming in your spreadsheet, you need to run Solver again and determine a new solution.

TrueFalse