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
You can base the constraints that limit the value of a particular cell in the Solver model on ____.
(Multiple Choice)
4.8/5
(31)
Solver inserts values in the ____ until the value of the objective cell has reached the specified goal.
(Multiple Choice)
4.9/5
(41)
If you try to solve a problem in which there are no constraints or too few constraints, the solution is bounded. _________________________
(True/False)
4.7/5
(39)
When solving problems with nonlinear objective functions, you must enter a variety of starting points to ensure that the answer that Solver reports is actually the optimal solution.
(True/False)
4.8/5
(39)
Using the integer constraint significantly adds to the computational complexity of a Solver model.
(True/False)
4.9/5
(38)
If you add a(n) ____ constraint to the variable cells, Solver will use the value 1 or 0 in the solution.
(Multiple Choice)
4.8/5
(40)
The ____________________ constraint assigns the value 0 or 1 to variable cells.
(Short Answer)
4.8/5
(40)
An infeasible solution results when Solver cannot determine the combination of decision variables that satisfies all of the constraints. What are three ways you can troubleshoot this situation?
(Essay)
4.9/5
(25)
Solver can produce four different reports: summary, answer, sensitivity, and limits.
(True/False)
4.9/5
(38)
____ reports are NOT one of the three reports Solver can produce.
(Multiple Choice)
4.8/5
(29)
Showing 141 - 150 of 150
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)