Exam 10: Performing What-If Analyses

Before using Scenario Manager,you should assign ____ to all the input and result cells you intend to use in your scenarios.

With ____________________,you specify the result values you want,and Excel changes the input values to produce them.

The output cell is the cell containing the values you want to examine._________________________

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

Solver is an add-in,a program that adds customized commands and features to Microsoft Office programs such as Excel.

Aside from Solver,other Excel ____ provide the ability to perform statistical analyses,generate business reports,and retrieve financial data from the Internet.

At the break-even point,revenue equals expenses.

An array argument performs multiple calculations on one or more sets of values and then returns either a single value or multiple values._________________________

The default convergence value in Solver is ____.

-Click the Scenario PivotTable ____________________ option button to create a PivotTable describing the scenarios.

-The item in the accompanying figure is a(n)____ chart.

If a value in the worksheet violates one of the constraints,the Solver parameter cells will display the value ____.

The ____ report is used primarily when the user wants to investigate the mathematical aspects of the Solver solution.

To activate Solver,click Solver Add-In in the ____.

The slack is the difference between the value in the cell and the value at the limit of the ____.

Case-Based Critical Thinking Questions Case 10-2 As you begin to work with Solver,you have questions so you turn to your roommate,Barat,who you know is an expert in its usage. -Barat explains to you that if you want to use Solver to maximize a company's net income,this cell is what kind of cell?

In two-variable tables,you must always place a reference to the result cell in the ____ corner of the table at the intersection of the row values and the column values.

In measuring elasticity,if e=2.0,then increasing the price of an object by ____ decreases demand by 20%.

Using Solver,you specify the target cell,variable cells,and constraints on a problem.

If you orient a one-variable table so that the input values are in the first row,you would use the ____ input cell option.