DIRECTIONS: 25. Download & upload the fundrevenue file. 26. Resize Rows 1 and 2 if you need to. 27. Type your name into Cell A12 28. Type the word Fund in Cell A3 29. Find the % of Total Projected Budget in Column D by using an absolute reference in your formula. Format it with Percent Signs. 30. Copy the formula down Column D. 31. Create a 2-D Line Chart to depict the Revenue for Current Year from each of the Sources (Columns A and B). Move the chart below the spreadsheet. 32. Print a PDF of the finished work. Use the file name, Fund Revenue, followed by your first and last name. % of Total Projected Budget 1 General Fund Revenue Sources 2 Projection for Next Fiscal Year Budget Projected Current Year Revenue for Next Revenue 3 Fiscal Year 4 Sales Tax $ 45,109,800 $ 47,139,470 5 State and Federal Taxes 42,487,500 43,988,500 6 Utility Taxes 38,205,050 43,678,420 7 Property Tax 52,552,050 55,669,125 8 Permits and Services 28,070,250 29,040,120 9 Investments 31,258,750 31,997,560 70 Total $ 237,683,400 $ 251,513,195 11 12 13 14 15 16 17 18 19 20 21