#3 . Due date: Thursday 7th of January 2021 by 11:59 p.m. Work INDIVIDUALLY. No group work is accepted. Stick to deadlines! Late submissions will not be accepted; no exceptions! Upload your solution on the PSUT E-Learning Gateway, don't send it by Email. Download the attached excel worksheet that contains the sales of a company. 1. In column I calculate the "Total Price" as the following: Total Price= Units Sold* Unit Price. 2. In column J find the "Total Cost" as the following: Total Cost Units Sold* Unit Cost. 3. In column K find the Discounts as follow: a. Discounts is 5% for Total Price less than 500. b. Discounts is 10% for Total Price less than 5000. c. Discounts is 15% otherwise. 4. In column L find the "Total Profit" as the following: Total Profit= Total price-Discount-Total Cost 5. Color the column L depending on total profit value. Green for profit larger than 10000, Yellow for profit larger 1000 and less than 10000 and blue for profit larger than 0 and less than 1000, and Red for profit less than 0. 6. In Column M, extract the month number from the Date in column D. 7. In Column N, convert the month number to month name using the table Q1:R16. 8. In Column O, extract the Year from the Date in column D. 9. In cell R20, find the Number of Total Sales that have total prices greater than 10,000. 10. In cell R21, find the total unit sold in the "Europe" region. 11. In cell R22, find the average discount. 12. Using Pivot table, find the average sales for each region in the first 6 months of 2020 (Use slicer for filtering). 13. Copy the Sales sheet to a new sheet and name it "Sorted sales". In the new sheet, sort the data base on the year column in ascending order, then based on the month name (from January to December). 4:45