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

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.

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

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

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

If a business problem involved three break-even analyses, you could create ____ data table(s) by varying the unit price and sales projection values, but that would involve generating and printing each data table to compare the analyses.

To create a(n) scenario, you plan the input data you want to use and the results, or output, you want to achieve. _________________________

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

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

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.

A defined name can have a scope for the entire workbook, which is referred to as the ____________________ level.

Although a PivotTable usually summarizes information into different categories using functions such as ____, a scenario PivotTable lets you summarize the result cells from a scenario.

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

Data tables can be used to give you ____.

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.

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.

The contribution margin represents the amount of revenue that can contribute to covering the fixed expenses of a company. _________________________

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

Because you can compare the results of many calculations in data tables, they can be very useful when performing a ____ analysis.

You can omit taxes from your estimates, or use your marginal tax rate.

To set up a scenario, you create or use a worksheet that contains sets of input cells and no output cells.