Question 1

The textbook recommends using defined names that are fairly ____ and meaningful.

Accepted Answer

A)  short 
B)  long 
C)  unusual 
D)  common 
A)  short 
B)  long 
C)  unusual 
D)  common

Question 2

Use a(n) ____ data table to see how different interest rates affect a loan payment.

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Before you start creating scenarios, you can name the ____ cells you plan to use in the scenario.

Accepted Answer

A)  input 
B)  result 
C)  both a and b 
D)  neither a nor b 
A)  input 
B)  result 
C)  both a and b 
D)  neither a nor b

Question 5

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Question 8

____________________ is a process of changing values to see how those changes affect the outcome of formulas in an Excel worksheet.

Accepted Answer

What-if an

Question 9

A(n) ____________________ relationship means that the cost does not vary directly with the number of units, but varies as the units reach steps of quantities.

Accepted Answer

step-varia

Question 10

Creating a data table in Excel involves the very important step(s) of ____.

Accepted Answer

A)  setting up the structure for the data table 
B)  instructing Excel on how the data table's structure relates to the input section of the worksheet 
C)  both a and b 
D)  neither a nor b 
A)  setting up the structure for the data table 
B)  instructing Excel on how the data table's structure relates to the input section of the worksheet 
C)  both a and b 
D)  neither a nor b

Question 11

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's boss has asked him to be more precise about how many units the company will need to sell to break even. What can Beckham do to get this information?

Accepted Answer

A)  Create a larger data table with smaller increments in specifying units sold. 
B)  Create a larger data table with larger increments in specifying units sold. 
C)  Change the input variable to sales revenue. 
D)  Change the input variable to income. 
A)  Create a larger data table with smaller increments in specifying units sold. 
B)  Create a larger data table with larger increments in specifying units sold. 
C)  Change the input variable to sales revenue. 
D)  Change the input variable to income.

Question 12

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 13

Cells that contain formulas should be specified as changing cells in scenarios.

Accepted Answer

A) True 
 B)False

Question 14

You can omit taxes from your estimates, or use your marginal tax rate.

Accepted Answer

A) True 
 B)False

Question 15

You use data tables when you want to conduct a what-if analysis involving one or two input cells. _________________________

Accepted Answer

A) True 
 B)False

Question 16

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.

Accepted Answer

A) True 
 B)False

Question 17

After you create a scenario, you can use the Scenario Manager ____ to change its values to extend your what-if analysis.

Accepted Answer

A)  dialog box 
B)  toolbar 
C)  status bar 
D)  Wizard 
A)  dialog box 
B)  toolbar 
C)  status bar 
D)  Wizard

Question 18

____ margins are widely used in analysis, especially when evaluating the profitability of sales alternatives and performing break-even analysis.

Accepted Answer

A)  Lookup 
B)  Contribution 
C)  Data 
D)  Source 
A)  Lookup 
B)  Contribution 
C)  Data 
D)  Source

Question 19

Many companies decide to use the company's ____ tax rate in their what-if analysis.

Accepted Answer

A)  marginal 
B)  projected 
C)  relative 
D)  absolute 
A)  marginal 
B)  projected 
C)  relative 
D)  absolute

Question 20

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

The textbook recommends using defined names that are fairly ____ and meaningful.

Use a(n) ____ data table to see how different interest rates affect a loan payment.

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

Before you start creating scenarios, you can name the ____ cells you plan to use in the scenario.

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

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

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

____________________ is a process of changing values to see how those changes affect the outcome of formulas in an Excel worksheet.

A(n) ____________________ relationship means that the cost does not vary directly with the number of units, but varies as the units reach steps of quantities.

Creating a data table in Excel involves the very important step(s) of ____.

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.

Cells that contain formulas should be specified as changing cells in scenarios.

You can omit taxes from your estimates, or use your marginal tax rate.

You use data tables when you want to conduct a what-if analysis involving one or two input cells. _________________________

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.

After you create a scenario, you can use the Scenario Manager ____ to change its values to extend your what-if analysis.

____ margins are widely used in analysis, especially when evaluating the profitability of sales alternatives and performing break-even analysis.

Many companies decide to use the company's ____ tax rate in their what-if analysis.

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

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

The textbook recommends using defined names that are fairly ____ and meaningful.

Use a(n) ____ data table to see how different interest rates affect a loan payment.

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

Before you start creating scenarios, you can name the ____ cells you plan to use in the scenario.

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

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

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

____________________ is a process of changing values to see how those changes affect the outcome of formulas in an Excel worksheet.

A(n) ____________________ relationship means that the cost does not vary directly with the number of units, but varies as the units reach steps of quantities.

Creating a data table in Excel involves the very important step(s) of ____.

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.

Cells that contain formulas should be specified as changing cells in scenarios.

You can omit taxes from your estimates, or use your marginal tax rate.

You use data tables when you want to conduct a what-if analysis involving one or two input cells. _________________________

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.

After you create a scenario, you can use the Scenario Manager ____ to change its values to extend your what-if analysis.

____ margins are widely used in analysis, especially when evaluating the profitability of sales alternatives and performing break-even analysis.

Many companies decide to use the company's ____ tax rate in their what-if analysis.

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

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