Assignment: (1) You are to have six (6) worksheets (tabs). They are to be named (from right to left): Data, PT, Charts, Sort, Finance and Savings. Please see the Hints near the end of the document for help on this question. Your downloaded data must be in the Data tab. This original data should not be changed. (2) A. On Data, calculate total sales by day (by row; do not combine any rows that have the same dates) and the overall total (use Sum function). Be sure to label all of your calculations (for example, 2A, 2B, etc., at the top of the column where a question is answered is very good). B. Using an if statement, count the number of days sales for Item 1 or Item 2 that are above $100. Please see the Hints section for 2B, C and D on "counting with the Excel if statement". H 1 M N N o Q R s T 185.00 97.00 1 Date 2 2 3 3 4 5 6 7 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 A B D E F G Item 1 Item 2 Item 3 Guitar Amp Kungfu stuff 1/6/20 $203.00 $263.00 $239.00 $205.00 $ 283.00 $ 112.00 8/5/08 $100.00 $293.00 $162.00 $120.00 $ 560.00 $ 273.00 7/29/10 $127.00 $166.00 $166.00 $144.00 $106.00 $ 679.00 $ 88.00 10/10/05 $50.00 $100.00 $80.00 $500.00 $ 100.00 $ 200.00 9/24/08 $138.00 $47.00 $193.00 $103.00 $ 151.00 $ 256.00 10/4/09 $153.00 $101.00 $204.00 $86.00 $ 107.00 $ 532.00 10/30/07 $170.00 $207.00 $107.00 $112.00 $ 1,191.00 $ 60.00 5/6/08 $195.00 $136.00 $110.00 $284.00 $ 135.00 $ 70.00 11/15/10 $158.00 $75.00 $219.00 $231.00 $ 136.00 $ 108.00 8/28/09 $182.00 $179.00 $210.00 $257.00 $ 662.00 $ 52.00 10/2/08 $199.00 $109.00 $44.00 $26.00 $ 965.00 $ 9/10/10 $188.00 $80.00 $152.00 $23.00 $ 346.00 $ 11/2/09 $115.00 $193.00 $291.00 $230.00 $ 466.00 $ 152.00 2/15/11 $114.00 $276.00 $217.00 $293.00 $ 75.00 $ 107.00 3/14/07 $200.00 $111.00 $270.00 $43.00 $ 694.00 $ 42.00 3/1/10 $124.00 $287.00 $253.00 $276.00 $ 42.00 $ 227.00 3/1/08 $119.00 $98.00 $190.00 $119.00 $ 979.00 $ 248.00 5/2/10 $163.00 $217.00 $116.00 $154.00 $ 718.00 $ 102.00 6/16/10 $113.00 $26.00 $197.00 $200.00 $ 309.00 $ 83.00 11/29/06 $174.00 $70.00 $290.00 $300.00 $ 20.00 $ 140.00 5/29/08 $138.00 $144.00 $173.00 $79.00 $ 38.00 $ 176.00 9/1/07 $155.00 $95.00 $116.00 $257.00 $ 835.00 $ 170.00 11/18/06 $129.00 $75.00 $94.00 $163.00 $ 154.00 $ 30.00 5/14/08 $144.00 $116.00 $127.00 $118.00 $ 295.00 $ 148.00 3/12/07 $154.00 $190.00 $285.00 $119.00 $ 836.00 $ 174.00 9/16/07 $123.00 $20.00 $95.00 $ $283.00 $ 129.00 $ 129.00 6/25/10 $184.00 $155.00 $192.00 $248.00 $ 105.00 $ 23.00 4/12/09 $191.00 $261.00 $283.00 $285.00 $ 223.00 $ 257.00 5/22/07 $195.00 $157.00 $183.00 $38.00 $ 759.00 $ 195.00 2/12/09 $173.00 $158.00 $121.00 $169.00 $ 326.00 $ 32.00 4/16/09 $133.00 $98.00 $24.00 $257.00 $ 92.00 $ 85.00 1/3/11 $193.00 $136.00 $241.00 $50.00 $ 178.00 $ 63.00 12/20/08 $157.00 $292.00 $180.00 $93.00 $ 490.00 $ 138.00 3/25/10 $176.00 $126.00 $268.00 $143.00 $ 335.00 $ 159.00 6/18/10 $139.00 $39.00 $67.00 $286.00 $ 301.00 $ 161.00 12/8/07 $189.00 $28.00 $101.00 $125.00 $ 737.00 $ 38.00 5/23/09 $174.00 $247.00 $196.00 $111.00 $ 179.00 $ 194.00 3/20/07 $147.00 $237.00 $209.00 $300.00 $ 12.00 $ 279.00 Assignment: (1) You are to have six (6) worksheets (tabs). They are to be named (from right to left): Data, PT, Charts, Sort, Finance and Savings. Please see the Hints near the end of the document for help on this question. Your downloaded data must be in the Data tab. This original data should not be changed. (2) A. On Data, calculate total sales by day (by row; do not combine any rows that have the same dates) and the overall total (use Sum function). Be sure to label all of your calculations (for example, 2A, 2B, etc., at the top of the column where a question is answered is very good). B. Using an if statement, count the number of days sales for Item 1 or Item 2 that are above $100. Please see the Hints section for 2B, C and D on "counting with the Excel if statement". H 1 M N N o Q R s T 185.00 97.00 1 Date 2 2 3 3 4 5 6 7 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 A B D E F G Item 1 Item 2 Item 3 Guitar Amp Kungfu stuff 1/6/20 $203.00 $263.00 $239.00 $205.00 $ 283.00 $ 112.00 8/5/08 $100.00 $293.00 $162.00 $120.00 $ 560.00 $ 273.00 7/29/10 $127.00 $166.00 $166.00 $144.00 $106.00 $ 679.00 $ 88.00 10/10/05 $50.00 $100.00 $80.00 $500.00 $ 100.00 $ 200.00 9/24/08 $138.00 $47.00 $193.00 $103.00 $ 151.00 $ 256.00 10/4/09 $153.00 $101.00 $204.00 $86.00 $ 107.00 $ 532.00 10/30/07 $170.00 $207.00 $107.00 $112.00 $ 1,191.00 $ 60.00 5/6/08 $195.00 $136.00 $110.00 $284.00 $ 135.00 $ 70.00 11/15/10 $158.00 $75.00 $219.00 $231.00 $ 136.00 $ 108.00 8/28/09 $182.00 $179.00 $210.00 $257.00 $ 662.00 $ 52.00 10/2/08 $199.00 $109.00 $44.00 $26.00 $ 965.00 $ 9/10/10 $188.00 $80.00 $152.00 $23.00 $ 346.00 $ 11/2/09 $115.00 $193.00 $291.00 $230.00 $ 466.00 $ 152.00 2/15/11 $114.00 $276.00 $217.00 $293.00 $ 75.00 $ 107.00 3/14/07 $200.00 $111.00 $270.00 $43.00 $ 694.00 $ 42.00 3/1/10 $124.00 $287.00 $253.00 $276.00 $ 42.00 $ 227.00 3/1/08 $119.00 $98.00 $190.00 $119.00 $ 979.00 $ 248.00 5/2/10 $163.00 $217.00 $116.00 $154.00 $ 718.00 $ 102.00 6/16/10 $113.00 $26.00 $197.00 $200.00 $ 309.00 $ 83.00 11/29/06 $174.00 $70.00 $290.00 $300.00 $ 20.00 $ 140.00 5/29/08 $138.00 $144.00 $173.00 $79.00 $ 38.00 $ 176.00 9/1/07 $155.00 $95.00 $116.00 $257.00 $ 835.00 $ 170.00 11/18/06 $129.00 $75.00 $94.00 $163.00 $ 154.00 $ 30.00 5/14/08 $144.00 $116.00 $127.00 $118.00 $ 295.00 $ 148.00 3/12/07 $154.00 $190.00 $285.00 $119.00 $ 836.00 $ 174.00 9/16/07 $123.00 $20.00 $95.00 $ $283.00 $ 129.00 $ 129.00 6/25/10 $184.00 $155.00 $192.00 $248.00 $ 105.00 $ 23.00 4/12/09 $191.00 $261.00 $283.00 $285.00 $ 223.00 $ 257.00 5/22/07 $195.00 $157.00 $183.00 $38.00 $ 759.00 $ 195.00 2/12/09 $173.00 $158.00 $121.00 $169.00 $ 326.00 $ 32.00 4/16/09 $133.00 $98.00 $24.00 $257.00 $ 92.00 $ 85.00 1/3/11 $193.00 $136.00 $241.00 $50.00 $ 178.00 $ 63.00 12/20/08 $157.00 $292.00 $180.00 $93.00 $ 490.00 $ 138.00 3/25/10 $176.00 $126.00 $268.00 $143.00 $ 335.00 $ 159.00 6/18/10 $139.00 $39.00 $67.00 $286.00 $ 301.00 $ 161.00 12/8/07 $189.00 $28.00 $101.00 $125.00 $ 737.00 $ 38.00 5/23/09 $174.00 $247.00 $196.00 $111.00 $ 179.00 $ 194.00 3/20/07 $147.00 $237.00 $209.00 $300.00 $ 12.00 $ 279.00