Question 1

If your input values are in a column,you will use the Column input cell option when you use the Data Table command.

Accepted Answer

A) True 
 B)False

Question 2

Identify the letter of the choice that best matches the phrase or definition.
-Places limits on a problem's solution,in Solver

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 3

To calculate multiple cell values,select the range and type the array formula,then press the _______ keys to enter the formula.

Accepted Answer

A)  Alt+Enter 
B)  Ctrl+Shift+Enter 
C)  Alt+Shift+Enter 
D)  Ctrl+Enter 
A)  Alt+Enter 
B)  Ctrl+Shift+Enter 
C)  Alt+Shift+Enter 
D)  Ctrl+Enter

Question 4

_______ are important because they ensure a realistic solution to your problem.

Accepted Answer

A)  Constraints 
B)  Parameters 
C)  Targets 
D)  Optimals 
A)  Constraints 
B)  Parameters 
C)  Targets 
D)  Optimals

Question 5

In two-variable tables,you must always place a reference to the result cell in the _______ corner of the table at the intersection of the row values and the column values.

Accepted Answer

A)  upper-right 
B)  upper-left 
C)  lower-right 
D)  lower-left 
A)  upper-right 
B)  upper-left 
C)  lower-right 
D)  lower-left

Question 6

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 to you that if you want to use Solver to maximize a company's net income,you first need to understand that a(n)_______ is a cell that is maximized,minimized,or set to a specific value.

Accepted Answer

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

Question 7

_______ analysis expresses the relationship between a company's expenses,its volume of business,and the resulting profit.

Accepted Answer

A)  MVP 
B)  ABC 
C)  CVP 
D)  CBP 
A)  MVP 
B)  ABC 
C)  CVP 
D)  CBP

Question 8

If a value in the worksheet violates one of the constraints,the Solver parameter cells will display the value _______.

Accepted Answer

A)  FALSE 
B)  NO 
C)  1 
D)  0 
A)  FALSE 
B)  NO 
C)  1 
D)  0

Question 9

_______ analysis is an important business decision-making tool because it predicts the effect of cutting overhead or raising prices on net income.

Accepted Answer

A)  CVP 
B)  MVP 
C)  EVP 
D)  AVP 
A)  CVP 
B)  MVP 
C)  EVP 
D)  AVP

Question 10

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.
-Another tool to help analyze several what-if analyses is data tables in Excel.Using a one-variable table,you can specify _______ input cell(s)and any number of result cells.

Accepted Answer

A)  many 
B)  one 
C)  two 
D)  three 
A)  many 
B)  one 
C)  two 
D)  three

Question 11

To open the Goal Seek dialog box,first click the What-If Analysis button in the Data Tools group.

Accepted Answer

A) True 
 B)False

Question 12

Goal Seek uses a different approach from traditional _______ analysis.

Accepted Answer

A)  trial-and-error 
B)  what-if 
C)  worksheet 
D)  hypothetical 
A)  trial-and-error 
B)  what-if 
C)  worksheet 
D)  hypothetical

Question 13

The three items that you must specify when using Solver are _______.

Accepted Answer

A)  target cell, input value, and results 
B)  target cell, variable cell, and parameters 
C)  variable cell, parameters, and constraints 
D)  variable cell, objective cell, and constraints 
A)  target cell, input value, and results 
B)  target cell, variable cell, and parameters 
C)  variable cell, parameters, and constraints 
D)  variable cell, objective cell, and constraints

Question 14

How many different types of reports can Solver create? What are the characteristics of these report types,and which is the most useful?

Accepted Answer

Solver can create three different repo

Question 15

CVP analysis is sometimes called breakthrough analysis._________________________

Accepted Answer

A) True 
 B)False

Question 16

The result cells are the cells containing the values you want to examine._________________________

Accepted Answer

A) True 
 B)False

Question 17

After trying out solutions for a short time,Solver displays the _______ dialog box,which displays the message that indicates Solver has found a solution that satisfies the constraints.

