please provide a detailed accurate answer as soon as possible.

subject is computing skills for management.

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 Item Price Quantity Bulk Buy Discount Class Cost 8 5 Mars Bars TWix Bounty Bar Gazillions Tub Maltesers Walkers Crisps salted Peanuts Chewing Gum Nutella Bar Polo Mints Muesli Bar Maths Test Answers CLASS TOTALS 1.00 41.00 E1.00 150 E1.00 0.75 105 E0.75 2.00 10.50 E200 ES.00 17.55 6 12 1 15 8 5 4 4 1 25 94 Cost Before Discount 8.00 5.00 6.00 E18.00 E1.00 E1125 ER 40 3.75 8.00 2.00 2.00 125.00 E8.00 5.00 6.00 E18.00 E100 11.25 8.40 3.75 E8.00 E2.00 2.00 E125.00 0.00 198.40 Calculate the bulk discount by using the IF function in cell E4, create a nested IF that calculates the correct bulk buy discount percentage. Use this to help you: it quantity >-20 the customer should get 10% of quantity >10 the customer should get 5% Anything less the customer should get no discount Interest Earned Rate Applied If balance > 85000 get 7.5% interest Anything less get 5% interest Deposit Account Balance 62,900.00 13,005.00 87,000.00 54,500.00 94,500.00 120,500.00 85,000.00 33,400.00 17,000.00 107,900.00 If balance >= 85000 message is "High Rate" Anything less message is "Low Rate 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 Item Price Quantity Bulk Buy Discount Class Cost 8 5 Mars Bars TWix Bounty Bar Gazillions Tub Maltesers Walkers Crisps salted Peanuts Chewing Gum Nutella Bar Polo Mints Muesli Bar Maths Test Answers CLASS TOTALS 1.00 41.00 E1.00 150 E1.00 0.75 105 E0.75 2.00 10.50 E200 ES.00 17.55 6 12 1 15 8 5 4 4 1 25 94 Cost Before Discount 8.00 5.00 6.00 E18.00 E1.00 E1125 ER 40 3.75 8.00 2.00 2.00 125.00 E8.00 5.00 6.00 E18.00 E100 11.25 8.40 3.75 E8.00 E2.00 2.00 E125.00 0.00 198.40 Calculate the bulk discount by using the IF function in cell E4, create a nested IF that calculates the correct bulk buy discount percentage. Use this to help you: it quantity >-20 the customer should get 10% of quantity >10 the customer should get 5% Anything less the customer should get no discount Interest Earned Rate Applied If balance > 85000 get 7.5% interest Anything less get 5% interest Deposit Account Balance 62,900.00 13,005.00 87,000.00 54,500.00 94,500.00 120,500.00 85,000.00 33,400.00 17,000.00 107,900.00 If balance >= 85000 message is "High Rate" Anything less message is "Low Rate