Exam 9: Enhancing Decision Making with Solver

In Solver, if you select the Value Of option button, you also must enter a(n) ____.

If Solver attempts the maximum number of iterations without the objective cell converging to an answer, the assumption is that the solution is ____.

A binding status indicates that the constraint does not have a final value that is equal to the value of the constraint.

Of the three Solver reports, the ____ report is the most frequently used and most useful report for business users.

By including the constraints in your worksheet, you will have ____.

Identify the letter of the choice that best matches the items in the Solver answer report above. -Includes detailed information about the objective cell, variable cells, and constraints A)#1 B)#2 C)#3 D)#4 E)#5 F)#6

The ____ dialog box lets you put limits on the amount of iterations Solver will attempt to solve a problem.

You can set up complex business models in a worksheet and use Goal Seek to change more than one cell at a time. _________________________

When Solver cannot find a feasible solution, it still produces an answer report.

Any Solver solution requires a well-organized spreadsheet that links the variable cells with the objective cell and the known facts about the problem with the objective cell.

Ava is setting up a production model for her jewelry-making business. She decides to use Solver to find the optimal number of topaz and onyx pendants to produce with the given constraints. One of the most important constraints is that the minimum number to produce is 100 of each. Please answer the questions below, referencing the above figure as needed. -Ava is ready to fill in the By Changing Variable Cells box. She would choose the cells containing the ____.

One of the options when assigning constraints to a Solver model is to include the ____________________ operator, which you might be tempted to include automatically when a value in your Solver model is expressed as a whole number.

Identify the letter of the choice that best matches the items in the Solver answer report above. -The constraint does not have a final value that is equal to the value of the constraint A)#1 B)#2 C)#3 D)#4 E)#5 F)#6

The ____________________ function sums a series of products in ranges of identical sizes, called arrays, which are parallel to each other in a worksheet.

With Solver, you can change the values in many cells at one time to reach a goal in the ____________________ cell.

Having a cell in the worksheet that contains the constraint value makes it possible for you to refer to each constraint value as a cell reference in the ____ dialog box.

The ____ section of the answer report includes the objective cell reference and name, the original value in the cell, and the final value in the cell.

When you use Goal Seek, you are limited to entering values in a single cell to reach a goal in another related cell. This related cell is known as the ____ in Solver.

Sometimes, you might need to save several Solver models in a worksheet to track your progress in solving a specific problem. Without ____, it might be difficult to determine which saved Solver model appears in the different ranges.

In the Solver answer report, when the status is ____, the slack column indicates the difference between the final value and the constraint.