Question 1

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

If you select the Value Of option button in Solver, you must enter a specific value that you want the target cell to equal.

Question 2

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 as a variable in constraints, allowing for more flexibility in data analysis and modeling. This allows for the constraints to adapt to changes in the data set without requiring manual updates. File, workbook, and worksheet references are not applicable for constraints.

Question 3

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

The "Value Of" option button allows you to set a specific value for the objective cell. However, the question is asking for the option button that is used to set the objective cell to a certain value, which is the "Value" option button. The "Cell reference" option button is used to select the cell that is the objective cell. The "Number" option button is used to enter a value directly into the objective cell, but it does not maximize, minimize, or set the objective cell to a certain value. Therefore, the best choice is option A.

Question 4

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

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 used to refer to a specific cell or range of cells in a worksheet. It can only accept cell references, which are combinations of column letters and row numbers, such as A1 or C5:D10. It cannot accept values directly.

Question 7

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 8

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

Nonlinear functions do not follow a straight line pattern, and will result in a curved line. Options C and D do not have any relevance to graphing nonlinear functions, while option A would only be applicable to linear functions.

Question 9

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 10

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

Constraints added to the Solver Parameters dialog box are saved with the worksheet, which means they will be retained when the worksheet is saved and closed. Therefore, option A is the correct choice. The options B and C are both incorrect as they do not accurately describe what happens to the constraints added in the Solver Parameters dialog box. Option D is also incorrect as there is a correct answer among the given options.

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 statement is asking about the operators available in Solver, with specific types listed. The types are all used for comparison, indicating relationships between variables or constraints. Therefore, the best choice is A) comparison.

Question 12

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 determine the type of constraint being applied (e.g. greater than, less than, equal to). The cell reference and value are the other necessary components. Formulas and functions may be used within the constraint, but are not a required component. Physical limits may be referenced in the constraint, but are not a necessary component of every constraint.

Question 13

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

The question is asking about a table that organizes and displays constraints in a worksheet. Therefore, the correct answer is A because constraints are being organized in the table. Data, input, and results are not the most appropriate choices as they do not specifically refer to organizing constraints.

Question 14

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 a different solution method called integer programming which generally takes longer to solve compared to linear programming used in models without integer constraints.

Question 15

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 16

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 the Solver is the best option to ensure that they can be recovered if needed. Once Solver is run, any changes made to the original values are lost, and if they were not saved beforehand, they cannot be recovered.

Question 17

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 constraints on the values in the Solver model. It can contain fixed values, references to cells containing those values, or formulas that calculate those values. Row headers, hyperlinks, and PivotTables are not valid inputs for the Constraint input box in Solver.

Question 18

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 equation that relates the decision variables or variable cells to the desired outcome. It is used in mathematical optimization models to find the optimal solution for a given problem. The objective function models the goal or objective of the problem and is usually optimized by adjusting the decision variables. Therefore, A is the best choice.

Question 19

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

The "Show" button is used to display the data from a previously saved scenario on the worksheet. The other options are not relevant for this action.

Question 20

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 saves the result of a model, so that it can be viewed or loaded later.

Quiz 9: Enhancing Decision Making with Solver

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

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

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.

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.

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

The Cell Reference input box accepts ____.

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.

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

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 constraints that you add to the Solver Parameters dialog box are ____.

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

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

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.

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.

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.

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

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

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

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 ____ saves the result of a Solver model so that you can load it later.