Question 1

Policy constraints are often based on company history and, to some extent, inertia.

Accepted Answer

A) True 
 B)False

Question 2

When using the Solver model, a value of ____ indicates a satisfied constraint.

Accepted Answer

A)  TRUE 
B)  YES 
C)  NO 
D)  FALSE 
A)  TRUE 
B)  YES 
C)  NO 
D)  FALSE

Question 3

Maximize Z = Q1 + Q2 is an example of a(n) ____________________ function, a mathematical formula that relates the decision variables or variable cells to the desired outcome.

Accepted Answer

The answer of Maximize Z = Q1 + Q2 is...

Question 4

It is more difficult to use Solver with linear functions than nonlinear functions.

Accepted Answer

A) True 
 B)False

Question 5

Identify the letter of the choice that best matches the items in the Solver answer report above.
-The constraint has a final value that is equal to the value of the constraint

Accepted Answer

A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6 
A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6

Question 6

Restricting the number of gallons of milk that a customer can buy at a sale price is a ____.

Accepted Answer

A)  physical limit 
B)  policy limit 
C)  COGS limit 
D)  maximizing limit 
A)  physical limit 
B)  policy limit 
C)  COGS limit 
D)  maximizing limit

Question 7

Because Solver is a(n) database model, there is nothing to keep it from producing negative results. _________________________

Accepted Answer

A) True 
 B)False

Question 8

Each constraint contains a cell reference to a cell in a worksheet, a ____, and a cell reference or a constraint value.

Accepted Answer

A)  formula 
B)  comparison operator 
C)  physical limit 
D)  function 
A)  formula 
B)  comparison operator 
C)  physical limit 
D)  function

Question 9

Identify the letter of the choice that best matches the items in the Solver answer report above.
-The constraint does not have a final value that is equal to the value of the constraint

Accepted Answer

A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6 
A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6

Question 10

Solver changes the values in the variable cells to maximize, minimize, or set the objective cell
to a specific value. _________________________

Accepted Answer

A) True 
 B)False

Question 11

When you copy a worksheet that contains a Solver model, the Solver model is not saved with the new worksheet unless you save it as a model in a blank area of the worksheet and load the Solver model into the new worksheet.

Accepted Answer

A) True 
 B)False

Question 12

Identify the letter of the choice that best matches the items in the Solver answer report above.
-Includes detailed information about the objective cell, variable cells, and constraints

Accepted Answer

A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6 
A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6

Question 13

A(n) ____ function is a mathematical formula that relates the decision variables or variable cells to the desired outcome.

Accepted Answer

A)  objective 
B)  subjective 
C)  relative 
D)  absolute 
A)  objective 
B)  subjective 
C)  relative 
D)  absolute

Question 14

The combination of the objective cell, variable cells, and constraints that are used to solve a problem is called a(n) ____________________ model.

Accepted Answer

The answer of The combination of the objective cell, variable...

Question 15

The ____ section of the answer report contains the cell reference, name, cell value, and formula for cells that have constraints.

Accepted Answer

A)  Objective Cell (Max) 
B)  Adjustable Cells 
C)  Constraints 
D)  Output 
A)  Objective Cell (Max) 
B)  Adjustable Cells 
C)  Constraints 
D)  Output

Question 16

If all of the constraints, which represent the availability of resources, have ____ values, the solution isn't the optimal solution that maximizes the available resources.

Accepted Answer

A)  slack 
B)  constraint 
C)  input 
D)  result 
A)  slack 
B)  constraint 
C)  input 
D)  result

Question 17

The method you use to narrow the available options for a problem so you can choose the best potential outcome is an analytical process known as ____ in the field of management science.

Accepted Answer

A)  optimization 
B)  simulation 
C)  targeting 
D)  breaking even 
A)  optimization 
B)  simulation 
C)  targeting 
D)  breaking even

Question 18

You can use ____ in the Constraint input box of the Add Constraint dialog box instead of entering a specific value.

Accepted Answer

A)  cell references 
B)  file references 
C)  workbook references 
D)  worksheet references 
A)  cell references 
B)  file references 
C)  workbook references 
D)  worksheet references

Question 19

The ____ section of the answer report includes the objective cell reference and name, the original value in the cell, and the final value in the cell.

Accepted Answer

A)  Objective Cell (Max) 
B)  Adjustable Cells 
C)  Constraints 
D)  Output 
A)  Objective Cell (Max) 
B)  Adjustable Cells 
C)  Constraints 
D)  Output

Question 20

The ____ section of the answer report includes the cell reference, name, original value, and final value of the variable cells in a worksheet.

Accepted Answer

