Reference no: EM132221916

1. What three things do you need to specify before running Solver?

Determines the value that you need to enter in a single input cell to produce a result that you want in a dependent (formula) cell

Predicts data that is based on the previous data point and the previously predicted data point

Determines the values that you need to enter in multiple input cells to produce a result that you want

Creates a special type of table that displays the results of selected formula cells as you systematically change one or two input cells

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

3. True or false? Solver solutions are based on probability.

True

False

4. What is the best explanation of decision variables?

Cells containing values that have no upper or lower limits and are used to make a decision

A group of cells that are used in computing the formulas in the objective and constraint cells

A report that shows different decisions you can make based on varying circumstances

A formula that changes depending on certain variables

5. 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”

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

True

False

7. 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

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

Yes

No

9. 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

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

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