9 In cell A13, type Projected Costs and then in the range
6.000
B12: F12, use the fill handle to enter the years 2016 through 2020. Apply Bold to the years. Copy cell F5 and paste to cell B13. Type 6 % in cell B10.
10 To the range A10: B10, apply Bold and Italic. 4.000
11 In cell C13, construct a formula to calculate the annual
6.000 projected street maintenance costs for the year 2017 after the projected increase of 6 %( stored in cell B10) is applied. Fill the formula through cell F13, and then use Format Painter to copy the formatting from cell B13 to the range C13: F13.
12 In cell A15, type Projected Estimates 2016 to 2020
6.000 and then use Format Painter to copy the format from cell A8 to cell A15. In cells A17: A19, type the following row titles:
Year