4. Build the data table. Select cell E18. It refers to cell H5, projected sales next year. Cells F18 and G18 refer to cells H6 and H7, respectively. a. b. C. Fill the growth rate percentages in cells D21:D28. Complete the data table range using cell B12 as the column input. The results are incorrect, because data table formulas must refer to data on the same worksheet. 5. Edit formulas to use a reference on the same sheet as the data table. a. Select cell E18 and click the Trace Precedents button [Formulas tab, Formula Auditing group]. b. Click the Trace Precedents button again to trace precedents of the precedent (Figure 9-113). The formulas in row 18 indirectly refer to cell D5 with its reference to Growth Factors!$C$3. A data table cannot use data on a different sheet. 40