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 31

Multiple Choice

Review LaterAdd Note

Review Later

Identify the letter of the choice that best matches the word or phrase with its definition. -A one-output formula that shows the results of the interaction of two different sets of input values

A) changing cells
B) result cells
C) one-variable data table
D) data table
E) input cells
F) two-variable data table
G) range name

H) A) and E)
I) C) and F)

Correct Answer

verified

Show Answer

Question 32

Essay

Review LaterAdd Note

Review Later

What are what-if analysis, break-even analysis, and sensitivity analysis? Please include an example of a situation using each type of analysis (one example each).

Correct Answer

verified

•What-if analysis is a process of changi...

View Answer

Show Answer

Question 33

Short Answer

Review LaterAdd Note

A(n) ____________________ margin is calculated by subtracting variable expenses from sales, and represents the amount of revenue that contributes to covering the fixed expenses of a company.

Identify the letter of the choice that best matches the word or phrase with its definition. -Contain formulas that involve the input cells in their calculations

Identify the letter of the choice that best matches the word or phrase with its definition. -The Scenario Manager's version of input cells

You must structure a two-variable data table so that the input values are perpendicular to each other, and so that the table's output formula is located ____ the two sets of input variables.

Because a PivotTable is interactive, you can change the view of the data to see more or fewer details.

In financial statistics, a probability distribution assigns a probability to every ____.

When you have many input assumptions that will vary in each scenario, it is sometimes easier to identify the cells in the input section that will not change in the scenarios, thereby determining the scenarios' changing cells through a process of elimination.

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

Data tables allow you to organize and present the results of only one what-if analysis.

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

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

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.

A(n) PivotChart report is an interactive table that groups and summarizes information in a concise format so you can easily analyze the information. _________________________

A one-variable data table allows you to compare results calculated from changes to ____ input value(s) .

Technically, the number of scenarios you can create is limited only by your computer's memory, but scenario reports can include data from only the first 15 scenarios.

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

Open the Scenario Manager by clicking the DATA tab on the ribbon, clicking the ____ analysis button in the Data Tools group, and then clicking Scenario Manager.

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