Question 1

____________________ results are those that are based on realistic but not actual data.

Accepted Answer

The answer of ____________________ results are those that are based...

Question 2

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 
A) A 
B) B 
C) C 
D) D 
E) E

Question 3

When you change the values, the data table shows you how those changes affect the results of the formulas. _________________________

Accepted Answer

A) True 
 B)False

Question 4

All defined names have a(n) ____________________, which specifies the location in which the name is valid.

Accepted Answer

The answer of All defined names have a(n) ____________________, which...

Question 5

A(n) ____________________ is a set of values stored in a worksheet that describes different situations, such as worst-case, likely case, and best-case scenarios.

Accepted Answer

The answer of A(n) ____________________ is a set of values...

Question 6

A defined name can be used outside its scope if it is ____, which means if its original scope is identified in its reference.

Accepted Answer

A)  qualified 
B)  saved 
C)  archived 
D)  linked 
A)  qualified 
B)  saved 
C)  archived 
D)  linked

Question 7

In a one-variable data table, you enter possible values for the single input variable in the last row or column of the data table.

Accepted Answer

A) True 
 B)False

Question 8

Because what-if analysis usually involves many estimates and other projections, range analysis helps managers learn how tolerant the projected results are of changes in those estimates and assumptions.

Accepted Answer

A) True 
 B)False

Question 9

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.
-To conduct a sensitivity analysis, Beckham can ask: ____.

Accepted Answer

A)  How do the shareholders feel about these changes? 
B)  How would the break-even point change when the assumptions remain the same? 
C)  How many units must the company sell to break even? 
D)  How would the break-even point change if an estimate about one or more other assumptions changes? 
A)  How do the shareholders feel about these changes? 
B)  How would the break-even point change when the assumptions remain the same? 
C)  How many units must the company sell to break even? 
D)  How would the break-even point change if an estimate about one or more other assumptions changes?

Question 10

You can use the Scenario Manager dialog box to change a scenario's ____.

Accepted Answer

A)  values 
B)  defined names for cells 
C)  defined names for ranges 
D)  all of the above 
A)  values 
B)  defined names for cells 
C)  defined names for ranges 
D)  all of the above

Question 11

A ____ extracts, organizes, and summarizes data so you can analyze it by making comparisons, detecting patterns and relationships, and recognizing trends.

Accepted Answer

A)  PivotTable 
B)  PivotData 
C)  PivotSummary 
D)  PivotFile 
A)  PivotTable 
B)  PivotData 
C)  PivotSummary 
D)  PivotFile

Question 12

A data table depends on values and formulas used in a worksheet, and must appear ____ that contains this data.

Accepted Answer

A)  on the same worksheet 
B)  in the same file 
C)  in the same table 
D)  in the same row 
A)  on the same worksheet 
B)  in the same file 
C)  in the same table 
D)  in the same row

Question 13

A range name, also called a(n) ____________________ name, can refer to a cell, range of cells, formula, or constant value in Excel.

Accepted Answer

The answer of A range name, also called a(n) ____________________...

Question 14

Changing cells and result cells are listed by the names you gave them when you ____.

Accepted Answer

A)  created the scenarios 
B)  ran a report 
C)  saved the file 
D)  none of the above 
A)  created the scenarios 
B)  ran a report 
C)  saved the file 
D)  none of the above

Question 15

To create a two-variable data table, you must first set up a data source file.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

You use the ____ 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)  Scenario Manager 
B)  Scenario Wizard 
C)  Values Manager 
D)  Values Wizard 
A)  Scenario Manager 
B)  Scenario Wizard 
C)  Values Manager 
D)  Values Wizard

Question 18

To open the Data Table dialog box, click the DATA tab on the ribbon, click the ____ Analysis button in the Data Tools group, and then click the Data Table command.

Accepted Answer

A)  What-If 
B)  Sensitivity 
C)  Data 
D)  Data Table 
A)  What-If 
B)  Sensitivity 
C)  Data 
D)  Data Table

Question 19

You can use the Scenario Manager to create two types of scenario reports: a scenario summary and a scenario ____.

Accepted Answer

A)  Flow Chart 
B)  PivotTable 
C)  Workbook 
D)  Data Chart 
A)  Flow Chart 
B)  PivotTable 
C)  Workbook 
D)  Data Chart

Question 20

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

Accepted Answer

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

____________________ results are those that are based on realistic but not actual data.

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

When you change the values, the data table shows you how those changes affect the results of the formulas. _________________________

All defined names have a(n) ____________________, which specifies the location in which the name is valid.

A(n) ____________________ is a set of values stored in a worksheet that describes different situations, such as worst-case, likely case, and best-case scenarios.

A defined name can be used outside its scope if it is ____, which means if its original scope is identified in its reference.

In a one-variable data table, you enter possible values for the single input variable in the last row or column of the data table.

Because what-if analysis usually involves many estimates and other projections, range analysis helps managers learn how tolerant the projected results are of changes in those estimates and assumptions.

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. -To conduct a sensitivity analysis, Beckham can ask: ____.

You can use the Scenario Manager dialog box to change a scenario's ____.

A ____ extracts, organizes, and summarizes data so you can analyze it by making comparisons, detecting patterns and relationships, and recognizing trends.

A data table depends on values and formulas used in a worksheet, and must appear ____ that contains this data.

A range name, also called a(n) ____________________ name, can refer to a cell, range of cells, formula, or constant value in Excel.

Changing cells and result cells are listed by the names you gave them when you ____.

To create a two-variable data table, you must first set up a data source file.

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

You use the ____ to define and save sets of values as scenarios, and then you view and change them as necessary to produce and compare different results.

To open the Data Table dialog box, click the DATA tab on the ribbon, click the ____ Analysis button in the Data Tools group, and then click the Data Table command.

You can use the Scenario Manager to create two types of scenario reports: a scenario summary and a scenario ____.

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

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

____________________ results are those that are based on realistic but not actual data.

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

When you change the values, the data table shows you how those changes affect the results of the formulas. _________________________

All defined names have a(n) ____________________, which specifies the location in which the name is valid.

A(n) ____________________ is a set of values stored in a worksheet that describes different situations, such as worst-case, likely case, and best-case scenarios.

A defined name can be used outside its scope if it is ____, which means if its original scope is identified in its reference.

In a one-variable data table, you enter possible values for the single input variable in the last row or column of the data table.

Because what-if analysis usually involves many estimates and other projections, range analysis helps managers learn how tolerant the projected results are of changes in those estimates and assumptions.

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. -To conduct a sensitivity analysis, Beckham can ask: ____.

You can use the Scenario Manager dialog box to change a scenario's ____.

A ____ extracts, organizes, and summarizes data so you can analyze it by making comparisons, detecting patterns and relationships, and recognizing trends.

A data table depends on values and formulas used in a worksheet, and must appear ____ that contains this data.

A range name, also called a(n) ____________________ name, can refer to a cell, range of cells, formula, or constant value in Excel.

Changing cells and result cells are listed by the names you gave them when you ____.

To create a two-variable data table, you must first set up a data source file.

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

You use the ____ to define and save sets of values as scenarios, and then you view and change them as necessary to produce and compare different results.

To open the Data Table dialog box, click the DATA tab on the ribbon, click the ____ Analysis button in the Data Tools group, and then click the Data Table command.

You can use the Scenario Manager to create two types of scenario reports: a scenario summary and a scenario ____.

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

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