You receive the following message from Solver: “Target Cells Must Be in the Formula.” Is Solver ready to

run?

Question 1 options:

Yes

NoSaveQuestion 2 (1 point)

True or False? Constraints are logical conditions that a solution to an optimization problem must satisfy.

Question 2 options:

True

FalseSaveQuestion 3 (1 point)

True or false? Solver can only adjust two variables when producing a solution.

Question 3 options:

True

FalseSaveQuestion 4 (1 point)

Solver adjusts the ______________ in the decision variable cells to satisfy the limits on constraint cells and produce the results you want for the objective cell.

Question 4 options:

Functions

Limits

Formuals

ValuesSaveQuestion 5 (1 point)

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

Question 5 options:

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 ReferenceSaveQuestion 6 (1 point)

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

Question 6 options:

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”SaveQuestion 7 (1 point)

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

Question 7 options:

True

FalseSaveQuestion 8 (1 point)

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

Question 8 options:

True

FalseSaveQuestion 9 (1 point)

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

Question 9 options:

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 OptionsSaveQuestion 10 (1 point)

Complete the sentence. The target cell (or objective cell) contains ___________________.

Question 10 options:

A formula that represents the objective, or goal, of the problem a decision variable

Information that puts constraints on the objective

A solution to the problem you are trying to solve

 

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"