Page 665 - Excel 2013 All-in-One For Dummies

Using Data Tables 647
Figure 1-1:
Creating a one-variable data table.
But what if the growth rate in 2014 is not as low as 1.75%, or what if the growth rate is even (heaven forbid) lower than anticipated? To create the one-variable table to answer these questions, you first bring forward the master formula in cell B5 to cell C7 with the formula =B5. Then, you enter the series of different growth rates as the input values in column B, starting in cell B8. (Cell B7, at the intersection of the row with the master formula and the column with the input values, must be left blank in a one-variable data table.) This series of input values for the data table can be created with the AutoFill feature. (See Book II, Chapter 1 for details.) In this example, a data series that increments each succeeding value by 0.25% percent is created in the cell range B8:B17, starting at 1 percent and ending at 3.25% percent.
After bringing the formula in cell B5 forward to cell C7 with the formula =B5 and generating the growth rate series in the cell range B8:B17, you then select the cell range B7:C17 and click the What-If Analysis command button in the Data Tools group on the Data tab and then click Data Table on its drop-down menu (or press Alt+AWT) to open the Data Table dialog box shown in Figure 1-1.
In this dialog box, you specify the row input cell in the Row Input Cell text box and/or the column input cell in the Column Input Cell text box. The cell that you designate as the row or column input cell in the Table dialog box must correspond to the cell in the worksheet that contains the original input value that is fed into the master formula.
Book VII Chapter 1
Performing What-If Scenarios