Accepted Answer

A)  Solver Answer 
B)  Solver Solution 
C)  Solver Results 
D)  Solution 
A)  Solver Answer 
B)  Solver Solution 
C)  Solver Results 
D)  Solution

Question 18

The slack is the difference between the value in the cell and the value at the limit of the _______.

Accepted Answer

A)  variable cell 
B)  result cell 
C)  constraint 
D)  risk factor 
A)  variable cell 
B)  result cell 
C)  constraint 
D)  risk factor

Question 19

The answer report is divided into _______ sections.

Accepted Answer

A)  two 
B)  three 
C)  six 
D)  five 
A)  two 
B)  three 
C)  six 
D)  five

Question 20

Solver can create the following three different reports: _______.

Accepted Answer

A)  sensitivity, answer, analysis 
B)  constraint, sensitivity, analysis 
C)  analysis, answer, limits 
D)  answer, limits, sensitivity 
A)  sensitivity, answer, analysis 
B)  constraint, sensitivity, analysis 
C)  analysis, answer, limits 
D)  answer, limits, sensitivity

If your input values are in a column,you will use the Column input cell option when you use the Data Table command.

Identify the letter of the choice that best matches the phrase or definition. -Places limits on a problem's solution,in Solver

To calculate multiple cell values,select the range and type the array formula,then press the _______ keys to enter the formula.

_______ are important because they ensure a realistic solution to your problem.

In two-variable tables,you must always place a reference to the result cell in the _______ corner of the table at the intersection of the row values and the column values.

_______ analysis expresses the relationship between a company's expenses,its volume of business,and the resulting profit.

If a value in the worksheet violates one of the constraints,the Solver parameter cells will display the value _______.

_______ analysis is an important business decision-making tool because it predicts the effect of cutting overhead or raising prices on net income.

To open the Goal Seek dialog box,first click the What-If Analysis button in the Data Tools group.

Goal Seek uses a different approach from traditional _______ analysis.

The three items that you must specify when using Solver are _______.

How many different types of reports can Solver create? What are the characteristics of these report types,and which is the most useful?

CVP analysis is sometimes called breakthrough analysis._________________________

The result cells are the cells containing the values you want to examine._________________________

After trying out solutions for a short time,Solver displays the _______ dialog box,which displays the message that indicates Solver has found a solution that satisfies the constraints.

The slack is the difference between the value in the cell and the value at the limit of the _______.

The answer report is divided into _______ sections.

Solver can create the following three different reports: _______.

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

If your input values are in a column,you will use the Column input cell option when you use the Data Table command.

Identify the letter of the choice that best matches the phrase or definition. -Places limits on a problem's solution,in Solver

To calculate multiple cell values,select the range and type the array formula,then press the _______ keys to enter the formula.

_______ are important because they ensure a realistic solution to your problem.

In two-variable tables,you must always place a reference to the result cell in the _______ corner of the table at the intersection of the row values and the column values.

_______ analysis expresses the relationship between a company's expenses,its volume of business,and the resulting profit.

If a value in the worksheet violates one of the constraints,the Solver parameter cells will display the value _______.

_______ analysis is an important business decision-making tool because it predicts the effect of cutting overhead or raising prices on net income.

To open the Goal Seek dialog box,first click the What-If Analysis button in the Data Tools group.

Goal Seek uses a different approach from traditional _______ analysis.

The three items that you must specify when using Solver are _______.

How many different types of reports can Solver create? What are the characteristics of these report types,and which is the most useful?

CVP analysis is sometimes called breakthrough analysis._________________________

The result cells are the cells containing the values you want to examine._________________________

After trying out solutions for a short time,Solver displays the _______ dialog box,which displays the message that indicates Solver has found a solution that satisfies the constraints.

The slack is the difference between the value in the cell and the value at the limit of the _______.

The answer report is divided into _______ sections.

Solver can create the following three different reports: _______.

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