Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Really only need #5 answered but any others are appreciated 5. Schaffer needs to report the total dollar value of all real estate sold each
Really only need #5 answered but any others are appreciated
5. Schaffer needs to report the total dollar value of all real estate sold each month to the local Board of Realtors. Input a formula into the cells in column D, starting with cell D12, that will compute a running total of sales for the month of September. 6. Input a formula into column F, starting with cell F12, to compute each agent's sales commission. Commissions are either 9% or 7% depending on whether the property sold was a commercial or residential property, respectively. These commission rates are included in cells C7 and C8. 7. Total the commissions in column F. Underline cell F25. 8. In column G, compute the sales commission earned on each property as a percentage of the total sales commissions. Also total column G and underline cell G25. 9. Input the appropriate formulas in cells C28,C30, and C32 to compute the indicated statistics. 10. Format all numbers representing dollar amounts for commas and zero decimal places. Add a dollar sign to the first number in each column and totals. 11. Format the numbers in the "\% of Total Commissions" column to show percent signs and one decimal. 12. Use Print Preview and make any changes necessary so the completed Sales Commission worksheet for Schaffer Real Estate would fit on one page when printed. Save your workStep 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