Question

3. Which tab holds the 'What-If Analysis' option?​

Answer 1

$\bf\underline{Data tab}$

From the Data tab, click the What-If Analysis command.

Answer 2

The Data Tab holds 'What-if-Analysis' option.

In order to enable the What if Analysis tool follow the steps:

• Go to the Data menu tab and click on the What-If Analysis option under the Forecast section.
• Now click on the What-If Analysis.
• Excel has the following What-if analysis tools that can be used based on the data analysis needs:

1. Scenario Manager
2. Goal Seek
3. Data Table

#SPJ3