I need help

timer Asked: May 1st, 2017

Question description

see the file

Microsoft Excel Final 1. Merge and Center the title Sales Agent Commission Report from A2:D2 Additional Information from F2:G2 2. Apply a bottom border below both of the above titles 3. Center align, and apply bold font style to the field headings A3:G3 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. Use formulas to calculate each agent’s commission in D4:D16. Each agent earns 5% of the total value of bookings. 8. Apply the Accounting number format to D4:D16, and D18 keep two decimal places 9. Center align C4:C16, and C18 10. Apply bold font style to the entire row named Total 11. Apply a Top and Double Bottom Border from B18 to D18 12. Select all the cells in the Additional Information area of the worksheet F2:G5 ; apply the Thick Box Border to the cells. 13. Apply bold font style to all information in cell block F4:G5, center align the information as well. 14. Change the Percentage rates G4:G5 from a decimal to a Percentage number format with two decimal places 15. Calculate the totals for Total Value of Travel Bookings, Number of Cruises Booked, and Commission using the SUM formula, your totals should go in the Total line on the worksheet (Row 18) 16. Calculate the average commission using the AVERAGE formula, maximum commission using the MAX formula, and minimum commission using the MIN formula in the cells adjacent to the appropriate label (D20:D22). Apply the Accounting number style to the cells, leave two decimal spots. 17. Apply coloring to the worksheet. Choose a yellow fill color for the Total line and a blue fill color for the titles in row 2.
First Choice Travel Sales Agent Commission Report Additional Information Sales agent Total value oftravel Number bookings ofcruises Commission booked Number of Shore Percentage Excursions Lopez, D. 72185 1 0 to 4 0,0175 El-Kerdi, S. Fournier, W. Bhayana, M. Mennill, S. Doxtator, V. Redick, L. Ashby, W. De Papp, Q. O'Donovan, R. Karamek, F. Postovic, W. Bistany, W. 61475 31485 52684 23685 34875 22145 63895 57642 37478 61485 72665 52396 5 0 3 1 7 0 5 3 2 8 10 5 5 and over 0,0225 Total Average commission Maximum commission Minimum commission

Tutor Answer

(Top Tutor) Studypool Tutor
School: University of Virginia
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors