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

Technically, the number of scenarios you can create is limited only by your computer's memory, but scenario reports can include data from only the first 15 scenarios.

When you create a scenario summary report, Excel generates it as a ____ in the workbook.

Excel allows up to ____ changing cells in each scenario.

A ____ is running a what-if analysis on realistic but not actual data.

Both one-variable data tables and two-variable data tables have ____________________ cells, which contain formulas that involve the input cells in their calculations in some way.

What are what-if analysis, break-even analysis, and sensitivity analysis? Please include an example of a situation using each type of analysis (one example each).

To make the scenario summary easy to interpret and distribute, Excel ____.

A one-variable data table allows only one input assumption to vary.

Although data tables and scenarios are ideal for showing the results of the interaction of a number of variables, analyzing which results are more likely than others depends on your knowledge of your business and markets.

Instead of listing all the cells, a scenario summary report shows the values for all ____ cells and for all indicated result cells for all scenarios.

You set up and print both types of scenario reports from the Scenario Manager dialog box by clicking the ____ button to open the Scenario Summary dialog box.

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 wants to edit his scenario. He can change everything below EXCEPT ____.

You use a ____ when you want to ask a what-if question involving a range of values.

A one-variable data table allows you to compare results calculated from changes to ____ input value(s).

In preparation for executing the command to complete the data table, first select the ____ that will constitute the completed data table.

A(n) ____________________ table is a range of cells containing values and formulas that let you perform many calculations at once, and then compare the results of these variations on a single worksheet.

You must structure a two-variable data table so that the input values are perpendicular to each other, and so that the table's output formula is located ____ the two sets of input variables.

A(n) ____________________ margin is calculated by subtracting variable expenses from sales, and represents the amount of revenue that contributes to covering the fixed expenses of a company.

A data table depends on values and formulas used in a worksheet, and must appear ____ that contains this data.

After you create a PivotTable report, you can analyze the information in a different form by generating an associated ____, which contains the same elements as a regular Excel chart.