Which what-if analysis tool is best suited to determine the input value needed to achieve a specific output?
A)Solver
B)Scenario Manager
C)Goal Seek
D)Two-variable Data Table

Question

Quizplus · Accepted Answer

Goal Seek is the best choice for determining the input value needed to achieve a specific output. It allows the user to set a target value for a formula and then determine the input value needed to achieve that target. Solver is used for optimizing a target value based on multiple input variables. Scenario Manager and Two-variable Data Table are used for testing different scenarios and seeing how changes in inputs affect the output.

Which What-If Analysis Tool Is Best Suited to Determine the Input