B D E F G H ! J L M N 1 NO Brand Le Reve Rich Men Cats Eye Infinity Arong Other Brand Discount Table for EID Bkash Upay Ipay Rocket 10% 35% 20% 10% 20% 20% 20% 10% 10% 20% 20% 10% 10% 20% 20% 10% 20% 20% 20% 10% 10% Others 2% 2% 2% 2% 2% 10 11 12 13 14 Vat Table Made in Bangladesh Made by other countries 2% 5% 15 16 17 18 19 20 21 22 23 24 25 26 27 Customer Item Miss Pori Tops Miss Pori Kurti Miss Pori Skirt Miss.Zorina Jeans Miss.Zorina Skirt Miss.Zorina Shoe Mr.Hero Shoe Mr. Hero Shirt Mrs.Kuddus Tie Mr.Kuber Pant Mr. Sakib Punjabi Mrs.Sakib Shari Brand Color Rong Red Arong Green Infinity Pink Le Reve Red-Blue Shada kalo B&W Apex Black Bay Black Cats Eye Black Cats Eye B&W Cats Eye Black Le Reve Green Le Reve Green Made in BD BD BD Thiland BD BD China India China India BD BD Payment Mode Bkash Bkash Bkash Ipay Ipay Ipay Ipay Cash Visa Visa Upay Upay Unit Price 2000 3000 1000 2000 2000 5000 2000 2000 1000 1800 5000 10000 Qty 1 2 2 1 1 2 4 2 1 Sub Total 2000 6000 2000 2000 2000 10000 8000 4000 1000 3600 5000 10000 NET Vat Discount Total 40 200 1840 120 600 5520 40 100 1940 100 700 1400 40 40 2000 200 100 10100 400 40 8360 200 400 3800 50 200 850 180 360 3420 100 1000 4100 200 2000 8200 Study the segment of a sales report of a sales report of "ABC Online Store" in the image above. Assume that you are hired as a sales analyst to find the following questions considering the above- mentioned tables and conditions. 1. What is the correct Excel formula for Cell M16....M27 to calculate the net discount. 2. What is the correct Excel formula for Cell L16.....L27 to calculate the net vat. 3. Write a formula to find out total Discount for Bangladeshi made Shirts. What is the correct Excel formula for Cell N16....N27 to calculate the Net Total Price. 4. B D E F G H ! J L M N 1 NO Brand Le Reve Rich Men Cats Eye Infinity Arong Other Brand Discount Table for EID Bkash Upay Ipay Rocket 10% 35% 20% 10% 20% 20% 20% 10% 10% 20% 20% 10% 10% 20% 20% 10% 20% 20% 20% 10% 10% Others 2% 2% 2% 2% 2% 10 11 12 13 14 Vat Table Made in Bangladesh Made by other countries 2% 5% 15 16 17 18 19 20 21 22 23 24 25 26 27 Customer Item Miss Pori Tops Miss Pori Kurti Miss Pori Skirt Miss.Zorina Jeans Miss.Zorina Skirt Miss.Zorina Shoe Mr.Hero Shoe Mr. Hero Shirt Mrs.Kuddus Tie Mr.Kuber Pant Mr. Sakib Punjabi Mrs.Sakib Shari Brand Color Rong Red Arong Green Infinity Pink Le Reve Red-Blue Shada kalo B&W Apex Black Bay Black Cats Eye Black Cats Eye B&W Cats Eye Black Le Reve Green Le Reve Green Made in BD BD BD Thiland BD BD China India China India BD BD Payment Mode Bkash Bkash Bkash Ipay Ipay Ipay Ipay Cash Visa Visa Upay Upay Unit Price 2000 3000 1000 2000 2000 5000 2000 2000 1000 1800 5000 10000 Qty 1 2 2 1 1 2 4 2 1 Sub Total 2000 6000 2000 2000 2000 10000 8000 4000 1000 3600 5000 10000 NET Vat Discount Total 40 200 1840 120 600 5520 40 100 1940 100 700 1400 40 40 2000 200 100 10100 400 40 8360 200 400 3800 50 200 850 180 360 3420 100 1000 4100 200 2000 8200 Study the segment of a sales report of a sales report of "ABC Online Store" in the image above. Assume that you are hired as a sales analyst to find the following questions considering the above- mentioned tables and conditions. 1. What is the correct Excel formula for Cell M16....M27 to calculate the net discount. 2. What is the correct Excel formula for Cell L16.....L27 to calculate the net vat. 3. Write a formula to find out total Discount for Bangladeshi made Shirts. What is the correct Excel formula for Cell N16....N27 to calculate the Net Total Price. 4