Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

References,or limits,in Solver are important because they ensure a realistic solution to your problem.

Accepted Answer

A) True 
 B)False

Question 3

Binding constraints always show a slack of ____.

Accepted Answer

A)  -0.01 
B)  0 
C)  0.01 
D)  1 
A)  -0.01 
B)  0 
C)  0.01 
D)  1

Question 4

A limits report is best utilized when your problem contains integer constraints.

Accepted Answer

A) True 
 B)False

Question 5

The ____________________ is the difference between the value in a cell and the value at the limit of the constraint.

Accepted Answer

The answer of The ____________________ is the difference between the...

Question 6

-In the dialog box in the accompanying figure,you select the ____ cell in the By changing cell box.

Accepted Answer

A)  changing 
B)  result 
C)  input 
D)  advance 
A)  changing 
B)  result 
C)  input 
D)  advance

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-In Solver,a cell you want to maximize,for example

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 8

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 9

Case-Based Critical Thinking Questions
Case 10-2
As you begin to work with Solver,you have questions so you turn to your roommate,Barat,who you know is an expert in its usage.
-In your scenario,there is a physical limit on the number of products that the factories can produce in a given year.What does Barat 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 10

____ are a powerful feature of Excel.If used properly,they help you perform complex calculations within a single formula and extend a single formula over a range of cells.

Accepted Answer

A)  Functions 
B)  Formatting 
C)  Array formulas 
D)  Property sheets 
A)  Functions 
B)  Formatting 
C)  Array formulas 
D)  Property sheets

Question 11

Which of the following reports is used when your problem contains integer constraints?

Accepted Answer

A)  Answer 
B)  Sensitivity 
C)  Limits 
D)  both a.and b. 
A)  Answer 
B)  Sensitivity 
C)  Limits 
D)  both a.and b.

Question 12

-Check the item marked 3 in the accompanying figure to hide the scenario in a(n)____________________ worksheet.

Accepted Answer

The answer of  
-Check the item marked 3 in...

Question 13

If Solver is taking too long to find a solution,you can halt the program at any time by pressing the Ctrl key._________________________

Accepted Answer

A) True 
 B)False

Question 14

With what-if analysis,you specify the result values you want,and Excel changes the input values to produce them.

Accepted Answer

A) True 
 B)False

Question 15

That an order must meet store demand,or that it cannot exceed the available parts,are examples of constraints.

Accepted Answer

A) True 
 B)False

Question 16

Case-Based Critical Thinking Questions
Case 10-2
As you begin to work with Solver,you have questions so you turn to your roommate,Barat,who you know is an expert in its usage.
-Barat explains that there are six possible constraints supported by Solver.Which of the following is NOT one of those constraints?

Accepted Answer

A) != B) >= C) <= D) = A) != B) >= C) <= D) =

Question 17

____________________ cells are cells containing values you want to modify in what-if analysis cells.

Accepted Answer

The answer of ____________________ cells are cells containing values you...

Question 18

Case-Based Critical Thinking Questions
Case 10-2
As you begin to work with Solver,you have questions so you turn to your roommate,Barat,who you know is an expert in its usage.
-Barat 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

Question 19

The last column on the right in an answer report shows the ____ for each constraint.

Accepted Answer

A)  reciprocity 
B)  frequency 
C)  slack 
D)  both a.and b. 
A)  reciprocity 
B)  frequency 
C)  slack 
D)  both a.and b.

Question 20

The ____________________ input cell is the cell on which values placed in the first column of the data table are based.

Accepted Answer

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

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

References,or limits,in Solver are important because they ensure a realistic solution to your problem.

Binding constraints always show a slack of ____.

A limits report is best utilized when your problem contains integer constraints.

The ____________________ is the difference between the value in a cell and the value at the limit of the constraint.

-In the dialog box in the accompanying figure,you select the ____ cell in the By changing cell box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -In Solver,a cell you want to maximize,for example

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

____ are a powerful feature of Excel.If used properly,they help you perform complex calculations within a single formula and extend a single formula over a range of cells.

Which of the following reports is used when your problem contains integer constraints?

-Check the item marked 3 in the accompanying figure to hide the scenario in a(n)____________________ worksheet.

If Solver is taking too long to find a solution,you can halt the program at any time by pressing the Ctrl key._________________________

With what-if analysis,you specify the result values you want,and Excel changes the input values to produce them.

That an order must meet store demand,or that it cannot exceed the available parts,are examples of constraints.

____________________ cells are cells containing values you want to modify in what-if analysis cells.

The last column on the right in an answer report shows the ____ for each constraint.

The ____________________ input cell is the cell on which values placed in the first column of the data table are based.

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

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

References,or limits,in Solver are important because they ensure a realistic solution to your problem.

Binding constraints always show a slack of ____.

A limits report is best utilized when your problem contains integer constraints.

The ____________________ is the difference between the value in a cell and the value at the limit of the constraint.

-In the dialog box in the accompanying figure,you select the ____ cell in the By changing cell box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -In Solver,a cell you want to maximize,for example

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

____ are a powerful feature of Excel.If used properly,they help you perform complex calculations within a single formula and extend a single formula over a range of cells.

Which of the following reports is used when your problem contains integer constraints?

-Check the item marked 3 in the accompanying figure to hide the scenario in a(n)____________________ worksheet.

If Solver is taking too long to find a solution,you can halt the program at any time by pressing the Ctrl key._________________________

With what-if analysis,you specify the result values you want,and Excel changes the input values to produce them.

That an order must meet store demand,or that it cannot exceed the available parts,are examples of constraints.

____________________ cells are cells containing values you want to modify in what-if analysis cells.

The last column on the right in an answer report shows the ____ for each constraint.

The ____________________ input cell is the cell on which values placed in the first column of the data table are based.

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