Unformatted Attachment Preview
Hotel Reps Commission for This Month
Week 3. Assignment 1. Exercise 2
Open the Excel File
1. In cell C4:
a. Create a formula that calculates the commission each salesperson made this month.
2. If you change the commission rate to 15% what is the total commission earned by the
a. Write that value to the right of the data with the following title: 15% Commission.
b. Put a thick outside border around the title and the amount.
3. Rename the title of the data on the spreadsheet from “This Month” to “January”.
4. Sort the data by commission earned from smallest to greatest.
5. In cell C12:
a. Create a formula that calculates the total commission earned in January by all
b. Add a thick line between the amount of commission earned by the highest earning
salesperson and the total commission paid in January.