Exam 10: Performing What If Analyses

-The items marked 1 in the accompanying figure are the $\underline { \text { result } }$ cells._________________________

____________________ expenses change in proportion to the amount of business a company does.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cannot be used when a problem contains integer constraints

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Changes one cell in order to force another to show a specific value

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The difference between the value in a cell and the value at the limit of the constraint

A(n) $\underline { \text { optimal } }$ cell is a cell that Excel changes to produce the desired result in the target cell._________________________

As you begin to work with Solver, you have questions. So you turn to your co-worker, Aria, who you know is an expert in its usage. -Aria explains that if you have a cell that is the sales price of a given product,the value of which will change to produce the desired Solver result in the target cell,this cell is what kind of cell?

The default convergence value is 0.001,which means that if the change in the value of the objective cell between the new solution and the previous solution is _______ 0.001,Solver stops the interative process and reports the current solution.

To perform a what-if analysis with more than two input cells,you _______.

You can include an analysis of the constraints and conditions by which Solver arrived at its solution by creating a(n)_______ report.

_______ analysis is an important business decision-making tool because it predicts the effect of cutting overhead or raising prices on net income.

In your company,there is a physical limit on the number of products that the factories can produce in a given year.What does Aria tell you this limit is called,in Solver's terms?

You cannot merge scenarios in situations involving multiple workbooks.

_______ are important because they ensure a realistic solution to your problem.

_______ is a program that searches for the optimal solution of a problem involving several variables.

How many different types of reports can Solver create? What are the characteristics of these report types,and which is the most useful?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Places limits on a problem's solution,in Solver

The sensitivity report is most often used in science and engineering environments.

-The item marked 2 in the accompanying figure is the scenario ____________________.

Solver can create the following three different reports: _______.