Question

what is "what-if'' analysis tool in Excel? Explain its Types.
.
.
Please explain as simple words as possible. You can also use Hinglish.
Please don't spam!​​

Answer 1

Answer:

What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Three kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables. ... The Solver add-in is similar to Goal Seek, but it can accommodate more variables.