Exam 10: Performing What-If Analyses

A scenario summary report's _______ layout makes it simpler to compare the results of each scenario,and the automatic formatting makes it useful for reports and meetings.

(Multiple Choice)

4.8/5

(38)

Question 21

Before using Scenario Manager,you should assign _______ to all the input and result cells you intend to use in your scenarios.

(Multiple Choice)

4.8/5

(29)

Question 22

In traditional what-if analysis,you change result values in worksheet cells._________________________

(True/False)

4.8/5

(26)

Question 23

Binding constraints always show a slack of _______.

(Multiple Choice)

4.8/5

(37)

Question 24

What are the steps to create a one-variable data table?

(Short Answer)

4.8/5

(38)

Question 25

Identify the letter of the choice that best matches the phrase or definition. -Searches for the optimal solution of a problem involving several variables

(Multiple Choice)

4.9/5

(32)

Question 26

Variable expenses change in proportion to the company's sales volume._________________________

(True/False)

4.9/5

(29)

Question 27

Two-variable data tables are often used to explore the impact of changing two values on a single result.

(True/False)

4.7/5

(40)

Question 28

If you orient a one-variable table so that the input values are in the first row,you would use the _______ input cell option.

(Multiple Choice)

4.9/5

(37)

Question 29

Identify the letter of the choice that best matches the phrase or definition. -Changes one cell in order to force another to show a specific value

(Multiple Choice)

4.7/5

(30)

Question 30

You can include an analysis of the constraints and conditions by which Solver arrived at its solution by creating a(n)_______ report.

(Multiple Choice)

4.7/5

(33)

Question 31

The default convergence value is 0.001,which means that if the change in the value of the objective cell between the new solution and the previous solution is _______ 0.001,Solver stops the interative process and reports the current solution.

(Multiple Choice)

4.9/5

(33)

Question 32

At the break-even point,revenue equals expenses.

(True/False)

4.9/5

(36)

Question 33

A(n)mixed expense is an expense that is part variable and part fixed._________________________

(True/False)

4.7/5

(34)

Question 34

To select nonadjacent changing cells,press and hold the _______ key as you click each cell.

(Multiple Choice)

4.9/5

(38)

Question 35

The _______ report summarizes the results of a successful solution by displaying information about the target cell,changing cells,and constraints.

(Multiple Choice)

4.9/5

(42)

Question 36

The sensitivity report is most often used in science and engineering environments.

(True/False)

4.9/5

(40)

Question 37

Identify the letter of the choice that best matches the phrase or definition. -The difference between the value in a cell and the value at the limit of the constraint

(Multiple Choice)

4.9/5

(36)

Question 38

Once you enter an array formula,Excel will enclose the formula in a set of _______.

(Multiple Choice)

4.9/5

(33)

Question 39

A(n)_______ is a limit that is placed on a Solver problem's solution.

(Multiple Choice)

4.7/5

(36)

Question 40

Showing 21 - 40 of 75

A scenario summary report's _______ layout makes it simpler to compare the results of each scenario,and the automatic formatting makes it useful for reports and meetings.

Before using Scenario Manager,you should assign _______ to all the input and result cells you intend to use in your scenarios.

In traditional what-if analysis,you change result values in worksheet cells._________________________

Binding constraints always show a slack of _______.

What are the steps to create a one-variable data table?

Identify the letter of the choice that best matches the phrase or definition. -Searches for the optimal solution of a problem involving several variables

Variable expenses change in proportion to the company's sales volume._________________________

Two-variable data tables are often used to explore the impact of changing two values on a single result.

If you orient a one-variable table so that the input values are in the first row,you would use the _______ input cell option.

Identify the letter of the choice that best matches the phrase or definition. -Changes one cell in order to force another to show a specific value

You can include an analysis of the constraints and conditions by which Solver arrived at its solution by creating a(n)_______ report.

The default convergence value is 0.001,which means that if the change in the value of the objective cell between the new solution and the previous solution is _______ 0.001,Solver stops the interative process and reports the current solution.

At the break-even point,revenue equals expenses.

A(n)mixed expense is an expense that is part variable and part fixed._________________________

To select nonadjacent changing cells,press and hold the _______ key as you click each cell.

The _______ report summarizes the results of a successful solution by displaying information about the target cell,changing cells,and constraints.

The sensitivity report is most often used in science and engineering environments.

Identify the letter of the choice that best matches the phrase or definition. -The difference between the value in a cell and the value at the limit of the constraint

Once you enter an array formula,Excel will enclose the formula in a set of _______.

A(n)_______ is a limit that is placed on a Solver problem's solution.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters