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

Scenario names can contain up to 255 characters, including spaces. However, only the first ____ characters of the scenario name appear in the Scenario Manager list.

Each ____ in a scenario must be unique within its scope.

To compare scenarios, you can create a summary report that lists the scenarios side by side or in a PivotScenario.

Scenarios are best created using sets of ____________________ value assumptions, such as best-case, likely case, and worst-case outcomes.

Defined names can be deleted or edited in the ____ 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 ____.

Scenario reports can include data from only the first ____ scenarios.

The breaking point is the point at which revenue equals expenses. _________________________

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

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

Use a(n) ____ data table to see how two factors-for example, different interest rates and loan terms-affect a loan payment.

You use the ____ to add a scenario.

You can use the Scenario Manager to perform a what-if analysis with ____ input cell(s).

When using data tables to run a simulation, it is usually best to base your analysis on ____.

The ____________________ Manager allows you to consolidate multiple what-if models in one worksheet.

If a company decides to use income tax expense as a factor in analyses, a method it could use to compute the effects is ____.

You use the Simulation Manager to define and save sets of values as scenarios, and then you view and change them as necessary to produce and compare different results. _________________________

A(n) ____________________ data table has only one input cell and many result cells.

Data tables help you answer questions such as: ____.

Defined names with a global scope can be created for cells and ranges using the Name box in the Formula Bar, and using the ____ command in the Defined Names group on the FORMULAS tab.