FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Enhancing Decision Making with Solver

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

A) specific value
B) worksheet name
C) range name
D) option name

E) B) and C)
F) All of the above

Correct Answer

verified

A

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) bounded
B) unbounded
C) targeted
D) untargeted

E) A) and D)
F) A) and C)

Correct Answer

verified

B

Question 3

Short Answer

Review LaterAdd Note

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

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.

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.

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

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.

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

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

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

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.

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

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

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

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

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

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.

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

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

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.