Question 1

Having a cell in the worksheet that contains the constraint value makes it possible for you to refer to each constraint value as a cell reference in the ____ dialog box.
A) Value
B) Add Constraint
C) Constraint
D) Cell Value

Accepted Answer

In Excel, when adding constraints to Solver, you can refer to constraint values by using cell references in the "Add Constraint" dialog box. This allows for dynamic adjustment of constraints by changing the cell's value.

Question 2

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 ____ that Excel performs when you change a cell in a worksheet.
A) automatic recalculation
B) manual recalculation
C) randomly timed recalculation
D) scheduled recalculation

Accepted Answer

Solver is not included in the automatic recalculation that Excel performs when you change a cell in a worksheet. Therefore, after changing values in the constraints table in Solver, clicking the Solve button is necessary to recalculate and solve the problem.

Question 3

The constraints that you add to the Solver Parameters dialog box are ____.
A) saved with the worksheet
B) deleted when the worksheet is saved
C) archived in a constraints folder
D) none of the above

Accepted Answer

The constraints that are added to the Solver Parameters dialog box are saved with the worksheet. This means that the constraints will still be present even after the worksheet is saved and reopened at a later time.

Question 4

When you graph a nonlinear function on two dimensions, it results in a ____.
A) straight line
B) curved line
C) bar
D) circle

Accepted Answer

A nonlinear function does not follow a straight line, so the graph would result in a curved line.

Question 5

Click the Save Scenario button in the ____ dialog box to open the Save Scenario dialog box.
A) Solver Results
B) Solver Save
C) Solver Summary
D) Solver Scenario

Accepted Answer

The correct option is A) Solver Results. In Excel, when using the Solver add-in to perform optimization tasks, after running a solver model, the Solver Results dialog box appears. From this dialog box, you have the option to save the scenario of your solver model by clicking the "Save Scenario" button, which then opens the Save Scenario dialog box where you can name and save the scenario for future reference.

Question 6

If you keep the Solver solution, the original values are lost and you cannot recover them unless you previously ____.
A) highlighted them
B) saved them
C) deleted them
D) named them

Accepted Answer

Saving the original values before running Solver would allow you to recover them if needed. Highlighting, deleting, or naming them would not preserve the original values.

Question 7

Creating a(n) ____ table in a worksheet organizes the constraints and makes them visible in the worksheet at any time, and without the limitation of having to open the Solver Parameters dialog box and scroll the constraints to view them.
A) constraints
B) data
C) input
D) results

Accepted Answer

Creating a constraints table in Excel organizes the constraints for Solver and makes them visible in the worksheet, making it easier to manage and adjust constraints as needed. Data, input, and results are all related to Solver but are not specifically related to organizing constraints in a table format.

Question 8

A(n) ____ function is a mathematical formula that relates the decision variables or variable cells to the desired outcome.
A) objective
B) subjective
C) relative
D) absolute

Accepted Answer

An objective function is a mathematical formula that relates the decision variables or variable cells of a problem to the desired outcome. Its purpose is to define the goal or objective of the problem and the criteria by which solutions will be evaluated. Therefore, option A is the best choice among the given options.

Question 9

The Constraint input box can contain values, references to cells that contain those values,
And ____.
A) formulas
B) row headers
C) hyperlinks
D) PivotTables

Accepted Answer

The Constraint input box is used to set up constraints or limits for optimization problems. These constraints can include formulas that use variables or references to other cells, but not row headers, hyperlinks, or PivotTables. Therefore, option A is the best choice as it is the only option that is valid for the Constraint input box.

Question 10

Large Solver models run noticeably slower when they include integer constraints because Solver uses a different solution method, called ____, when a model includes integer constraints.
A) integer programming
B) data programming
C) Web programming
D) Excel programming

Accepted Answer

When a model includes integer constraints, Solver uses integer programming techniques to find the optimal solution, which can be more time-consuming than traditional linear programming techniques.

Question 11

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).
A) comparison
B) match
C) Scenario
D) simple

Accepted Answer

The phrase "comparison operators" is commonly used in programming and mathematics to refer to operators such as less than, greater than, and equal to, which are used to compare values. Therefore, A (comparison) is the best choice to complete the sentence.

Question 12

Constraints that are entered into the Add Constraint dialog box are stored in Solver and are only visible when you open the Solver Parameters dialog box; you can see only ____ constraint(s) at a time in this way.
A) one
B) six
C) ten
D) thirteen

Accepted Answer

The answer of Constraints that are entered into the Add...

Question 13

The Cell Reference input box accepts ____.
A) cell references
B) values
C) both a and b
D) neither a nor b

