Exam 9: Enhancing Decision Making with Solver
Exam 1: Applying Fundamental Excel Skills and Tools in Problem Solving150 Questions
Exam 2: Solving Problems with Statistical Analysis Tools150 Questions
Exam 3: Determining Effective Data Display with Charts150 Questions
Exam 4: Applying Logic in Decision Making150 Questions
Exam 5: Retrieving Data for Computation, Analysis, and Reference150 Questions
Exam 6: Evaluating the Financial Impact of Loans and Investments150 Questions
Exam 7: Organizing Data for Effective Analysis150 Questions
Exam 8: Using Data Tables and Excel Scenarios for What-If Analysis150 Questions
Exam 9: Enhancing Decision Making with Solver150 Questions
Exam 10: Troubleshooting Workbooks and Automating Excel Applications150 Questions
Select questions type
Which of the following is NOT one of the three required parameters when running a Solver model?
(Multiple Choice)
4.8/5
(35)
There are three steps to troubleshoot an infeasible solution in Solver. Which of the following is NOT one of them?
(Multiple Choice)
4.8/5
(38)
Before changing the Solver parameters to troubleshoot a problem in a Solver model, you might want to ____ so you can return to it later if necessary.
(Multiple Choice)
4.7/5
(34)
A ____ saves the result of a Solver model so that you can load it later.
(Multiple Choice)
4.9/5
(33)
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 ____.

(Multiple Choice)
4.9/5
(37)
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.
(Short Answer)
4.8/5
(36)
Solver can produce four different reports: summary, answer, sensitivity, and limits.
(True/False)
4.9/5
(39)
Each constraint contains a cell reference to a cell in a worksheet, a ____, and a cell reference or a constraint value.
(Multiple Choice)
4.8/5
(31)
By default, Solver attempts to solve a problem 230 times before it stops working and determines that there is no feasible solution.
(True/False)
4.8/5
(41)
Solver lets you establish ____ that restrict the values that are entered into the variable cells.
(Multiple Choice)
4.7/5
(37)
Showing 141 - 150 of 150
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)