Exam 9: Enhancing Decision Making with Solver

The cells in a worksheet usually display combinations of text or numbers; the math that generates the answers is ____ in the worksheet itself.

A(n) ____ problem is an optimization problem in which there is a one-to-one relationship between a resource and an assignment or a job.

You can use Solver to determine how to allocate ____, such as people, budgets, or inventories, in such a way as to achieve the greatest benefits.

The size of a truck is an example of a(n) political limit. _________________________

Creating a(n) ____ table in a worksheet organizes the constraints and makes them visible in the worksheet at any time, and without the limitation of having to open the Solver Parameters dialog box and scroll the constraints to view them.

Using the integer constraint significantly adds to the computational complexity of a Solver model.

With Solver, you can change the values of up to 500 cells at one time to reach a goal in the objective cell.

The ____ report includes detailed information about the objective cell, variable cells, and Constraints used in the Solver model.

Goal Seek lets you change multiple cells.

The ____ operators you can use in Solver are less than or equal to (<=), equal to (=), greater than or equal to (>=), integer (int), binary (bin), and different (dif).

In solving business problems, you usually need to maximize items such as revenue or profit, and minimize items such as expenses or losses. _________________________

When you plot a linear function in a chart, the result is a ____.

In a Solver model, a value of TRUE indicates a constraint that could not be satisfied. _________________________

A(n) ____ results when Solver cannot determine the combination of decision variables that satisfies all of the constraints.

Solver changes the values in the variable cells (also called ____ variables) to maximize, minimize, or set the objective cell to a specific value.

If you add a(n) ____ constraint to the variable cells, Solver will use the value 1 or 0 in the solution.

The default solving method when the Solver Parameters dialog box opens is ____.

When you cannot describe a function in linear terms, it is called a(n) ____________________ function.

To view a previously saved scenario, select it in the Scenarios box, and then click the ____ button to update the worksheet with the data saved in the scenario.

____ is similar to Goal Seek in that it lets you specify what you want to occur in a particular Cell by changing the values of one or more related cells.