4. On the sheet of 2016 Orders, complete the following tasks. a. Make of list on the entire dataset. b. Sort the dataset by Product first and then by Region. (Other idea: By Salesperson first and then by Month) c. Add a column at the right of Product. Name it Price. Use vLookup function to pull product prices from the sheet Income Statements (D4:D7) and show prices for all orders. d. Add a column at the right of Unit. Name it Total. The order totals = Price * Unit. e. At the right of Total, add a column called Discount. Use a nested If function to decide the discounts. The company gives 10% discount to all orders from the West region, and the other regions only enjoy 10% discount in December. f. At the right of Discount, add a column called Totalw/Dis. It is the order totals – discounts. g. In cell L2, use the AVERAGE function to calculate the average number of units sold from the column Unit. Next, use conditional formatting tool and highlight the orders with unit sold greater than average unit sold. Select the green fill and dark green text color option if the cells meet this rule.