In Excel, which is used to perform what if analysis?
- A. Goal seek
- B. Solver
- C. Scenario Manager
- D. All of above
Explanation
Goal Seek, Solver and Scenario Manager are all Excel What-If Analysis tools. Goal Seek changes one input, Solver handles constrained optimisation, and Scenario Manager compares sets of values.