What is the ‘what if’ analysis in excel?

Asked 25-Mar-2022
Viewed 374 times

1 Answer


0

What is the ‘what if’ analysis in excel?
  • What-If Analysis is the act of altering cell values to observe how such changes affect the results of formulas on the worksheet.
  • Scenarios, Goal Seek, and Data Tables are three types of What-If Analysis tools included with Excel. Scenarios and data tables take a collection of input values and predict what might happen.
  • A Data Table only has one or two variables, but those variables can have many different values. Although a Scenario can have several variables, it can only hold 32 values. In contrast to Scenarios and Data Tables, Goal Seek takes a result and determines possible input values that create that result.


Read More: Explain pivot tables along with their features in excel.