A)  Objective Cell (Max) 
B)  Variable Cells 
C)  Constraints 
D)  Output 
A)  Objective Cell (Max) 
B)  Variable Cells 
C)  Constraints 
D)  Output

Policy constraints are often based on company history and, to some extent, inertia.

When using the Solver model, a value of ____ indicates a satisfied constraint.

Maximize Z = Q1 + Q2 is an example of a(n) ____________________ function, a mathematical formula that relates the decision variables or variable cells to the desired outcome.

It is more difficult to use Solver with linear functions than nonlinear functions.

Identify the letter of the choice that best matches the items in the Solver answer report above. -The constraint has a final value that is equal to the value of the constraint

Restricting the number of gallons of milk that a customer can buy at a sale price is a ____.

Because Solver is a(n) database model, there is nothing to keep it from producing negative results. _________________________

Each constraint contains a cell reference to a cell in a worksheet, a ____, and a cell reference or a constraint value.

Identify the letter of the choice that best matches the items in the Solver answer report above. -The constraint does not have a final value that is equal to the value of the constraint

Solver changes the values in the variable cells to maximize, minimize, or set the objective cell to a specific value. _________________________

When you copy a worksheet that contains a Solver model, the Solver model is not saved with the new worksheet unless you save it as a model in a blank area of the worksheet and load the Solver model into the new worksheet.

Identify the letter of the choice that best matches the items in the Solver answer report above. -Includes detailed information about the objective cell, variable cells, and constraints

A(n) ____ function is a mathematical formula that relates the decision variables or variable cells to the desired outcome.

The combination of the objective cell, variable cells, and constraints that are used to solve a problem is called a(n) ____________________ model.

The ____ section of the answer report contains the cell reference, name, cell value, and formula for cells that have constraints.

If all of the constraints, which represent the availability of resources, have ____ values, the solution isn't the optimal solution that maximizes the available resources.

The method you use to narrow the available options for a problem so you can choose the best potential outcome is an analytical process known as ____ in the field of management science.

You can use ____ in the Constraint input box of the Add Constraint dialog box instead of entering a specific value.

The ____ section of the answer report includes the objective cell reference and name, the original value in the cell, and the final value in the cell.

The ____ section of the answer report includes the cell reference, name, original value, and final value of the variable cells in a worksheet.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What If Analysis

Troubleshooting Workbooks and Automating Excel Applications

Filters

Exam 9: Enhancing Decision Making with Solver

Policy constraints are often based on company history and, to some extent, inertia.

When using the Solver model, a value of ____ indicates a satisfied constraint.

Maximize Z = Q1 + Q2 is an example of a(n) ____________________ function, a mathematical formula that relates the decision variables or variable cells to the desired outcome.

It is more difficult to use Solver with linear functions than nonlinear functions.

Identify the letter of the choice that best matches the items in the Solver answer report above. -The constraint has a final value that is equal to the value of the constraint

Restricting the number of gallons of milk that a customer can buy at a sale price is a ____.

Because Solver is a(n) database model, there is nothing to keep it from producing negative results. _________________________

Each constraint contains a cell reference to a cell in a worksheet, a ____, and a cell reference or a constraint value.

Identify the letter of the choice that best matches the items in the Solver answer report above. -The constraint does not have a final value that is equal to the value of the constraint

Solver changes the values in the variable cells to maximize, minimize, or set the objective cell to a specific value. _________________________

When you copy a worksheet that contains a Solver model, the Solver model is not saved with the new worksheet unless you save it as a model in a blank area of the worksheet and load the Solver model into the new worksheet.

Identify the letter of the choice that best matches the items in the Solver answer report above. -Includes detailed information about the objective cell, variable cells, and constraints

A(n) ____ function is a mathematical formula that relates the decision variables or variable cells to the desired outcome.

The combination of the objective cell, variable cells, and constraints that are used to solve a problem is called a(n) ____________________ model.

The ____ section of the answer report contains the cell reference, name, cell value, and formula for cells that have constraints.

If all of the constraints, which represent the availability of resources, have ____ values, the solution isn't the optimal solution that maximizes the available resources.

The method you use to narrow the available options for a problem so you can choose the best potential outcome is an analytical process known as ____ in the field of management science.

You can use ____ in the Constraint input box of the Add Constraint dialog box instead of entering a specific value.

The ____ section of the answer report includes the objective cell reference and name, the original value in the cell, and the final value in the cell.

The ____ section of the answer report includes the cell reference, name, original value, and final value of the variable cells in a worksheet.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What If Analysis

Troubleshooting Workbooks and Automating Excel Applications

Filters