Forecast data by using data tables

Open the DefineDataTables workbook in Excel, and then perform the following tasks:

On the Ratelncreases worksheet, select cells C$4$:D$7.$

Perform the steps to create a data table in cells $D5$:$D7,$ entering $B5$ as the

Column input cell. Review the resulting data.

On the RateAndVolume worksheet, select cells D$4$:F$8.$

Perform the steps to create a data table in cells $E5$:$F8,$ entering $B6$ as the Row

input cell and B $5$ as the Column input cell. Review the resulting data.