Exam 8: Using Data Tables and Excel Scenarios for What-If Analysis

Excel can be used to create two types of data tables: one-variable data tables and ____ data tables.

Scenario summary reports are created with ____ as the worksheet title.

In a two-variable data table, you can vary the values of two input variables, and show the results for ____ output value(s).

Identify the letter of the choice that best matches the word or phrase with its definition. -A multiple-output formula that shows the results that come from one set of input values

A ____ analysis asks, "How much will projected profits change if the cost of goods sold per unit changes by $1? By $2?"

Gabriel created the table above to help him organize financial information on the projected results of increased marketing campaigns for the swimsuit line. A change in marketing expense will change the number of units sold. Please refer to the table above when answering the questions below. -Gabriel plans to use the Scenario Manager to add a scenario. He opens the Scenario Manager by clicking the DATA tab on the ribbon, and then clicking the ____.

You can use the Scenario ____________________ to perform a what-if analysis with more than two input cells.

A(n) source table is a range of cells containing values and formulas. _________________________

Beckham created the worksheets above to show the profitability and break-even points for his company. Please refer to the figure above as you answer the questions below. -Beckham has received new information regarding some of the assumptions. The estimate of the COGS per unit has changed from $75.75 to $95.00, and the estimated marketing expense has been cut from $75,000 to $60,000. What should Beckham do to show this change in the worksheet above?

A contribution margin is calculated by subtracting variable expenses from sales, and represents the amount of revenue that contributes to covering the ____ expenses of a company.

There is no right answer to the question of whether the effect of income taxes should be considered when performing what-if analysis.

The ____________________ function is very useful when you want to sum a series of products, as long as the ranges involved are parallel to each other in the worksheet.

MATCHING Identify the letter of the choice that best matches the break-even point in the chart above. -Loss

A ____ extracts, organizes, and summarizes data so you can analyze it by making comparisons, detecting patterns and relationships, and recognizing trends.

Identify the letter of the choice that best matches the word or phrase with its definition. -Data table cells containing values that can vary

Gabriel created the table above to help him organize financial information on the projected results of increased marketing campaigns for the swimsuit line. A change in marketing expense will change the number of units sold. Please refer to the table above when answering the questions below. -Gabriel needs to create five scenarios in the Swimwear worksheet. To do so, he needs to determine the changing cells in the worksheet. Which input values change under the various options, and what will the changing cells be in his scenarios?

Although you can use generic names for your scenarios, you should use more descriptive names because they appear on any scenario summary reports you ____.

Open the Scenario Manager by clicking the DATA tab on the ribbon, clicking the ____ analysis button in the Data Tools group, and then clicking Scenario Manager.

Both one-variable data tables and two-variable data tables have ____________________ cells, which are the cells containing values that can vary.

Changing cells and result cells are listed by the names you gave them when you ____.