4 ITEMS SOLD 2008 2009 2010 2011 Total MAX Amount 5 RAFFLE TICKETS 150 165 145 170 ? ? 6 CANDY 54 65 70 68 ? ? 7 POPCORN 38 41 42 44 ? ? 8 T-SHIRTS 87 92 88 90 ? ? 9 BOOKS 48 46 49 54 ? ? 10 NOTEBOOKS 33 39 45 51 ? ? 11 PENS & PENCILS 23 28 32 36 ? ? 12 TOTALS: ? ? ? ? ? ? 13 14 Average Amount ? ? ? ? 15 Count items ? ? ? ? 16 17 18 19 20 21 22 23 24 25 26 27 28 1. Open Excel and recreate the above spreadsheet so that it looks exactly like the one above. Assignment Instructions: MURPHY JR. HIGH HOME AND SCHOOL RAFFLE- PROFIT STATEMENT 2. Use an Excel function in G5 to calculate the Total for each item sold in C5-F5. Copy formula down to cells G6 to G11. 3. Use an Excel function in H5 to find the Max Amount for each item sold in C5-F5. Copy formula down to cells H6 to H11. 5. Use a formula that will provide totals for cell C12, D12, E12, F12, G12, H12 and I12. 4. Use an Excel function in I5 that will find the Min Amount for each item sold in C5-F5. Copy formula down to cells I6 to I11. 6. Use a formula in cells C14 - F14 that will give the Average of Items sold in 2008, 2009, 2010 and 2011. 7. Use a formula in cells C15 - F15 that will Count items in 2008, 2009, 2010 and 2011. 8. Use any of the standard formatting taught in class to apply to spreadsheet