Question 1

All three expense types can be classified as _______.

Accepted Answer

A)  mixed, fixed, and CVP 
B)  variable, fixed, and mixed 
C)  asset-based, fixed, and mixed 
D)  variable, fixed, and cost-based 
A)  mixed, fixed, and CVP 
B)  variable, fixed, and mixed 
C)  asset-based, fixed, and mixed 
D)  variable, fixed, and cost-based B

Question 2

Identify the letter of the choice that best matches the phrase or definition.
-Cells whose values you will change within each scenario

Accepted Answer

A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result 
A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result B

Question 3

Case 10-2
As you begin to work with Solver,you have questions.So you turn to your co-worker,Aria,who you know is an expert in its usage.
-Aria explains that if you have a cell that is the sales price of a given product,the value of which will change to produce the desired Solver result in the target cell,this cell is what kind of cell?

Accepted Answer

A)  goal cell 
B)  constraint 
C)  changing cell 
D)  absolute cell 
A)  goal cell 
B)  constraint 
C)  changing cell 
D)  absolute cell C

Question 4

An array argument performs multiple calculations on one or more sets of values and then returns either a single value or multiple values._________________________

Accepted Answer

A) True 
 B)False

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-Adds commands and features to Excel

Accepted Answer

A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result 
A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result

Question 6

Case 10-1
You are planning to open a new restaurant and need to determine how many dinners need to be sold to stay above the break-even point.You will investigate Cost Volume Profit (CVP),also known as break-even analysis.
-When creating a one-variable Data Table,which of the following should you NOT do?

Accepted Answer

A)  Enter a formula that references the input cell in the upper-left cell of the table. 
B)  Enter input values in either the second row or the first column. 
C)  Enter input values in either the first row or the first column. 
D)  Select the table excluding any row or column headings. 
A)  Enter a formula that references the input cell in the upper-left cell of the table. 
B)  Enter input values in either the second row or the first column. 
C)  Enter input values in either the first row or the first column. 
D)  Select the table excluding any row or column headings.

Question 7

Identify the letter of the choice that best matches the phrase or definition.
-Means that a constraint was not a limiting factor in a Solver solution

Accepted Answer

A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result 
A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result

Question 8

You can switch from one scenario to another by clicking the _______ button in the Scenario Manager dialog box.

Accepted Answer

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

Question 9

_______ is a program that searches for the optimal solution of a problem involving several variables.

Accepted Answer

A)  Trial and error 
B)  Solver 
C)  Goal Seek 
D)  Scenario Manager 
A)  Trial and error 
B)  Solver 
C)  Goal Seek 
D)  Scenario Manager

Question 10

A(n)optimal cell is a cell that Excel changes to produce the desired result in the target cell._________________________

Accepted Answer

A) True 
 B)False

Question 11

In Solver,changing cells are sometimes referred to as _______ cells.

Accepted Answer

A)  self-adjusting 
B)  variable 
C)  key 
D)  constraint 
A)  self-adjusting 
B)  variable 
C)  key 
D)  constraint

Question 12

To activate Solver,click Solver Add-In in the _______.

Accepted Answer

A)  Add-Ins dialog box 
B)  Solver dialog box 
C)  Analysis group 
D)  Data Tools group 
A)  Add-Ins dialog box 
B)  Solver dialog box 
C)  Analysis group 
D)  Data Tools group

Question 13

Goal Seek is a program that searches for the optimal solution of a problem involving several variables._________________________

Accepted Answer

A) True 
 B)False

Question 14

Case 10-2
As you begin to work with Solver,you have questions.So you turn to your co-worker,Aria,who you know is an expert in its usage.
-Aria explains that there are six possible constraints supported by Solver.Which of the following is one of those constraints?

Accepted Answer

A)  != 
B)  >= 
C)  ≠ 
D)  # 
A)  != 
B)  >= 
C)  ≠ 
D)  #

Question 15

Nonbinding constraints always show a slack of 0._________________________

Accepted Answer

A) True 
 B)False

Question 16

