D5: 2497489
E5: 2614252
F5: 2716008
6 Apply the Currency [ 0 ] cell style to the values in B5: F5.
6.000
Apply the Heading 1 cell style to the years and apply the Heading 4 cell style to the range A5: A6.
7 In cell C6, construct a formula to calculate the percent of
10.000 increase in annual street maintenance costs from 2012 to 2013. Format the result with the Percent Style and then fill the formula through cell F6 to calculate the percent of increase in each year.
8 In cell A8, type Projected Street Maintenance Costs
4.000 and then use Format Painter to copy the formatting from cell A2 to cell A8. Type Projected Increase in cell A10, and then typeYear in cell A12.