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 .