excel

1. Merge and Center the title Sales Agent Commission Report from A1:D1 and Commission Parameters from F2:G2

2. Apply a bottom border below each title

3. Center align, and apply bold style to the field headings below the titles

4. Apply the Wrap Text feature to cells, B3, C3, and F3

5. Apply a thick bottom border to the field headings (A3:D3)

6. Apply the Accounting number format to B4:B16, and B18 remove all decimal places

7. Apply the Accounting number format to D4:D16, and D18 keep two decimal places

8. Center align C4:C16, and C18

9. Apply bold style to the row named Total

10. Apply a Top and Double Bottom Border from B18 to D18

11. Select all the cells in the Commission Parameters area of the worksheet; apply the All Borders style to these cells. Then with the cells still selected, apply the Thick Box Border to the cells.

12. Apply bold style to all information in Commission Parameters, center align the information as well.

13. Change the commission rates from a decimal to a Percentage number format with two decimal places

14. Use an IF statement and absolute cell addressing to calculate commission rates for the employees

a. Agent commission is paid as a percentage of the total value of travel bookings. The percent paid is based on the number of cruises booked. For example, an agent with 7 cruise bookings receives 2.25% commission on travel bookings whereas an agent with only 2 cruise bookings receives 1.75%

15. Calculate the totals for Total Value of Travel Bookings, Number of Cruises Booked, and Commission using the SUM function, your totals should go in the Total line on the worksheet

16. Calculate the average commission using the AVERAGE function, maximum commission using the MAX function, and minimum commission using the MIN function in the cells adjacent to the appropriate label. Apply the Accounting number style to the cells, leave two decimal spots.

17. Apply all necessary coloring to the worksheet, see the completed example for reference.