Download the file "Midterm1 B" from Canvas and submit the Excel file, Question 1. - UsePO_1 tab. 1. Use "VLOOKUP" function to apply an appropriate "Commission Rate" for each invoice. (5 points) 2. Calculate "Commission Amount". Commission Amount = Quantity Unit Price Commission Rate ( 5 points) 3. Calculate "Line Total". Line Total = Quantity Unit Price + Commission Amount ( 5 points) 4. Calculate "Total". (5 points) - Use PO_2 tab. 5. Use "Mixed Reference" and calculate the three tiers of discount based on the percentage value in cell D3,E3, and F3. (5 points) Discount Amount = Quantity Unit Price Discount Rate Download the file "Midterm1 B" from Canvas and submit the Excel file, Question 1. - UsePO_1 tab. 1. Use "VLOOKUP" function to apply an appropriate "Commission Rate" for each invoice. (5 points) 2. Calculate "Commission Amount". Commission Amount = Quantity Unit Price Commission Rate ( 5 points) 3. Calculate "Line Total". Line Total = Quantity Unit Price + Commission Amount ( 5 points) 4. Calculate "Total". (5 points) - Use PO_2 tab. 5. Use "Mixed Reference" and calculate the three tiers of discount based on the percentage value in cell D3,E3, and F3. (5 points) Discount Amount = Quantity Unit Price Discount Rate