Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

When measuring elasticity,when e<1,the price elasticity of demand is perfectly inelastic._________________________

Accepted Answer

A) True 
 B)False

Question 3

The ____________________ input cell is the cell on which you base values placed in the first row of the data table.

Accepted Answer

The answer of The ____________________ input cell is the cell...

Question 4

____________________ constraints always show a slack of 0.

Accepted Answer

The answer of ____________________ constraints always show a slack of...

Question 5

Case-Based Critical Thinking Questions
Case 10-1
You have been having some difficulty in your economics class this semester,so you have requested support from a tutor.One topic that is giving you trouble at the moment is the price elasticity of demand.
-A change in price is met by an equal and opposite change in demand.This is an example of what kind of elasticity,according to your tutor?

Accepted Answer

A)  Unit elastic 
B)  Perfect elastic 
C)  Relative elastic 
D)  Absolute elastic 
A)  Unit elastic 
B)  Perfect elastic 
C)  Relative elastic 
D)  Absolute elastic

Question 6

Not binding constraints always show a slack of 0._________________________

Accepted Answer

A) True 
 B)False

Question 7

CVP analysis is sometimes called breakthrough analysis._________________________

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective 
A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective

Question 9

When elasticity is e>1,the price elasticity is ____________________ elastic.

Accepted Answer

The answer of When elasticity is e>1,the price elasticity is...

Question 10

In a two-variable data table,the values of two result cells are displayed.

Accepted Answer

A) True 
 B)False

Question 11

When you click the Solve button in the Solver Parameters dialog box,in the ____,you can see Solver rapidly "trying out" solutions.

Accepted Answer

A)  menu bar 
B)  status bar 
C)  dialog box 
D)  toolbar 
A)  menu bar 
B)  status bar 
C)  dialog box 
D)  toolbar

Question 12

When measuring elasticity,if e=1,then the elasticity is referred to as unit elastic because any change in price is met by an equal and opposite change in demand._________________________

Accepted Answer

A) True 
 B)False

Question 13

When creating a(n)____________________ data table,you must identify the row input cell and the column input cell.

Accepted Answer

The answer of When creating a(n)____________________ data table,you must identify...

Question 14

-The item marked 2 in the accompanying figure is the ____ point.

Accepted Answer

A)  variable 
B)  fixed 
C)  break-even 
D)  absolute 
A)  variable 
B)  fixed 
C)  break-even 
D)  absolute

Question 15

-If the dialog box in the accompanying figure is used to unlock the changing cells in the scenario,and the worksheet is protected,users can show the scenario but not edit it.

Accepted Answer

A) True 
 B)False

Question 16

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 report

Question 17

MATCHING
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) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective 
A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective

Question 18

You can view a scenario by clicking its name in the Scenarios box in the Scenario Manager dialog box._________________________

Accepted Answer

A) True 
 B)False

Question 19

Case-Based Critical Thinking Questions
Case 10-1
You have been having some difficulty in your economics class this semester,so you have requested support from a tutor.One topic that is giving you trouble at the moment is the price elasticity of demand.
-Consumers have to choose between two products that are exactly equal in all respects,and raising the price of one causes a huge decrease in demand.This is an example of what kind of elasticity,according to your tutor?

Accepted Answer

A)  Relatively inelastic 
B)  Perfectly inelastic 
C)  Relatively elastic 
D)  Perfectly elastic 
A)  Relatively inelastic 
B)  Perfectly inelastic 
C)  Relatively elastic 
D)  Perfectly elastic

Question 20

____ 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

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

When measuring elasticity,when e<1,the price elasticity of demand is perfectly inelastic._________________________

The ____________________ input cell is the cell on which you base values placed in the first row of the data table.

____________________ constraints always show a slack of 0.

Not binding constraints always show a slack of 0._________________________

CVP analysis is sometimes called breakthrough analysis._________________________

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

When elasticity is e>1,the price elasticity is ____________________ elastic.

In a two-variable data table,the values of two result cells are displayed.

When you click the Solve button in the Solver Parameters dialog box,in the ____,you can see Solver rapidly "trying out" solutions.

When measuring elasticity,if e=1,then the elasticity is referred to as unit elastic because any change in price is met by an equal and opposite change in demand._________________________

When creating a(n)____________________ data table,you must identify the row input cell and the column input cell.

-The item marked 2 in the accompanying figure is the ____ point.

-If the dialog box in the accompanying figure is used to unlock the changing cells in the scenario,and the worksheet is protected,users can show the scenario but not edit it.

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

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

You can view a scenario by clicking its name in the Scenarios box in the Scenario Manager dialog box._________________________

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

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 10: Performing What-If Analyses

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

When measuring elasticity,when e<1,the price elasticity of demand is perfectly inelastic._________________________

The ____________________ input cell is the cell on which you base values placed in the first row of the data table.

____________________ constraints always show a slack of 0.

Not binding constraints always show a slack of 0._________________________

CVP analysis is sometimes called breakthrough analysis._________________________

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

When elasticity is e>1,the price elasticity is ____________________ elastic.

In a two-variable data table,the values of two result cells are displayed.

When you click the Solve button in the Solver Parameters dialog box,in the ____,you can see Solver rapidly "trying out" solutions.

When measuring elasticity,if e=1,then the elasticity is referred to as unit elastic because any change in price is met by an equal and opposite change in demand._________________________

When creating a(n)____________________ data table,you must identify the row input cell and the column input cell.

-The item marked 2 in the accompanying figure is the ____ point.

-If the dialog box in the accompanying figure is used to unlock the changing cells in the scenario,and the worksheet is protected,users can show the scenario but not edit it.

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

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

You can view a scenario by clicking its name in the Scenarios box in the Scenario Manager dialog box._________________________

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

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters