Question

Excel's Solver tool can be configured by the user to automatically find all of the following EXCEPT
(select the most correct answer):
A. Set of multiple roots (where objective function = 0) for an objective function.
B. Nothing. The Solver tool supports finding the solution to all of the above.
C. Maximum of an objective function.
D. Where an objective function has a specified value.
E Minimum of an objective function.

Answere​

Answer 1

Answer:

If you want to experiment with using the Solver on financial models, you could try it out on one of my financial calculators such as the Home Mortgage Calculator. Excel's built-in Goal Seek tool is often enough to solve for x given y, but when you want to add multiple criteria and allow multiple inputs to change, that's where Solver comes in.

Note: You do not need to download the Solver add-in. If you don't see it as one of the menu items in your Tools menu (in Excel), then you need to go to Tools > Add-Ins... and check the box next to "Solver Add In".