{"id":108119,"date":"2022-12-04T10:22:06","date_gmt":"2022-12-04T10:22:06","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/exp22_excel_ch01_ml2_sales-computer-science-homework-help\/"},"modified":"2022-12-04T10:22:06","modified_gmt":"2022-12-04T10:22:06","slug":"exp22_excel_ch01_ml2_sales-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/exp22_excel_ch01_ml2_sales-computer-science-homework-help\/","title":{"rendered":"Exp22_excel_ch01_ml2_sales | Computer Science homework help"},"content":{"rendered":"
\n

Excel Chapter 1 Mid-Level 2 – Real Estate Sales Report<\/strong>\u00a0<\/p>\n

Exp22_Excel_Ch01_ML2_Sales<\/strong><\/h2>\n

<\/h2>\n

Exp22 Excel Ch01 ML2 Sales<\/strong><\/h2>\n

\u00a0\u00a0<\/p>\n

Project Description:<\/strong><\/h3>\n

You own a small real estate company in Indianapolis. You track the real estate properties you list for clients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of the list price. In one situation, the house was involved in a bidding war between two families that really wanted the house. Therefore, the sale price exceeded the list price.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

Start Excel. Download and open \u00a0\u00a0the file named Exp22_Excel_Ch01_ML2_Sales.xlsx<\/em>. \u00a0\u00a0Grader has automatically added your last name to the beginning of the \u00a0\u00a0filename.<\/p>\n

\u00a0<\/p>\n

The owners of the house on 640 North Oak Drive<\/em> took their house \u00a0\u00a0off the market. You want to delete that row since it did not sell.
\u00a0<\/p>\n

\u00a0\u00a0In the April worksheet, delete row 10, which has incomplete sales data.<\/p>\n

\u00a0<\/p>\n

The listings are organized by \u00a0\u00a0date listed. The 973 East Mulberry Lane<\/em> \u00a0\u00a0listing needs to be moved up in the list.
\u00a0<\/p>\n

\u00a0\u00a0Select and cut row 13 and insert cut cells on row 10.<\/p>\n

\u00a0<\/p>\n

You want to assign a property ID \u00a0\u00a0to each listing. The code will have the year 2024 with a sequential number.
\u00a0<\/p>\n

\u00a0\u00a0Type 2024-001<\/strong> in cell A5 and use Auto Fill to \u00a0\u00a0complete the series to assign a property ID to each property in the range \u00a0\u00a0A6:A13.<\/p>\n

\u00a0<\/p>\n

Real estate agents study the \u00a0\u00a0number of days houses are on the market. In some cases, the longer a house is \u00a0\u00a0on the market, it might indicate the asking price is too high.
\u00a0<\/p>\n

\u00a0\u00a0Enter a formula in cell C5 that calculates the number of days the first house \u00a0\u00a0was on the market by subtracting the date listed from the date sold. Copy the \u00a0\u00a0formula to the range C6:C13.<\/p>\n

\u00a0<\/p>\n

Monetary values look better when \u00a0\u00a0they are formatted to display the dollar signs. Because all monetary values \u00a0\u00a0are whole numbers, you will decrease the decimal points to avoid columns \u00a0\u00a0where all the data ends in .00.
\u00a0<\/p>\n

\u00a0\u00a0Format the list prices and sold prices in the range F5:G13 with Accounting \u00a0\u00a0Number Format with zero decimal places.<\/p>\n

\u00a0<\/p>\n

To analyze the real estate \u00a0\u00a0market, it is helpful to calculate the selling prices as a percentage of the \u00a0\u00a0list price. For example, the second house was listed for $500,250, but it \u00a0\u00a0sold for only $400,125. Therefore, the sale percentage of the list price is \u00a0\u00a0.7999 or 79.99%.
\u00a0<\/p>\n

\u00a0\u00a0Enter a formula in cell H5 that calculates the sales price percentage of the \u00a0\u00a0list price for the first house by dividing the sold price by the list price. \u00a0\u00a0Copy the formula to the range H6:H13.<\/p>\n

\u00a0<\/p>\n

The calculated percentages need \u00a0\u00a0to be formatted with the percent symbol rather than displaying the values as \u00a0\u00a0raw numbers.
\u00a0<\/p>\n

\u00a0\u00a0Format the values in the range H5:H13 with Percent Style with two decimal \u00a0\u00a0places.<\/p>\n

\u00a0<\/p>\n

Currently, the labels on row 4 \u00a0\u00a0are hard to read. You will wrap the headings within each cell to improve \u00a0\u00a0readability.
\u00a0<\/p>\n

\u00a0\u00a0Center horizontally and wrap the headings in the range A4:H4.<\/p>\n

\u00a0<\/p>\n

For better sequencing of \u00a0\u00a0columns, you want to display the Days on Market column after the two columns \u00a0\u00a0containing the dates.
\u00a0<\/p>\n

\u00a0\u00a0Insert a new column between the Date \u00a0\u00a0Sold <\/em>and List Price <\/em>columns. \u00a0\u00a0Move the Days on Market <\/em>data to the \u00a0\u00a0new blank column F by moving the range C4:C13 to F4:F13. Delete column C.<\/p>\n

\u00a0<\/p>\n

You notice the list contains a \u00a0\u00a0wrong date and wrong list price that need to be corrected.
\u00a0<\/p>\n

\u00a0\u00a0Edit the date sold of the 41 Chestnut \u00a0\u00a0Circle <\/em>house to be 4\/22\/2024<\/strong>.<\/p>\n

\u00a0<\/p>\n

Increasing the height of the \u00a0\u00a0rows of data and centering the data vertically between the top and bottom \u00a0\u00a0cell margins will make it easier for the other agents to review the data.
\u00a0<\/p>\n

\u00a0\u00a0Select the property rows (rows 5:13), set a 25 <\/strong>row height, and apply Middle Align.<\/p>\n

\u00a0<\/p>\n

Displaying borders helps separate \u00a0\u00a0the property listings.
\u00a0<\/p>\n

\u00a0\u00a0Apply the All Borders border style to the range A4:H13.<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

You want to improve the \u00a0\u00a0alignment of number of days on market below the column label.
\u00a0<\/p>\n

\u00a0\u00a0Apply Align Right and increase the indent two times on the days on market formula \u00a0\u00a0results in the range E5:E13.<\/p>\n

\u00a0<\/p>\n

You noticed some misspelled \u00a0\u00a0words in the worksheet.
\u00a0<\/p>\n

\u00a0\u00a0Use Excel to check the spelling and correct misspelled words.<\/p>\n

\u00a0<\/p>\n

You don’t need the data on the \u00a0\u00a0Properties sheet but you do want to copy the April worksheet to create a \u00a0\u00a0template for May.
\u00a0<\/p>\n

\u00a0\u00a0Delete the Properties sheet. Insert a new sheet named May<\/strong>. Make sure the May sheet is the \u00a0\u00a0second sheet tab.<\/p>\n

\u00a0<\/p>\n

You want to copy the original \u00a0\u00a0data to the new sheet so that you can modify the duplicated data.
\u00a0<\/p>\n

\u00a0\u00a0Use the Select All feature to select all data on the April worksheet and copy \u00a0\u00a0it to the May worksheet. Use the paste option to Keep Source Column Widths.<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

After copying data from the \u00a0\u00a0April worksheet to the May worksheet, you want to prepare the May worksheet \u00a0\u00a0for data.
\u00a0<\/p>\n

\u00a0\u00a0In cell A2, change April<\/em> to May<\/strong>. Select the ranges A5:D13 and \u00a0\u00a0F5:G13 and clear cell contents but keep the formatting In cell F5, type 1<\/strong>. In cell G5, type 1<\/strong>. Copy the values to the range \u00a0\u00a0F6:G13.<\/p>\n

\u00a0<\/p>\n

The property listings dataset is \u00a0\u00a0small. To improve readability on the printed copy for the other real estate \u00a0\u00a0agents, you will increase the scaling.
\u00a0<\/p>\n

\u00a0\u00a0Select both worksheets and apply 120% scaling.<\/p>\n

\u00a0<\/p>\n

You want to apply page setup \u00a0\u00a0options to both sheets, so you need to group the sheets first.
\u00a0<\/p>\n

\u00a0\u00a0Select both worksheets. Select Landscape orientation. Center the page \u00a0\u00a0horizontally and vertically between the margins.<\/p>\n

\u00a0<\/p>\n

With both worksheets still \u00a0\u00a0selected, insert a footer with the text Exploring Series<\/strong> on the left side, the sheet \u00a0\u00a0name code in the center, and the file name code on the right side.<\/p>\n

\u00a0<\/p>\n

Save and close Exp22_Excel_Ch01_ML2_Sales.xlsx<\/em>. Exit \u00a0\u00a0Excel. Submit the file as directed.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Excel Chapter 1 Mid-Level 2 – Real Estate Sales Report\u00a0 Exp22_Excel_Ch01_ML2_Sales Exp22 Excel Ch01 ML2 Sales \u00a0\u00a0 Project Description: You own a small real estate company in Indianapolis. You track the real estate properties you list for clients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-108119","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/108119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=108119"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/108119\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=108119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=108119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=108119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}