Identify the letter of the choice that best matches the phrase or definition.
-Cannot be used when a problem contains integer constraints

Accepted Answer

A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result 
A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result

Question 17

How does Goal Seek differ from traditional what-if analysis?

Accepted Answer

Goal Seek uses a different approach from

Question 18

As in traditional what-if analysis,Goal Seek starts with the end result and determines what value you should use to reach a desired answer.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following expense types can be used in a CVP analysis?

Accepted Answer

A)  static 
B)  variable 
C)  dynamic 
D)  declining 
A)  static 
B)  variable 
C)  dynamic 
D)  declining

Question 20

A(n)_______ procedure means that Solver starts with an initial solution and uses that as a basis to calculate a series of solutions.

Accepted Answer

A)  reciprocal 
B)  iterative 
C)  secondary 
D)  convergent 
A)  reciprocal 
B)  iterative 
C)  secondary 
D)  convergent

All three expense types can be classified as _______.

Identify the letter of the choice that best matches the phrase or definition. -Cells whose values you will change within each scenario

An array argument performs multiple calculations on one or more sets of values and then returns either a single value or multiple values._________________________

Identify the letter of the choice that best matches the phrase or definition. -Adds commands and features to Excel

Identify the letter of the choice that best matches the phrase or definition. -Means that a constraint was not a limiting factor in a Solver solution

You can switch from one scenario to another by clicking the _______ button in the Scenario Manager dialog box.

_______ is a program that searches for the optimal solution of a problem involving several variables.

A(n)optimal cell is a cell that Excel changes to produce the desired result in the target cell._________________________

In Solver,changing cells are sometimes referred to as _______ cells.

To activate Solver,click Solver Add-In in the _______.

Goal Seek is a program that searches for the optimal solution of a problem involving several variables._________________________

Case 10-2 As you begin to work with Solver,you have questions.So you turn to your co-worker,Aria,who you know is an expert in its usage. -Aria explains that there are six possible constraints supported by Solver.Which of the following is one of those constraints?

Nonbinding constraints always show a slack of 0._________________________

Identify the letter of the choice that best matches the phrase or definition. -Cannot be used when a problem contains integer constraints

How does Goal Seek differ from traditional what-if analysis?

As in traditional what-if analysis,Goal Seek starts with the end result and determines what value you should use to reach a desired answer.

Which of the following expense types can be used in a CVP analysis?

A(n)_______ procedure means that Solver starts with an initial solution and uses that as a basis to calculate a series of solutions.

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

Exam 10: Performing What-If Analyses

All three expense types can be classified as _______.

Identify the letter of the choice that best matches the phrase or definition. -Cells whose values you will change within each scenario

An array argument performs multiple calculations on one or more sets of values and then returns either a single value or multiple values._________________________

Identify the letter of the choice that best matches the phrase or definition. -Adds commands and features to Excel

Identify the letter of the choice that best matches the phrase or definition. -Means that a constraint was not a limiting factor in a Solver solution

You can switch from one scenario to another by clicking the _______ button in the Scenario Manager dialog box.

_______ is a program that searches for the optimal solution of a problem involving several variables.

A(n)optimal cell is a cell that Excel changes to produce the desired result in the target cell._________________________

In Solver,changing cells are sometimes referred to as _______ cells.

To activate Solver,click Solver Add-In in the _______.

Goal Seek is a program that searches for the optimal solution of a problem involving several variables._________________________

Case 10-2 As you begin to work with Solver,you have questions.So you turn to your co-worker,Aria,who you know is an expert in its usage. -Aria explains that there are six possible constraints supported by Solver.Which of the following is one of those constraints?

Nonbinding constraints always show a slack of 0._________________________

Identify the letter of the choice that best matches the phrase or definition. -Cannot be used when a problem contains integer constraints

How does Goal Seek differ from traditional what-if analysis?

As in traditional what-if analysis,Goal Seek starts with the end result and determines what value you should use to reach a desired answer.

Which of the following expense types can be used in a CVP analysis?

A(n)_______ procedure means that Solver starts with an initial solution and uses that as a basis to calculate a series of solutions.

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