A B 1 Spending by Age 2 3 Age Groups January 4 7-9 5 10-15 6 16-18 7 18-22 8 22-25 9 Total 10 11 12 13 14 15 16 12 120 98 88 73 61 C D February March 130 70 95 79 65 110 75 92 76 63 April 115 78 102 85 70 F Total G H Percent of Total J K 9. In the sheet Marketing, create sum formulas in Column F and Row 9 to get the totals. (There should be a Grand Total in cell F9.) (10%) 10. In Cell G4 create a percentage of total formula that determines the percentage of 7-9 spending compared to the total amount. (Use only the values in Column F.) Use the absolute reference to effectively copy the formula down for the rest of the Age groups. (10%)