Place your order today at a 20% discount

Home>Computer Science homework help

Don't use plagiarized sources. Get Your Custom Essay on
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 select
From Just $13/Page
Order Essay

  
Exp19_Excel_Ch01_ML2_Sales
Exp19 Excel Ch01 ML2 Sales
Excel Chapter 1 Mid-Level 2 – Sales
  
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 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 

     
Start Excel. Download   and open the file named Exp19_Excel_Ch01_ML2_Sales.xlsx.   Grader has automatically added your last name to the beginning of the   filename.
 
The owners of the   house on 386 East Elm Street took their house off the market. You want to delete   that row since it did not sell.  
  Delete row 8, which has incomplete sales data.
 
You want to assign a   property ID to each listing. The code will have the year 2021 with a   sequential number.  
  Type 2021-001 in cell A5 and use Auto Fill to complete the   series to assign a property ID to each property in the range A6:A12.
 
Real estate agents   study the number of days houses are on the market. In some cases, the longer   a house is on the market, it might indicate the asking price is too high.  
  Enter a formula in cell C5 that calculates the number of days the first house   was on the market by subtracting the date listed from the date sold. Copy the   formula to the range C6:C12.
 
Monetary values look   better when they are formatted to display the dollar signs. Because all   monetary values are whole numbers, you will decrease the decimal points to   avoid columns where all the data ends in .00.  
  Format the list prices and sold prices in the range F5:G12 with Accounting   Number Format with zero decimal places.
 
To analyze the real   estate market, it is helpful to calculate the selling prices as a percentage   of the list price. For example, the second house was listed for $500,250, but   it sold for only $400,125. Therefore, the sale percentage of the list price   is .7999 or 79.99%.  
  Enter a formula in cell H5 that calculates the sales price percentage of the   list price for the first house by dividing the sold price by the list price.   Copy the formula to the range H6:H12.
 
The calculated   percentages need to be formatted with the percent symbol rather than   displaying the values as raw numbers.  
  Format the values in the range H5:H12 with Percent Style with two decimal   places.
 
Currently, the labels   on row 4 are hard to read. You will wrap the headings within each cell to   improve readability.  
  Wrap the headings in the range A4:H4.
 
For better sequencing   of columns, you want to display the Days on Market column after the two   columns containing the dates.  
  Insert a new column between the Date   Sold and List Price columns.   Move the Days on Market data to the   new blank column F by moving the range C4:C12 to F4:F12. Delete column C.
 
You notice the list   contains a wrong date and wrong list price that need to be corrected.  
  Edit the list date of the 41 Chestnut   Circle house to be 4/22/2021. Edit the list price of the   house on Amsterdam Drive to be $355,000.
 
Increasing the height   of the rows of data and centering the data vertically between the top and   bottom cell margins will make it easier for the other agents to review the   data.  
  Select the property rows (rows 5:12), set a 25 row height, and apply   Middle Align.
 
Displaying borders   helps separate the property listings.  
  Apply the All Borders border style to the range A4:H12.
 
 
You want to improve   the alignment of number of days on market below the column label.  
  Apply Align Right and increase the indent two times on the days on market   formula results in the range E5:E12.
 
The widths of the   columns containing the Days on Market, List Price, and Sold Price data need   to be adjusted for better appearance.  
  Set the Days on Market column width to 9. Set the List Price and Sold   Price column widths to 11.86.
 
The property listings   dataset is small. To improve readability on the printed copy for the other   real estate agents, you will increase the scaling.  
  Apply 120% scaling.
 
You don’t need the   data on the Properties sheet but you do want to insert another sheet for   formulas.  
  Delete the Properties sheet and insert a new sheet named Formulas.
 
You want to copy the   original data to the new sheet so that you can modify the duplicated data.  
  Use the Select All feature to select all data on the Houses Sold worksheet   and copy it to the Formulas worksheet.
 
 
You do not want to   display the columns containing dates on the new worksheet.  
  Hide the Date Listed and Date Sold columns in the Formulas worksheet.
 
 
You want to review   the formulas within the worksheet and prepare the Formulas sheet to be   printed.  
  Display cell formulas. Set options to print row and column headings. Set 6.86   column width for column E and 6 for column H.
 
You want to apply   page setup options to both sheets, so you need to group the sheets first.  
  Group the two worksheets. Select Landscape orientation. Center the page   horizontally and vertically between the margins.
 
With both worksheets   still grouped, insert a footer with the text Exploring Series on the left side,   the sheet name code in the center, and the file name code on the right side.
 
Save and close Exp19_Excel_Ch01_ML2_Sales.xlsx. Exit   Excel. Submit the file as directed.

hady_Exp19_Excel_Ch01_ML2_Sales.zip

hady_Exp19_Excel_Ch01_ML2_Sales.xlsx

Houses Sold

J. Heaton Realty

Sales Report

Prop ID
Property
Days on Market
Date Listed
Date Sold
List Price
Sold Price
% of List Price

125 Amsterdam Drive

1/12/21
4/12/21
350000
335000

341 North Oak Drive

11/16/20
3/1/21
500250
400125

100 South 325 West

12/3/20
4/30/21
650725
500750

386 East Elm Street

3/1/21

2304 West 39th Street

