asap! plz

Home Insect Yearly Sales Report Ece Page Layout Formulas Data Review View Help Tell me what you want to do Cabbar 10 - AA aste X Cut Copy Format Pinter Cipboard General BIU -A 29 15 Wrap Tea + Merge & Center $ - % Conditional Format lomatig te fent 5 Mb 0 B D H Sweet Delight Cookie Factory Yearly Sales Report Total Last year Chang Product Butter Pecan Chocolate Chip Chocolate Chunki Double Fudge Four Fruits Maple Oatmeal and Ralsins Strawberry Delight Vanilla Cream Nov 5611 1,033 841 Jan $750 1,300 1.000 950 420 250 980 700 700 5.50 1.000 11.200 Feb $825 1.430 1.100 1,045 462 275 1,071 836 770 Mar $713 1,235 950 903 399 238 931 722 665 Apr $800 1,387 1,067 1,014 448 267 1,046 811 747 May $691 1.198 922 875 387 230 903 700 645 June $776 1.145 1,035 983 435 259 1,014 282 724 Jul $670 1,162 894 849 375 223 876 679 626 Sep 5650 1.127 67 824 364 217 Aug $753 1,305 1,004 954 422 251 34 76 703 Oct $7:30 1.266 974 025 400 Dec 5700 1223 945 191 192 26 20 50 3.600 20 11.000 1,700 210 1024 019 954 740 682 09 60% 16 $81,64) Total Product With Lowest Total Sale Product With Highest otal Sale Sheet1 2. Determine (using formulas and formulas with functions): a) Total Sales/Product b) Total Sales/Month. c) Change (subtract last year's total from this year's total for each product). Apply red font to a negative result. d) Product with the lowest total sales (place result in N18). Apply red font to name of product with lowest total sale. e) Product with the highest total sales (place result in N19). Apply blue font to name of product with highest total sale. 3. Merge and centre rows 1 & 2 over appropriate columns; resave 4. Hide columns B:M