Employees of the Pro Shop earn commission on total daily sales. The rate they earn depends...

Transcribed Image Text:

Employees of the Pro Shop earn commission on total daily sales. The rate they earn depends on the amount of revenue they generate. However, Assistant Managers get a flat commission rate regardless of the amount of revenue. On the EmployeeAnalysis worksheet, in cell D23, enter a formula that will return values based on the following: Return 0.05 for employees who have a job title of Asst Manager. For all other employees, use a XLOOKUP function to retrieve the appropriate rate from the CommmisionRates table based on the Total Revenue value for the employees who are not Asst Managers. Multiply the rate by the Total Revenue to calculate the commission amount earned for each employee. Use the fill handle to copy the formula down through D27. Employees of the Pro Shop earn commission on total daily sales. The rate they earn depends on the amount of revenue they generate. However, Assistant Managers get a flat commission rate regardless of the amount of revenue. On the EmployeeAnalysis worksheet, in cell D23, enter a formula that will return values based on the following: Return 0.05 for employees who have a job title of Asst Manager. For all other employees, use a XLOOKUP function to retrieve the appropriate rate from the CommmisionRates table based on the Total Revenue value for the employees who are not Asst Managers. Multiply the rate by the Total Revenue to calculate the commission amount earned for each employee. Use the fill handle to copy the formula down through D27.