Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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 work

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

T Sql Window Functions For Data Analysis And Beyond

Authors: Itzik Ben Gan

2nd Edition

0135861446, 978-0135861448

More Books

Students also viewed these Databases questions