Question 1

Which of the following is NOT one of the three required parameters when running a Solver model?

Accepted Answer

A)  the objective cell that you want to maximize, minimize, or set to a specific value 
B)  the variable cells that produce the desired results in the objective cell 
C)  the constraints that limit how to solve the problem 
D)  the formula you plan to use to produce the result in the objective cell 
A)  the objective cell that you want to maximize, minimize, or set to a specific value 
B)  the variable cells that produce the desired results in the objective cell 
C)  the constraints that limit how to solve the problem 
D)  the formula you plan to use to produce the result in the objective cell

Question 2

Case 9-2
   
Rick has created the chart above outlining the information he has on producing toy trains. He will create a two-dimensional chart to visualize the information. Please refer to the chart above as you answer the questions below.
-The slack for molding time for Sample 3 shows ____.

Accepted Answer

A)  10 hours of molding time, with 5 hours borrowed from finishing time 
B)  10 hours too many used for molding time, with 5 hours of unused finishing time 
C)  10 hours of unused molding time, with 5 hours too many used for finishing time 
D)  none of the above 
A)  10 hours of molding time, with 5 hours borrowed from finishing time 
B)  10 hours too many used for molding time, with 5 hours of unused finishing time 
C)  10 hours of unused molding time, with 5 hours too many used for finishing time 
D)  none of the above

Question 3

Solver lets you create a ____ model of a business scenario.

Accepted Answer

A)  mathematical 
B)  business 
C)  random 
D)  qualitative 
A)  mathematical 
B)  business 
C)  random 
D)  qualitative

Question 4

The cells in a worksheet usually display combinations of text or numbers; the math that generates the answers is ____ in the worksheet itself.

Accepted Answer

A)  visible 
B)  not visible 
C)  written in bold text 
D)  none of the above 
A)  visible 
B)  not visible 
C)  written in bold text 
D)  none of the above

Question 5

Ranges are the boundaries that define the feasible solution area. _________________________

Accepted Answer

A) True 
 B)False

Question 6

After you load the Solver Add-in, the Solver command is available in the ____ group on the DATA tab.

Accepted Answer

A)  Analysis 
B)  Data 
C)  Formulas 
D)  What-if 
A)  Analysis 
B)  Data 
C)  Formulas 
D)  What-if

Question 7

The ____ operators you can use in Solver are less than or equal to (=), integer (int), binary (bin), and different (dif).

Accepted Answer

A)  comparison 
B)  match 
C)  Scenario 
D)  simple 
A)  comparison 
B)  match 
C)  Scenario 
D)  simple

Question 8

Case 9-2
   
Rick has created the chart above outlining the information he has on producing toy trains. He will create a two-dimensional chart to visualize the information. Please refer to the chart above as you answer the questions below.
-Rick runs Solver and receives an infeasible solution. To create a feasible solution, one idea he has is to loosen some of the constraints. He knows that loosening criteria with a less than or equal to operator will then ____.

Accepted Answer

A)  increase values 
B)  decrease values 
C)  either a or b 
D)  neither a nor b 
A)  increase values 
B)  decrease values 
C)  either a or b 
D)  neither a nor b

Question 9

After you load the Solver Add-in, the Solver command is available in the Data group on the DATA tab.

Accepted Answer

A) True 
 B)False

Question 10

If Solver attempts the maximum number of iterations without the objective cell converging to an answer, the assumption is that the solution is ____.

Accepted Answer

A)  bounded 
B)  unbounded 
C)  targeted 
D)  untargeted 
A)  bounded 
B)  unbounded 
C)  targeted 
D)  untargeted

Question 11

The constraints that you add to the Solver Parameters dialog box are ____.

Accepted Answer

A)  saved with the worksheet 
B)  deleted when the worksheet is saved 
C)  archived in a constraints folder 
D)  none of the above 
A)  saved with the worksheet 
B)  deleted when the worksheet is saved 
C)  archived in a constraints folder 
D)  none of the above

Question 12

In a Solver model, a value of TRUE indicates a constraint that could not be satisfied. _________________________

Accepted Answer

A) True 
 B)False

Question 13

Range names are usually the source of the problem when Solver cannot find a feasible solution.

Accepted Answer

A) True 
 B)False

Question 14

After changing one or more values in your constraints table, you must click the Solve button in the Solver Parameters dialog box to "resolve" the problem because Solver is not included in the automatic recalculation that Excel performs when you change a cell in a worksheet. _________________________

Accepted Answer

A) True 
 B)False

Question 15

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-A mathematical formula that relates the decision variables or variable cells to the desired outcome

Accepted Answer

A) linear function 
B) nonlinear function 
C) unbounded solution 
D) infeasible solution 
E) objective function
F)Solver model 
A) linear function 
B) nonlinear function 
C) unbounded solution 
D) infeasible solution 
E) objective function
F)Solver model

Question 16

By including the constraints in your worksheet, you will have ____.

