Question

_________in Excel allows us to try out different scenarios.
(a) Data validation (b) Pivot Table
(c) Chart (d) What if analysis

Answer 1

What if analysis option is available in Excel. It allows the user to try different scenarios.

So, the correct choice for answer from the choices given is option d).

What if analysis is a technique of changing the data of various cells to view how the changes will affect the cells whose value is being calculated using formulas.

There are mainly four types of What if analysis in Microsoft Excel