I assistance with the last two Homework tabs. Excel spreadsheet attached. ATTACHMENT PREVIEW Download attachment Excel (HW).xlsx Boomerangs Kites Toys Totals WindSport Summer Sales In Store Sales Web Site Sales Mail Order Sales Totals 22,150.00 43,690.00 57,890.00 123,730.00 137,522.00 151,200.00 43,500.00 332,222.00 17,540.00 14,550.00 27,890.00 59,980.00 177,212.00 209,440.00 129,280.00 515,932.00 Year Sales 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 $91,163 $134,599 $148,414 $138,115 $199,845 $199,185 $122,919 $180,820 $162,194 $249,388 $196,892 $209,926 $355,488 Year Qtr 1 Qtr 2 Qtr 3 Qtr 4 Sales $591,163.00 $734,599.00 $648,414.00 $638,115.00 Qtr Qtr 1 Qtr 2 Qtr 3 Qtr 4 Revenue Expenses $591,163.00 $295,581.50 $734,599.00 $337,915.54 $648,414.00 $330,691.14 $638,115.00 $299,914.05 Sales For Summer 2012 Product Apr Boomerang 1 $14,350.00 Boomerang 2 $10,655.00 Boomerang 3 $17,297.00 Boomerang 4 $17,351.00 Total $59,653.00 May Jun $8,199.00 $11,252.00 $12,620.00 $11,680.00 $12,527.00 $12,503.00 $11,902.00 $11,081.00 $45,248.00 $46,516.00 Jul $9,798.00 $10,866.00 $13,549.00 $18,616.00 $52,829.00 Aug Sep Total $13,393.00 $9,308.00 $66,300.00 $12,125.00 $11,399.00 $69,345.00 $16,495.00 $11,603.00 $83,974.00 $20,687.00 $15,258.00 $94,895.00 $62,700.00 $47,568.00 $314,514.00 1) From the above data make a column, bar and pie chart. For the pie chart show how each boomerang sales total compares to the total sales. Make each chart look good. No Chart Junk. Qtr Qtr 1 Qtr 2 Qtr 3 Qtr 4 Sales $5,000.00 $4,000.00 $6,500.00 $2,500.00 2) From the above data make a chart that shows the trend over the Qtr category. Make each chart look good. No Chart Junk. 3) From the data to the right, make some cell charts (Sparklines). Score Category Test 1 0 up to 20 20 up to 40 40 up to 60 60 up to 80 80 up to 100 Total Test 2 5 10 15 12 12 54 Test 3 5 5 7 20 17 54 10 5 6 15 18 54 Agent Date Listed Area List Price Bedrooms Adams 10/8/2009 Central $199,000 Adams 8/18/2009 Central $214,500 Adams 4/27/2009 Central $265,000 Adams 7/18/2009 Central $268,500 Adams 12/5/2009 Central $273,500 Adams 7/31/2009 Central $309,950 Adams 6/14/2009 Central $325,000 Adams 4/14/2009 N. County $339,900 Adams 5/23/2009 N. County $349,000 Adams 8/7/2009 N. County $379,000 Adams 6/5/2009 N. County $379,900 Adams 4/20/2009 S. County $208,750 Barnes 9/26/2009 N. County $239,900 Barnes 3/13/2009 N. County $264,900 Barnes 3/6/2009 N. County $299,000 Barnes 8/9/2009 N. County $345,000 Barnes 3/21/2009 N. County $350,000 Barnes 6/25/2009 N. County $355,000 Barnes 6/25/2009 S. County $208,750 Bennet 5/11/2009 Central $229,500 Bennet 5/8/2009 Central $549,000 Bennet 6/30/2009 N. County $229,500 Bennet 4/20/2009 N. County $229,900 Bennet 5/26/2009 N. County $229,900 Bennet 6/25/2009 S. County $229,900 Chung 7/7/2009 Central $236,900 Chung 8/26/2009 Central $339,900 Chung 4/20/2009 Central $375,000 Chung 3/21/2009 S. County $205,000 Chung 8/2/2009 S. County $229,500 Chung 9/29/2009 S. County $235,990 Chung 7/4/2009 S. County $239,900 Chung 9/1/2009 S. County $245,000 Chung 10/17/2009 S. County $264,900 Daily 10/2/2009 Central $340,000 Daily 2/19/2009 Central $354,000 Daily 2/24/2009 S. County $204,900 Daily 8/11/2009 S. County $225,911 Daily 9/28/2009 S. County $289,000 Daily 5/18/2009 S. County $360,000 Hamilton 8/28/2009 Central $225,911 Hamilton 5/23/2009 Central $285,000 Hamilton 2/23/2009 N. County $425,900 Hamilton 4/26/2009 S. County $304,900 Jenkins 4/10/2009 Central $319,000 Jenkins 4/21/2009 N. County $238,000 Jenkins 4/8/2009 N. County $248,500 Jenkins 4/30/2009 N. County $349,900 Jenkins 8/28/2009 N. County $1,200,500 Jenkins 3/25/2009 S. County $247,500 Jenkins 5/25/2009 S. County $249,000 Jenkins 3/2/2009 S. County $338,876 Kelly 7/7/2009 Central $309,950 Kelly 10/10/2009 Central $345,000 Kelly 6/8/2009 N. County $389,500 Kelly 9/11/2009 S. County $249,900 Lang 3/7/2009 Central $229,900 Lang 2/25/2009 Central $239,900 Lang 10/13/2009 Central $2