61-90 25% Q1. [CLO-K1.2] Format the following table in Compute the following (Use appropriate functions like. SUM).IFO. SUMIFO). COUNTIF(). TODAYO 1. Insert or add two columns to compute daysto expiry and discount rate after Expiry Date. 2 Days to Expiry Current date - Expiry Date 1. Discount Rate Compute discount rate on the following criteria (condition) Days to Expiry Discount Rate You may use equivalent value 25% 0.25 31-60 50% Similarly 50%-0.5 0-30 3. Amount - Qty ItemPrice 3. Discount Amount = Discount Rate Amount (use IF) to find discount rate as per above table) 4. Net Amount = Amount-Discount Amount 5. Prepare a Summary Report to calculate category wise total items and total discount amountusing spreading functions 75% Abu Ahmed Trading Company Yanbu Item Category A Oty 10 Discount Amount Amount Net Amount Item Name HL-01 HL-02 HL-03 HL-04 18 15 Item Price 34.5 12.5 300.50 20.25 B 10 Expiry Date 12/30/2020 1/9/2021 12/10/2020 12/12/2020 12/15/2020 11/10/2020 11/12/2020 10/31/2020 11/5/2020 HL-05 olm 16 50 32 320 324.75 45.25 HL-06 HL-07 HL-08 HL-09 A 25 26 47 50 25 25 SUMMARY REPORT Category Wise Total Items and Total Discount Amount TOTAL Items Discount Amount Category Net Amount B