How does Goal Seek differ from traditional what-if analysis?
Creating a One-Variable Data Table
1.In the upper-left cell of the table,enter a formula that references the input cell.
2.In either the first row or the first column of the table,enter input values.
3.For input values in the first row,enter formulas referencing result cells in the table's first column;for input values in the first column,enter formulas referencing result cells in the table's first row.
4.Select the table (excluding any row or column headings).
5.On the DATA tab,in the Data Tools group,click the What-If Analysis button,and then click Data Table.
6.If the input values are in the first row,enter the cell reference to the input cell in the Row input cell box;if the input values are in the first column,enter the cell reference to the input cell in the Column input cell box.
7.Click the OK button

Question

Quizplus · Accepted Answer

The Answer of How does Goal Seek differ from traditional what-if analysis?
Creating a One-Variable Data Table
1.In the upper-left cell of the table,enter a formula that references the input cell.
2.In either the first row or the first column of the table,enter input values.
3.For input values in the first row,enter formulas referencing result cells in the table's first column;for input values in the first column,enter formulas referencing result cells in the table's first row.
4.Select the table (excluding any row or column headings).
5.On the DATA tab,in the Data Tools group,click the What-If Analysis button,and then click Data Table.
6.If the input values are in the first row,enter the cell reference to the input cell in the Row input cell box;if the input values are in the first column,enter the cell reference to the input cell in the Column input cell box.
7.Click the OK button

How Does Goal Seek Differ from Traditional What-If Analysis