Excel includes an add-in called ________ to find optimal solutions to optimization problems formulated as spreadsheet models.
A)Goal Seek
B)Scenario Manager
C)Consolidator
D)Solver

Question

Quizplus · Accepted Answer

The add-in called Solver is specifically designed to find optimal solutions to optimization problems formulated as spreadsheet models. Goal Seek is used to find the input value needed to achieve a desired result, Scenario Manager is used to create and compare different scenarios to analyze and decide the best course of action, and Consolidator is used to combine data from multiple worksheets into a summary report. None of these add-ins are specifically designed for optimization problems.

Excel Includes an Add-In Called ________ to Find Optimal Solutions