Accepted Answer

The Cell Reference input box is designed to accept only cell references. It is used to input the cell reference of a particular cell that you want to select or reference in various Excel functions and formulas. It does not accept values or any other input other than cell references.

Question 14

Each constraint contains a cell reference to a cell in a worksheet, a ____, and a cell reference or a constraint value.
A) formula
B) comparison operator
C) physical limit
D) function

Accepted Answer

The comparison operator is necessary to establish a relationship between the cell reference and the constraint value. For example, if the constraint is "A1<=10", the "less than or equal to" symbol (<=) is the comparison operator, "A1" is the cell reference, and "10" is the constraint value.

Question 15

You can use ____ in the Constraint input box of the Add Constraint dialog box instead of entering a specific value.
A) cell references
B) file references
C) workbook references
D) worksheet references

Accepted Answer

Cell references can be used to create dynamic constraints that change based on the input or formula in the referenced cell. This allows for flexibility and adaptability in the constraint, rather than being locked into a specific value.

Question 16

A ____ saves the result of a Solver model so that you can load it later.
A) scenario
B) scheme
C) situation
D) save set

Accepted Answer

A scenario in Solver allows you to save and load different sets of input values and result values in a model. This can be useful if you want to compare multiple solutions or make changes to the inputs and see how it affects the output. A scheme and situation are not applicable in this context, and "save set" is not a commonly used term in Solver.

Question 17

To view a previously saved scenario, select it in the Scenarios box, and then click the ____ button to update the worksheet with the data saved in the scenario.
A) Show
B) Display
C) View
D) Save

Accepted Answer

Selecting the scenario and clicking the "Show" button will update the worksheet with the data saved in that scenario. The "Display" and "View" buttons are not relevant to this action, and the "Save" button would save the current state of the worksheet as a new scenario.

Question 18

Although you can enter constraints directly into the ____ dialog box without creating a constraints table in your worksheet, creating a constraints table in the worksheet is a much better way of organizing your Solver models.
A) Solver
B) Constraints
C) Solver Parameters
D) Solver Constraints

Accepted Answer

The correct answer is "Solver Parameters" because this dialog box in Excel's Solver allows users to directly enter constraints for optimization problems, but using a constraints table in the worksheet is recommended for better organization.

Question 19

In Solver, if you select the Value Of option button, you also must enter a(n) ____.
A) specific value
B) worksheet name
C) range name
D) option name

Accepted Answer

The Value Of option button in Solver requires the user to input a specific value, so the best choice is A. Worksheet, range, and option names are not relevant to this option in Solver.

Question 20

When working with Solver, you maximize, minimize, or set the objective cell to a certain value by selecting the Max (maximum), Min (minimum), or ____ option button, respectively.
A) Value Of
B) Value
C) Cell reference
D) Number

Accepted Answer

When setting the objective cell to a certain value, you need to select the "Value of" option button. This allows you to specify the value you want the objective cell to equal.

Quiz 9: Enhancing Decision Making with Solver

Having a cell in the worksheet that contains the constraint value makes it possible for you to refer to each constraint value as a cell reference in the ____ dialog box.

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 ____ that Excel performs when you change a cell in a worksheet.

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

When you graph a nonlinear function on two dimensions, it results in a ____.

Click the Save Scenario button in the ____ dialog box to open the Save Scenario dialog box.

If you keep the Solver solution, the original values are lost and you cannot recover them unless you previously ____.

Creating a(n) ____ table in a worksheet organizes the constraints and makes them visible in the worksheet at any time, and without the limitation of having to open the Solver Parameters dialog box and scroll the constraints to view them.

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

The Constraint input box can contain values, references to cells that contain those values, And ____.

Large Solver models run noticeably slower when they include integer constraints because Solver uses a different solution method, called ____, when a model includes integer constraints.

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) .

Constraints that are entered into the Add Constraint dialog box are stored in Solver and are only visible when you open the Solver Parameters dialog box; you can see only ____ constraint(s) at a time in this way.

The Cell Reference input box accepts ____.

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

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

A ____ saves the result of a Solver model so that you can load it later.

To view a previously saved scenario, select it in the Scenarios box, and then click the ____ button to update the worksheet with the data saved in the scenario.

Although you can enter constraints directly into the ____ dialog box without creating a constraints table in your worksheet, creating a constraints table in the worksheet is a much better way of organizing your Solver models.

In Solver, if you select the Value Of option button, you also must enter a(n) ____.

When working with Solver, you maximize, minimize, or set the objective cell to a certain value by selecting the Max (maximum) , Min (minimum) , or ____ option button, respectively.