Accepted Answer

A)  a record of them for later use 
B)  a data-entry reference when you set up Solver 
C)  both a and b 
D)  neither a nor b 
A)  a record of them for later use 
B)  a data-entry reference when you set up Solver 
C)  both a and b 
D)  neither a nor b

Question 17

Identify the letter of the choice that best matches the items in the Solver answer report above.
-Includes the objective cell reference and name (which is generated from the worksheet's labels), the original value in the cell, and the final value in the cell

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 18

A(n) ____________________ solution results when Solver cannot determine the combination of decision variables that satisfies all of the constraints.

Accepted Answer

The answer of A(n) ____________________ solution results when Solver cannot...

Question 19

The ____ dialog box lets you put limits on the amount of iterations Solver will attempt to solve a problem.

Accepted Answer

A)  Solver Results 
B)  Solver Parameters 
C)  Scenario Manager 
D)  Options 
A)  Solver Results 
B)  Solver Parameters 
C)  Scenario Manager 
D)  Options

Question 20

When troubleshooting, one of the best options is to save the worksheet and the Solver model in a blank section of the worksheet.

Accepted Answer

A) True 
 B)False

Which of the following is NOT one of the three required parameters when running a Solver model?

Case 9-2 Rick has created the chart above outlining the information he has on producing toy trains. He will create a two-dimensional chart to visualize the information. Please refer to the chart above as you answer the questions below. -The slack for molding time for Sample 3 shows ____.

Solver lets you create a ____ model of a business scenario.

The cells in a worksheet usually display combinations of text or numbers; the math that generates the answers is ____ in the worksheet itself.

Ranges are the boundaries that define the feasible solution area. _________________________

After you load the Solver Add-in, the Solver command is available in the ____ group on the DATA tab.

The ____ operators you can use in Solver are less than or equal to (<=), equal to (=), greater than or equal to (>=), integer (int), binary (bin), and different (dif).

After you load the Solver Add-in, the Solver command is available in the Data group on the DATA tab.

If Solver attempts the maximum number of iterations without the objective cell converging to an answer, the assumption is that the solution is ____.

The constraints that you add to the Solver Parameters dialog box are ____.

In a Solver model, a value of TRUE indicates a constraint that could not be satisfied. _________________________

Range names are usually the source of the problem when Solver cannot find a feasible solution.

After changing one or more values in your constraints table, you must click the Solve button in the Solver Parameters dialog box to "resolve" the problem because Solver is not included in the automatic recalculation that Excel performs when you change a cell in a worksheet. _________________________

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -A mathematical formula that relates the decision variables or variable cells to the desired outcome

By including the constraints in your worksheet, you will have ____.

Identify the letter of the choice that best matches the items in the Solver answer report above. -Includes the objective cell reference and name (which is generated from the worksheet's labels), the original value in the cell, and the final value in the cell

A(n) ____________________ solution results when Solver cannot determine the combination of decision variables that satisfies all of the constraints.

The ____ dialog box lets you put limits on the amount of iterations Solver will attempt to solve a problem.

When troubleshooting, one of the best options is to save the worksheet and the Solver model in a blank section of the 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

Which of the following is NOT one of the three required parameters when running a Solver model?

Case 9-2 Rick has created the chart above outlining the information he has on producing toy trains. He will create a two-dimensional chart to visualize the information. Please refer to the chart above as you answer the questions below. -The slack for molding time for Sample 3 shows ____.

Solver lets you create a ____ model of a business scenario.

The cells in a worksheet usually display combinations of text or numbers; the math that generates the answers is ____ in the worksheet itself.

Ranges are the boundaries that define the feasible solution area. _________________________

After you load the Solver Add-in, the Solver command is available in the ____ group on the DATA tab.

The ____ operators you can use in Solver are less than or equal to (<=), equal to (=), greater than or equal to (>=), integer (int), binary (bin), and different (dif).

After you load the Solver Add-in, the Solver command is available in the Data group on the DATA tab.

If Solver attempts the maximum number of iterations without the objective cell converging to an answer, the assumption is that the solution is ____.

The constraints that you add to the Solver Parameters dialog box are ____.

In a Solver model, a value of TRUE indicates a constraint that could not be satisfied. _________________________

Range names are usually the source of the problem when Solver cannot find a feasible solution.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -A mathematical formula that relates the decision variables or variable cells to the desired outcome

By including the constraints in your worksheet, you will have ____.

Identify the letter of the choice that best matches the items in the Solver answer report above. -Includes the objective cell reference and name (which is generated from the worksheet's labels), the original value in the cell, and the final value in the cell

A(n) ____________________ solution results when Solver cannot determine the combination of decision variables that satisfies all of the constraints.

The ____ dialog box lets you put limits on the amount of iterations Solver will attempt to solve a problem.

When troubleshooting, one of the best options is to save the worksheet and the Solver model in a blank section of the 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