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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) rules based on Generally Accepted Accounting Principles (GAAP)
B) tax-basis rules
C) either a or b
D) neither a nor b

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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

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

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

Data tables help you answer questions such as: ____.

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

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

Defined names can be deleted or edited in the ____ dialog box.

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.

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

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

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.

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

You use the ____ to add a scenario.

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

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

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

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