Where is the Data Table option accessed for What-If Analysis?

Where is the Data Table option accessed for What-If Analysis?

• A. Data Ribbon Tab in the Forecast Ribbon Group, What-If Analysis > Data Table
• B. Data > What-If Analysis > Data Table
• C. Review > What-If Analysis > Data Table
• D. Insert > Data Table

Answer: (A)

Access the Data Table option from the Data tab on the Ribbon, within the Forecast group. Open Data, then in the Forecast group choose What-If Analysis and select Data Table. This placement groups What-If Analysis tools with other data tools, making it easy to set up a sensitivity analysis that shows how changing input values affects a formula’s result. You can create either a one-variable or two-variable data table by specifying the row input cell and/or column input cell in the dialog. In some older versions you might see a path like Data > What-If Analysis > Data Table, but in the current layout the Data Table command is accessed through the Forecast group of the Data tab.

Access the Data Table option from the Data tab on the Ribbon, within the Forecast group. Open Data, then in the Forecast group choose What-If Analysis and select Data Table. This placement groups What-If Analysis tools with other data tools, making it easy to set up a sensitivity analysis that shows how changing input values affects a formula’s result. You can create either a one-variable or two-variable data table by specifying the row input cell and/or column input cell in the dialog. In some older versions you might see a path like Data > What-If Analysis > Data Table, but in the current layout the Data Table command is accessed through the Forecast group of the Data tab.