Question 1

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

Accepted Answer

A)   the raw data
B)   statistics about the data
C)   the number of iterations of the simulation
D)   the number of output cells

Question 2

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

Accepted Answer

A)   number of iterations of the simulation
B)   dates the file was saved
C)   number of input cells
D)   number of output cells

Question 3

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

Accepted Answer

A)  A
B)  B
C)  C
D)  D
E)  E

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

A)   defined name
B)   refined name
C)   comment
D)   data label A

Question 7

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.

Accepted Answer

A)   15
B)   25
C)   35
D)   45 C

Question 8

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

Accepted Answer

The answer of Scenarios are best created using sets of...

Question 9

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

Accepted Answer

A)   one-variable
B)   two-variable
C)   multi-variable
D)   output

Question 10

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

Accepted Answer

The answer of The ____________________ Manager allows you to consolidate...

Question 11

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

Accepted Answer

A)   Name Manager
B)   Name
C)   Manager
D)   Defined Names

Question 12

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

Accepted Answer

A) True 
 B)False  False

Question 13

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

Accepted Answer

A)  A
B)  B
C)  C
D)  D
E)  E

Question 14

Data tables help you answer questions such as: ____.

Accepted Answer

A)   If I change the unit price, how does that affect gross profit?
B)   If I vary the unit price and the cost of goods sold, how does that affect income before taxes?
C)   both a and b
D)   neither a nor b

Question 15

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

Accepted Answer

A)   32
B)   151
C)   251
D)   351

Question 16

You use the ____ to add a scenario.

Accepted Answer

A)   Scenario Wizard
B)   Scenario Manager
C)   Case Manager
D)   Data Table Manager

Question 17

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.

Accepted Answer

A)   Create from Formula
B)   Create from Selection
C)   Create from Cell
D)   Create from Range

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)   at most one
B)   at most two
C)   only one or two
D)   more than two

Question 20

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

Accepted Answer

one-variab...

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

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.

Correct AnswerverifiedC

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

Data tables help you answer questions such as: ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You use the ____ to add a scenario.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answerverifiedone-variab...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
one-variab...
View Answer