Question

Goal Seek and Solver perform similar functions. Which of the following statements is true and describes the functionality that is the SAME between Goal Seek and Solver.

a. Goal Seek and Solver can use a set of constraints to refine the desired inputs.
b. Goal Seek and Solver can optimize an equation to get a max or min value.
c. Goal Seek and Solver both solve an equation by changing input value(s) to get a desired output.
d. Goal Seek and Solver both need to be activated as a plug-in before they can be used.

Answer 1

Goal Seek and Solver in Microsoft Excel can both solve an equation by changing input values to get a desired output.

Step-by-step explanation:

Goal Seek and Solver are both tools in Microsoft Excel that can be used for solving mathematical problems. However, there are some differences in functionality between the two.

Regarding the functionality that is the same between Goal Seek and Solver, option c is correct. Both Goal Seek and Solver solve an equation by changing input value(s) to get a desired output. They both iterate through different input values until a solution is found that satisfies the desired output.

For example, if we have an equation that represents the profit of a business based on certain input variables, Goal Seek and Solver can be used to find the values of the input variables that will maximize the profit.