Exam 10: Performing What If Analyses

The $\underline {\text { result } }$ cells are the cells containing the values you want to examine._________________________

In Solver,changing cells are sometimes referred to as _______ cells.

-Check the item marked 3 in the accompanying figure to hide the scenario in a(n)____________________ worksheet.

{=SUM(B1:B10*C1:C10)} is an example of a(n)_______.

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.

To open the Goal Seek dialog box,first click the What-If Analysis button in the Data Tools group.

$\underline {\text { Variable } }$ expenses change in proportion to the company's sales volume._________________________

CVP analysis is sometimes called $\underline { \text { breakthrough } }$ analysis._________________________

A limits report allows you to quantify the reliability of a solution produced by Solver.

-The item marked 1 in the accompanying figure indicates the profit.

-The accompanying figure is a typical _______ chart.

To set up a(n)____________________ table,you first insert references to the input and result cells.

The answer report is divided into _______ sections.

A scenario summary report's _______ layout makes it simpler to compare the results of each scenario,and the automatic formatting makes it useful for reports and meetings.

In traditional what-if analysis,you change $\underline {\text { result } }$ values in worksheet cells._________________________

All three expense types can be classified as _______.

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

The default convergence value in Solver is _______.

After trying out solutions for a short time,Solver displays the _______ dialog box,which displays the message that indicates Solver has found a solution that satisfies the constraints.

Binding constraints always show a slack of _______.