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

You can use Custom number formats to display a label in a worksheet even when the cell contains a value or a formula.

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.

To set up a scenario, you create or use a worksheet that contains sets of input and output cells, as you do with data tables. For example, in a worksheet listing sales assumptions and projections, the projections are ____.

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.

Data tables help you answer questions such as: ____.

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

As with data tables, Excel allows you to run scenarios only on worksheets that have well-structured input and output sections, with the output section depending on the input section through the use of ____.

To determine the ____ in a worksheet, ask which input assumptions you want to vary from one option to another.

____ results are those that are based on realistic but not actual data.

____________________ is a process of changing values to see how those changes affect the outcome of formulas in an Excel worksheet.

A(n) ____________________ relationship means that the cost does not vary directly with the number of units, but varies as the units reach steps of quantities.

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.

When using a two-variable data table to run a simulation, one set of input values in the data table's structure must be a sequence of numbers that represents the ____.

Defined names with a local or global scope can be created using the Define Name command in the Defined Names group on the ____ tab on the ribbon.

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

The Scenario Manager refers to output cells as ____________________ cells.

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

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

You can use two-variable data tables to base a what-if analysis on realistic, but not actual, data. Doing so is called running a(n) situation. _________________________

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