Question
4. The salespeople for The Edwards Company earn a commission on top of their regular pay if they sell more than $5,000 in a week.
4. The salespeople for The Edwards Company earn a commission on top of their regular pay if they sell more than $5,000 in a week. You have started a worksheet shown below to track sales each week and calculate the commission, if any, earned for that week. Two rows of sample data have been entered to test formulas. Part 1: Write the formulas needed in Cells I7 and J7 to total sales and calculate commission, if any, earned for the week. Use cell references in your formulas, and write them so that they may be copied to Cells I8 through I11 and J8 through J11. Part 2: Write the formula needed in Cell B19 to show the amount of the highest sales for the week, and the formula needed in B20 to show the average sales by salesperson for the week. Part 3: Describe the formatting needed to give the worksheet a professional appearance. Part 4: You know others in your company may have questions about the worksheet, so you want to be sure they know who created it and the purpose of the worksheet. Describe the best way to incorporate this information into your workbook.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started