FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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) ScenarioChart
B) PivotChart
C) Data Chart
D) Data File

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

Although you can use generic names for your scenarios, you should use more descriptive names because they appear on any scenario summary reports 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.

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

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

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

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.

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

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-if analysis allows you to see what output results if the values of various input assumptions change.

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

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

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

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

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

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.

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

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.