Question 1

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 2

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 word from the Purchasing Department that there could be some variance in the COGS. He wants to develop a worksheet that shows the effects of various interactions between the selling price and the cost of goods sold per unit on profitability. In the two-variable data table, how would he set it up?

Accepted Answer

A)  Place COGS and selling price next to each other in a column, and the table's output formula for income in the third column. 
B)  Place COGS and selling price perpendicular to each other, and the table's output formula for income in the intersection of these two sets of input variables. 
C)  Place income and selling price perpendicular to each other, and the table's output formula for COGS in the intersection of these two sets of input variables. 
D)  Place COGS and selling price in two subsequent rows, with the table's output formula for income in the third row. 
A)  Place COGS and selling price next to each other in a column, and the table's output formula for income in the third column. 
B)  Place COGS and selling price perpendicular to each other, and the table's output formula for income in the intersection of these two sets of input variables. 
C)  Place income and selling price perpendicular to each other, and the table's output formula for COGS in the intersection of these two sets of input variables. 
D)  Place COGS and selling price in two subsequent rows, with the table's output formula for income in the third row.

Question 3

To create a(n) scenario, you plan the input data you want to use and the results, or output, you want to achieve. _________________________

Accepted Answer

A) True 
 B)False

Question 4

Although a PivotTable usually summarizes information into different categories using functions such as ____, a scenario PivotTable lets you summarize the result cells from a scenario.

Accepted Answer

A)  COUNT 
B)  AVERAGE 
C)  MAX 
D)  all of the above 
A)  COUNT 
B)  AVERAGE 
C)  MAX 
D)  all of the above

Question 5

A(n) ____________________ data table has two lists of input values and one formula that refers to the two different input cells.

Accepted Answer

two-variab

Question 6

Gabriel created the table above to help him organize financial information on the projected results of increased marketing campaigns for the swimsuit line. A change in marketing expense will change the number of units sold. Please refer to the table above when answering the questions below.
-Gabriel decides that he needs to delete one of his scenarios. How does he open the Scenario Manager in order to delete the desired scenario in the Scenarios box?

Accepted Answer

A)  Click the What-If Analysis button in the Data Tools group on the SCENARIOS tab on the ribbon. 
B)  Click the Manage Scenarios button in the Data Tools group on the DATA tab on the ribbon. 
C)  Click the What-If Analysis button in the Data Tools group on the DATA tab on the ribbon. 
D)  Click the Analysis button in the Manage Scenarios group on the DATA tab on the ribbon. 
A)  Click the What-If Analysis button in the Data Tools group on the SCENARIOS tab on the ribbon. 
B)  Click the Manage Scenarios button in the Data Tools group on the DATA tab on the ribbon. 
C)  Click the What-If Analysis button in the Data Tools group on the DATA tab on the ribbon. 
D)  Click the Analysis button in the Manage Scenarios group on the DATA tab on the ribbon.

Question 7

To determine the ____ in a worksheet, ask which input assumptions you want to vary from one option to another.

Accepted Answer

A)  changing cells 
B)  result cells 
C)  variance cells 
D)  formula cells 
A)  changing cells 
B)  result cells 
C)  variance cells 
D)  formula cells

Question 8

Source cells contain values, and result cells show the results of formulas. _________________________

Accepted Answer

A) True 
 B)False

Question 9

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 10

You can use Custom number formats to display a label in a worksheet even when the cell contains a value or a formula.

Accepted Answer

A) True 
 B)False

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

To create a(n) scenario, you plan the input data you want to use and the results, or output, you want to achieve. _________________________

Although a PivotTable usually summarizes information into different categories using functions such as ____, a scenario PivotTable lets you summarize the result cells from a scenario.

A(n) ____________________ data table has two lists of input values and one formula that refers to the two different input cells.

To determine the ____ in a worksheet, ask which input assumptions you want to vary from one option to another.

Source cells contain values, and result cells show the results of formulas. _________________________

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

You can use Custom number formats to display a label in a worksheet even when the cell contains a value or a formula.

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

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

To create a(n) scenario, you plan the input data you want to use and the results, or output, you want to achieve. _________________________

Although a PivotTable usually summarizes information into different categories using functions such as ____, a scenario PivotTable lets you summarize the result cells from a scenario.

A(n) ____________________ data table has two lists of input values and one formula that refers to the two different input cells.

To determine the ____ in a worksheet, ask which input assumptions you want to vary from one option to another.

Source cells contain values, and result cells show the results of formulas. _________________________

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

You can use Custom number formats to display a label in a worksheet even when the cell contains a value or a formula.

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