Question 1

Aside from Solver,other Excel _______ provide the ability to perform statistical analyses,generate business reports,and retrieve financial data from the Internet.

Accepted Answer

A)  parameters 
B)  add-ins 
C)  helper applications 
D)  constraint applications 
A)  parameters 
B)  add-ins 
C)  helper applications 
D)  constraint applications

Question 2

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.
-In your company,there is a physical limit on the number of products that the factories can produce in a given year.What does Aria tell you this limit is called,in Solver's terms?

Accepted Answer

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

Question 3

Solver is an add-in,a program that adds customized commands and features to Microsoft Office programs such as Excel.

Accepted Answer

A) True 
 B)False

Question 4

A limits report allows you to quantify the reliability of a solution produced by Solver.

Accepted Answer

A) True 
 B)False

Question 5

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.
-In building an Income statement worksheet,you will calculate variable and fixed expenses based on number of meals sold.To explore the impact of changing different values in the worksheet,you can use _______.

Accepted Answer

A)  Solver manager 
B)  Income Statement Analysis 
C)  What-If analysis 
D)  Cash Flow analysis 
A)  Solver manager 
B)  Income Statement Analysis 
C)  What-If analysis 
D)  Cash Flow analysis

Question 6

Cells that display the value _______ indicate that all of the values in the worksheet satisfy the Solver constraints.

Accepted Answer

A)  TRUE 
B)  YES 
C)  1 
D)  0 
A)  TRUE 
B)  YES 
C)  1 
D)  0

Question 7

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.
-The data table provides the results of several what-if analyses,but results are often clearer if you include a(n)_______ chart.

Accepted Answer

A)  Excel 
B)  CVP 
C)  Goal Seek 
D)  Income 
A)  Excel 
B)  CVP 
C)  Goal Seek 
D)  Income

Question 8

You cannot merge scenarios in situations involving multiple workbooks.

Accepted Answer

A) True 
 B)False

Question 9

Identify the letter of the choice that best matches the phrase or definition.
-Cells that contain the calculated values you want to examine

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 10

A business must pay insurance and rent; these are examples of _______ expenses.

Accepted Answer

A)  fixed 
B)  variable 
C)  mixed 
D)  transitional 
A)  fixed 
B)  variable 
C)  mixed 
D)  transitional

Question 11

{=SUM(B1:B10*C1:C10)} is an example of a(n)_______.

Accepted Answer

A)  array formula 
B)  TABLE function 
C)  scenario 
D)  input value 
A)  array formula 
B)  TABLE function 
C)  scenario 
D)  input value

Question 12

Identify the letter of the choice that best matches the phrase or definition.
-Summarizes the results of a successful 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 13

To perform a what-if analysis with more than two input cells,you _______.

Accepted Answer

A)  hide all references 
B)  use only exchange values 
C)  apply additional constraints 
D)  create scenarios 
A)  hide all references 
B)  use only exchange values 
C)  apply additional constraints 
D)  create scenarios

Question 14

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.
-First you must understand break-even analysis.The definition of break-even point is where the total revenue _______ total expenses.

Accepted Answer

A)  is less than 
B)  is greater than 
C)  equals 
D)  exceeds 
A)  is less than 
B)  is greater than 
C)  equals 
D)  exceeds

Question 15

With Goal Seek,you specify the _______ values you want.

Accepted Answer

A)  result 
B)  constraint 
C)  exchange 
D)  index 
A)  result 
B)  constraint 
C)  exchange 
D)  index

Aside from Solver,other Excel _______ provide the ability to perform statistical analyses,generate business reports,and retrieve financial data from the Internet.

Solver is an add-in,a program that adds customized commands and features to Microsoft Office programs such as Excel.

A limits report allows you to quantify the reliability of a solution produced by Solver.

Cells that display the value _______ indicate that all of the values in the worksheet satisfy the Solver constraints.

You cannot merge scenarios in situations involving multiple workbooks.

Identify the letter of the choice that best matches the phrase or definition. -Cells that contain the calculated values you want to examine

A business must pay insurance and rent; these are examples of _______ expenses.

{=SUM(B1:B10*C1:C10)} is an example of a(n)_______.

Identify the letter of the choice that best matches the phrase or definition. -Summarizes the results of a successful Solver solution

To perform a what-if analysis with more than two input cells,you _______.

With Goal Seek,you specify the _______ values you want.

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

Aside from Solver,other Excel _______ provide the ability to perform statistical analyses,generate business reports,and retrieve financial data from the Internet.

Solver is an add-in,a program that adds customized commands and features to Microsoft Office programs such as Excel.

A limits report allows you to quantify the reliability of a solution produced by Solver.

Cells that display the value _______ indicate that all of the values in the worksheet satisfy the Solver constraints.

You cannot merge scenarios in situations involving multiple workbooks.

Identify the letter of the choice that best matches the phrase or definition. -Cells that contain the calculated values you want to examine

A business must pay insurance and rent; these are examples of _______ expenses.

{=SUM(B1:B10*C1:C10)} is an example of a(n)_______.

Identify the letter of the choice that best matches the phrase or definition. -Summarizes the results of a successful Solver solution

To perform a what-if analysis with more than two input cells,you _______.

With Goal Seek,you specify the _______ values you want.

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