Exam 10: Performing What If Analyses

The ____________________ is the difference between the value in a cell and the value at the limit of the constraint.

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

How does Goal Seek differ from traditional what-if analysis? Creating a One-Variable Data Table 1.In the upper-left cell of the table,enter a formula that references the input cell. 2.In either the first row or the first column of the table,enter input values. 3.For input values in the first row,enter formulas referencing result cells in the table's first column;for input values in the first column,enter formulas referencing result cells in the table's first row. 4.Select the table (excluding any row or column headings). 5.On the DATA tab,in the Data Tools group,click the What-If Analysis button,and then click Data Table. 6.If the input values are in the first row,enter the cell reference to the input cell in the Row input cell box;if the input values are in the first column,enter the cell reference to the input cell in the Column input cell box. 7.Click the OK button

You are planning to open a new restaurant and need to determine how many dinners need to be sold to stay above the break-even point. You will investigate Cost Volume Profit (CVP), also known as break-even analysis. -The data table provides the results of several what-if analyses,but results are often clearer if you include a(n)_______ chart.

Which of the following expense types can be used in a CVP analysis?

You can switch from one scenario to another by clicking the _______ button in the Scenario Manager dialog box.

You are planning to open a new restaurant and need to determine how many dinners need to be sold to stay above the break-even point. You will investigate Cost Volume Profit (CVP), also known as break-even analysis. -When creating a one-variable Data Table,which of the following should you NOT do?

A(n)____________________ is a customized program that adds commands and features to Microsoft Office programs.

To select nonadjacent changing cells,press and hold the _______ key as you click each cell.

A business must pay insurance and rent;these are examples of _______ expenses.

What are the steps to create a one-variable data table?

_______ analysis expresses the relationship between a company's expenses,its volume of business,and the resulting profit.

You are planning to open a new restaurant and need to determine how many dinners need to be sold to stay above the break-even point. You will investigate Cost Volume Profit (CVP), also known as break-even analysis. -In building an Income statement worksheet,you will calculate variable and fixed expenses based on number of meals sold.To explore the impact of changing different values in the worksheet,you can use _______.

____________________ cells are cells containing values you want to modify in what-if analysis cells.

As in traditional what-if analysis,Goal Seek starts with the end result and determines what value you should use to reach a desired answer.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Summarizes the results of a successful Solver solution

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

A(n)____________________ expense is an expense that must be paid regardless of sales volume.

-The items marked 1 in the accompanying figure are _______ cells.