3/15/21
3/30/21
315000
325000

41 Chestnut Circle

2/22/21
5/18/21
423500
420750

973 East Mulberry Lane

11/30/20
3/1/21
375000
375000

538 North Oak Drive

10/5/20
1/5/21
475000
400000

64 Chancellor Estates

4/1/21
4/15/21
500999
495000

Properties

125 Amsterdam Drive

341 North Oak Drive

100 South 325 West

386 East Elm Street

2304 West 39th Street

41 Chestnut Circle

973 East Mulberry Lane

538 North Oak Drive

64 Chancellor Estates

341 Vintage Road

641 North Vestry

643 North Vestry

43 Chestnut Circle

Exp19_Excel_Ch01_ML2_Sales_Instructions.docx
Grader – Instructions Excel 2019 Project
Exp19_Excel_Ch01_ML2_Sales

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 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.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Excel. Download and open the file named Exp19_Excel_Ch01_ML2_Sales.xlsx. Grader has automatically added your last name to the beginning of the filename.

0

2

The owners of the house on 386 East Elm Street took their house off the market. You want to delete that row since it did not sell. Delete row 8, which has incomplete sales data.

3

3

You want to assign a property ID to each listing. The code will have the year 2021 with a sequential number. Type 2021-001 in cell A5 and use Auto Fill to complete the series to assign a property ID to each property in the range A6:A12.

5

4

Real estate agents study the number of days houses are on the market. In some cases, the longer a house is on the market, it might indicate the asking price is too high. Enter a formula in cell C5 that calculates the number of days the first house was on the market by subtracting the date listed from the date sold. Copy the formula to the range C6:C12.

10

5

Monetary values look better when they are formatted to display the dollar signs. Because all monetary values are whole numbers, you will decrease the decimal points to avoid columns where all the data ends in .00. Format the list prices and sold prices in the range F5:G12 with Accounting Number Format with zero decimal places.

5

6

To analyze the real estate market, it is helpful to calculate the selling prices as a percentage of the list price. For example, the second house was listed for $500,250, but it sold for only $400,125. Therefore, the sale percentage of the list price is .7999 or 79.99%. Enter a formula in cell H5 that calculates the sales price percentage of the list price for the first house by dividing the sold price by the list price. Copy the formula to the range H6:H12.

10

7

The calculated percentages need to be formatted with the percent symbol rather than displaying the values as raw numbers. Format the values in the range H5:H12 with Percent Style with two decimal places.

5

8

Currently, the labels on row 4 are hard to read. You will wrap the headings within each cell to improve readability. Wrap the headings in the range A4:H4.

2

9

For better sequencing of columns, you want to display the Days on Market column after the two columns containing the dates. Insert a new column between the Date Sold and List Price columns. Move the Days on Market data to the new blank column F by moving the range C4:C12 to F4:F12. Delete column C.

5

10

You notice the list contains a wrong date and wrong list price that need to be corrected. Edit the list date of the 41 Chestnut Circle house to be 4/22/2021. Edit the list price of the house on Amsterdam Drive to be $355,000.

5

11

Increasing the height of the rows of data and centering the data vertically between the top and bottom cell margins will make it easier for the other agents to review the data. Select the property rows (rows 5:12), set a 25 row height, and apply Middle Align.

5

12

Displaying borders helps separate the property listings. Apply the All Borders border style to the range A4:H12.

3

13

You want to improve the alignment of number of days on market below the column label. Apply Align Right and increase the indent two times on the days on market formula results in the range E5:E12.

5

14

The widths of the columns containing the Days on Market, List Price, and Sold Price data need to be adjusted for better appearance. Set the Days on Market column width to 9. Set the List Price and Sold Price column widths to 11.86.

5

15

The property listings dataset is small. To improve readability on the printed copy for the other real estate agents, you will increase the scaling. Apply 120% scaling.

2

16

You don’t need the data on the Properties sheet but you do want to insert another sheet for formulas. Delete the Properties sheet and insert a new sheet named Formulas.

5

17

You want to copy the original data to the new sheet so that you can modify the duplicated data. Use the Select All feature to select all data on the Houses Sold worksheet and copy it to the Formulas worksheet.

5

18

You do not want to display the columns containing dates on the new worksheet. Hide the Date Listed and Date Sold columns in the Formulas worksheet.

5

19

You want to review the formulas within the worksheet and prepare the Formulas sheet to be printed. Display cell formulas. Set options to print row and column headings. Set 6.86 column width for column E and 6 for column H.

3

20

You want to apply page setup options to both sheets, so you need to group the sheets first. Group the two worksheets. Select Landscape orientation. Center the page horizontally and vertically between the margins.

7

21

With both worksheets still grouped, insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side.

5

22

Save and close Exp19_Excel_Ch01_ML2_Sales.xlsx. Exit Excel. Submit the file as directed.

0

Total Points

100

Created On: 10/12/2020 1 Exp19_Excel_Ch01_ML2 – Sales 1.2

Exp19_Excel_Ch01_ML2_Sales_final_result.jpg

The assignment 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 select has been handled previously by writers from Wridemy.

About ASAP Essays

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

  

Order your Assignment today and save 15% with the discount code ESSAYHELP

X