Use the data set named MA Excel Assignment, answer the following questions

• Using a formula, calculate the total cost of each item
• Using a formula, calculate the total selling price of each item if a mark up 15% is put on each item (insert a column to calculate using formula). Calculate the profit of each item
• Which date had the highest sales
• Which date had the least sale
• The total sale of each agent
• The total sale of each region
• If the cost price is increased by 5%, and the selling price remain the same, what will the total profit on each item?
• Calculate the net profit if the selling price of each item is increased by 25%
• What is the most expensive item
• What the least expensive item

Home ETH Fe T 2014 AND SID 15:30 WASHINE A M ave FU 112 Derde av Mecan Tiger HAVE D W PHD FA KH at MEH www. man LLAVE C n Tway BEHAN Ing W Arden M www Ande Ad HOW FO Fo ar www an a www www Pan F arm wwww be baw There Tag www - www Pand www TH Pend Pa and Pand ***** www and Pard Ba que ww Par www. and **** PAM P P H Pand View way. www. w 44 H P 20 19 M 42 - 44 H 11 " " P 19 M P . 14 H P 4 ** 1 19 14 H 14 www. W. M www " 12 H N * F 17 M A 14 saa 25 La AM 481 HO 10 HY 43 ww ww www. *** 129 1240 THE 1.21 wi TH **** ** CAM ww AM HY TR 15 WI *** HY HV HY ME ** ww HI in Ma **** wi WY ww wi.. General ses Excel Assignment 1 dataset C Formatting T Mata Shrajeme BM 47- TIN KHUS Fodk Fr S www Home ETH Fe T 2014 AND SID 15:30 WASHINE A M ave FU 112 Derde av Mecan Tiger HAVE D W PHD FA KH at MEH www. man LLAVE C n Tway BEHAN Ing W Arden M www Ande Ad HOW FO Fo ar www an a www www Pan F arm wwww be baw There Tag www - www Pand www TH Pend Pa and Pand ***** www and Pard Ba que ww Par www. and **** PAM P P H Pand View way. www. w 44 H P 20 19 M 42 - 44 H 11 " " P 19 M P . 14 H P 4 ** 1 19 14 H 14 www. W. M www " 12 H N * F 17 M A 14 saa 25 La AM 481 HO 10 HY 43 ww ww www. *** 129 1240 THE 1.21 wi TH **** ** CAM ww AM HY TR 15 WI *** HY HV HY ME ** ww HI in Ma **** wi WY ww wi.. General ses Excel Assignment 1 dataset C Formatting T Mata Shrajeme BM 47- TIN KHUS Fodk Fr S www