place a solid border under the cells in row 11 next use wrap text so that all the columns heading in row 11 are fully visible.

the lab 1 assignment part1

insert Design Layout References Mailings Times New Ro - 12 - A Bru. X. X Font A A. - .A. Labilnstructions (Read-Only] [Compatibility Mode] - Word Review View Font Reader PDF Tell me what you want to do... 2 Label AaBbc AaBbCd AaBbCel AaBbCD AaBbc . . Emphasis Heading Normal Strong Subtitle a Sign in Find - abc Replace Select Editing Paragraph Title Styles Lab Assignment 1 - Functions and Formulas Review Results Part 1 1. Open the Excel file named "Schaffer Real Estate from your elearn course, Select the Sales Commission Sheet tab if it is not already selected 2. The titles in rows 1 and 3 should be bold, 14 point font and centered across columns A though G 3. Input a function in cell BS that will show the current date whenever this file is opened and printed 4. Place a solid border under the cells in tow 11 Next, use wrap text so that all of the columns headings in row 11 are fully visible. Feel free to adjust column widths so the headings display attractively, but don't make columns excessively wide. The final report needs to fit on one page with a reasonable size type. 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 Input a formula into column F, starting with cell F12, to compute each agent's sales commission Commissions are exther 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 Part 2 Select the Home Financing Info tab. On this sheet, you will prepare a worksheet that Realtors can use to show home buyers what their monthly mortgage payment principle and interest only) will be based on the home purchase price, down payment, and interest rate. To get you started, the sheet has data for a home already entered Assume mortgage payments are made at the end of each period 2. Input a formula in cell B12 to compute the loan amount by subtracting the down payment from the purchase price. This formula will need to be an IF function since the down payment can be stated as either a dollar amount or a percentage. If the down payment is a percentage, you will need to convert that percentage into a dollar amount For example, if a client purchases a $200.000 home and is going to put 10% down, the down payment is $20,000 and the loan amount will be $180,000. Format cell B12 to show a S and two decimal places. Input a formula to compute the monthly payment amount in cell B18. Use the PMT function. Remember that the interest rate is an annual interest rate but the EPMT function will need a monthly interest rate to compute a monthly payment. Also, be sure to calculate the total number of monthly payments in the PMT function. The final number should be a positive number. You can achieve this by multiline the PMT function by 1 DO- - A nd 56 PM e X too 10/7/2019 insert Design Layout References Mailings Times New Ro - 12 - A Bru. X. X Font A A. - .A. Labilnstructions (Read-Only] [Compatibility Mode] - Word Review View Font Reader PDF Tell me what you want to do... 2 Label AaBbc AaBbCd AaBbCel AaBbCD AaBbc . . Emphasis Heading Normal Strong Subtitle a Sign in Find - abc Replace Select Editing Paragraph Title Styles Lab Assignment 1 - Functions and Formulas Review Results Part 1 1. Open the Excel file named "Schaffer Real Estate from your elearn course, Select the Sales Commission Sheet tab if it is not already selected 2. The titles in rows 1 and 3 should be bold, 14 point font and centered across columns A though G 3. Input a function in cell BS that will show the current date whenever this file is opened and printed 4. Place a solid border under the cells in tow 11 Next, use wrap text so that all of the columns headings in row 11 are fully visible. Feel free to adjust column widths so the headings display attractively, but don't make columns excessively wide. The final report needs to fit on one page with a reasonable size type. 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 Input a formula into column F, starting with cell F12, to compute each agent's sales commission Commissions are exther 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 Part 2 Select the Home Financing Info tab. On this sheet, you will prepare a worksheet that Realtors can use to show home buyers what their monthly mortgage payment principle and interest only) will be based on the home purchase price, down payment, and interest rate. To get you started, the sheet has data for a home already entered Assume mortgage payments are made at the end of each period 2. Input a formula in cell B12 to compute the loan amount by subtracting the down payment from the purchase price. This formula will need to be an IF function since the down payment can be stated as either a dollar amount or a percentage. If the down payment is a percentage, you will need to convert that percentage into a dollar amount For example, if a client purchases a $200.000 home and is going to put 10% down, the down payment is $20,000 and the loan amount will be $180,000. Format cell B12 to show a S and two decimal places. Input a formula to compute the monthly payment amount in cell B18. Use the PMT function. Remember that the interest rate is an annual interest rate but the EPMT function will need a monthly interest rate to compute a monthly payment. Also, be sure to calculate the total number of monthly payments in the PMT function. The final number should be a positive number. You can achieve this by multiline the PMT function by 1 DO- - A nd 56 PM e X too 10/7/2019