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

Identify the letter of the choice that best matches the word or phrase with its definition.
-A range of cells containing values and formulas

Accepted Answer

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

Question 3

When applying names to cells and ranges, to indicate the start and end of words, the textbook recommends ____.

Accepted Answer

A)  using a mix of uppercase and lowercase letters 
B)  including underscore ( _ ) characters 
C)  including a period ( . ) character 
D)  all of the above 
A)  using a mix of uppercase and lowercase letters 
B)  including underscore ( _ ) characters 
C)  including a period ( . ) character 
D)  all of the above

Question 4

The ____________________ function is very useful when you want to sum a series of products, as long as the ranges involved are parallel to each other in the worksheet.

Accepted Answer

The answer of The ____________________ function is very useful when...

Question 5

Rough analysis is a type of what-if analysis that attempts to examine how sensitive the results of an analysis are to changes in the assumptions. _________________________

Accepted Answer

A) True 
 B)False

Question 6

Case 8-1
   
Beckham created the worksheets above to show the profitability and break-even points for his company. Please refer to the figure above as you answer the questions below.
-Beckham has received new information regarding some of the assumptions. The estimate of the COGS per unit has changed from $75.75 to $95.00, and the estimated marketing expense has been cut from $75,000 to $60,000. What should Beckham do to show this change in the worksheet above?

Accepted Answer

A)  Calculate the changes manually to ensure the integrity of the data table. 
B)  Change the worksheet to a two-variable data table. 
C)  Change those items in the Assumptions section of the worksheet, and Excel will recalculate the data table. 
D)  none of the above 
A)  Calculate the changes manually to ensure the integrity of the data table. 
B)  Change the worksheet to a two-variable data table. 
C)  Change those items in the Assumptions section of the worksheet, and Excel will recalculate the data table. 
D)  none of the above

Question 7

A two-variable data table has two input cells and ____ result cell(s).

Accepted Answer

A)  one 
B)  two 
C)  variable 
D)  random 
A)  one 
B)  two 
C)  variable 
D)  random

Question 8

To view a scenario in the worksheet, click the scenario name in the Scenario Manager dialog box, and then click the ____ button.

Accepted Answer

A)  Open 
B)  Show 
C)  Display 
D)  View 
A)  Open 
B)  Show 
C)  Display 
D)  View

Question 9

As one of the final steps of creating a scenario, you create the scenario by naming it and then entering ____ into the Scenario Manager.

Accepted Answer

A)  data 
B)  file names 
C)  worksheet names 
D)  formulas 
A)  data 
B)  file names 
C)  worksheet names 
D)  formulas

Question 10

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

Accepted Answer

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

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

Identify the letter of the choice that best matches the word or phrase with its definition. -A range of cells containing values and formulas

When applying names to cells and ranges, to indicate the start and end of words, the textbook recommends ____.

The ____________________ function is very useful when you want to sum a series of products, as long as the ranges involved are parallel to each other in the worksheet.

Rough analysis is a type of what-if analysis that attempts to examine how sensitive the results of an analysis are to changes in the assumptions. _________________________

A two-variable data table has two input cells and ____ result cell(s).

To view a scenario in the worksheet, click the scenario name in the Scenario Manager dialog box, and then click the ____ button.

As one of the final steps of creating a scenario, you create the scenario by naming it and then entering ____ into the Scenario Manager.

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

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters

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

Identify the letter of the choice that best matches the word or phrase with its definition. -A range of cells containing values and formulas

When applying names to cells and ranges, to indicate the start and end of words, the textbook recommends ____.

The ____________________ function is very useful when you want to sum a series of products, as long as the ranges involved are parallel to each other in the worksheet.

Rough analysis is a type of what-if analysis that attempts to examine how sensitive the results of an analysis are to changes in the assumptions. _________________________

A two-variable data table has two input cells and ____ result cell(s).

To view a scenario in the worksheet, click the scenario name in the Scenario Manager dialog box, and then click the ____ button.

As one of the final steps of creating a scenario, you create the scenario by naming it and then entering ____ into the Scenario Manager.

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

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters