please provide accurate answer as soon as possible.

subject is computing skills for management

this is excel tickshop sales

QUESTION No. 3: Part a: Calculate the bulk discount by using the IF function. In this regard, use the attached file labelled "Excel_Tuckshop Sales". All instructions are explicit. Part b: Open the file attached containing the name "Single IF Interest Rates"; all instructions are explicitly given. Cheeky Charlie's School Tuckbox Sales - Class 4A Sales Co Bull Buy tem Class Cou Discount Mars Bars Twilk Bounty Bar Ganllions Tub Maltesers Wakers Crisp Salted Peanuts Chewing Gum Nutella Bar Polo Mints Muesli Bar Maths Test Answers CLASS TOTALS Price Quantity Before Discount E1.00 B E8.00 E1.00 5 E5.00 6 600 E1.SO 12 E10 F1.00 1 E1.00 ED.75 15 E11 25 ELOS B ER 40 10.75 5 3.75 2.00 ER DO ED:50 4 E2.00 (2.00 1 C200 15.00 25 125.00 E17.55 ER 00 ES 00 55.00 1800 1.00 E11 25 ER 40 3. ERO 12.00 02.00 125.00 0.00 198.40 Calculate the bulk discount by using the function in cell 4, create a nested that calculates the correct bulk buy discount percentage. Use this to help you quantity >20 the customer should get 10% quantity 10 the customer should get 5% Anything less the customer should get no discount QUESTION No. 3: Part a: Calculate the bulk discount by using the IF function. In this regard, use the attached file labelled "Excel_Tuckshop Sales". All instructions are explicit. Part b: Open the file attached containing the name "Single IF Interest Rates"; all instructions are explicitly given. Cheeky Charlie's School Tuckbox Sales - Class 4A Sales Co Bull Buy tem Class Cou Discount Mars Bars Twilk Bounty Bar Ganllions Tub Maltesers Wakers Crisp Salted Peanuts Chewing Gum Nutella Bar Polo Mints Muesli Bar Maths Test Answers CLASS TOTALS Price Quantity Before Discount E1.00 B E8.00 E1.00 5 E5.00 6 600 E1.SO 12 E10 F1.00 1 E1.00 ED.75 15 E11 25 ELOS B ER 40 10.75 5 3.75 2.00 ER DO ED:50 4 E2.00 (2.00 1 C200 15.00 25 125.00 E17.55 ER 00 ES 00 55.00 1800 1.00 E11 25 ER 40 3. ERO 12.00 02.00 125.00 0.00 198.40 Calculate the bulk discount by using the function in cell 4, create a nested that calculates the correct bulk buy discount percentage. Use this to help you quantity >20 the customer should get 10% quantity 10 the customer should get 5% Anything less the customer should get no discount