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

____________________ analysis is a type of what-if analysis that concentrates on an activity at or around the point at which a product breaks even.

Using ____ can make the process of creating scenarios and using them easier.

Although Excel does not consider case when evaluating cell names, the use of case differences in cell names can make them ____.

To specify which input cell in the worksheet relates to the values in the data table, open the ____ dialog box.

What is a scenario and how is it used? What are the correct terms for a scenario's input and output cells?

You can use the Scenario Manager to create two types of scenario reports: a scenario summary and a scenario ____.

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

In a one-variable data table, you enter possible values for the single input variable in the last row or column of the data table.

When applying names to cells and ranges, to indicate the start and end of words, the textbook recommends ____.

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 ____.

What-if analysis allows you to see what output results if the values of various input assumptions change.

To conduct a ____ analysis, you can ask, "How would the break-even point and profitability estimates change if an estimate about one or more other assumptions changes?"

Creating the structure for a data table involves creating the set of ____ you want to use in your what-if analysis, and then indicating the results you want to see in the data table.

In a two-variable data table, you use two sets of values for two input variables, and display only the value of a single result cell.

The VLOOKUP function compares a lookup value to the first column of a lookup table, and returns the corresponding value in ____ column of the lookup table.

As with one-variable data tables, you must specify how a two-variable data table is structured and which cells in the worksheet's input section relate to the table's ____.

As one of the final steps of creating a scenario, you create the scenario by naming it and then entering ____ into the Scenario Manager.

Because what-if analysis usually involves many estimates and other projections, range analysis helps managers learn how tolerant the projected results are of changes in those estimates and assumptions.

A scenario can span worksheets.

Break-even analysis is a type of what-if analysis that concentrates on an activity at or around the point at which a product breaks even-or where the ____ is $0.