Homework Solution: J. Heaton Realty Sales Report Prop ID Property Days on Market Date Listed Date Sold List Price Sold Price b…

    J. Heaton Realty Sales Report Prop ID Property Days on Market Date Listed Date Sold List Price Sold Price b of List Price 1/12/184/12/18 350000 335000 11/15/173/1/18 500250 400125 12/3/174/30/18650725 500750 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 3/14/18 3/30/18 315000 325000 2/22/185/18/18423500 420750 11/30/173/1/18375000 375000 10/4/171/5/18 475000 400000 4/1/184/15/18500999495000
    J. Heaton Realty Sales Report Prop ID Property Days on Market Date Listed Date Sold List Price Sold Price b of List Price 1/12/184/12/18 350000 335000 11/15/173/1/18 500250 400125 12/3/174/30/18650725 500750 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 3/14/18 3/30/18 315000 325000 2/22/185/18/18423500 420750 11/30/173/1/18375000 375000 10/4/171/5/18 475000 400000 4/1/184/15/18500999495000

    Expert Answer

     
    Answer: 2. After 8th row deleted:

    J. Heaton Realty Sales Report Prop ID Property Days on Market Date Listed Date Sold List Figure Sold Figure b of List Figure 1/12/184/12/18 350000 335000 11/15/173/1/18 500250 400125 12/3/174/30/18650725 500750 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 3/14/18 3/30/18 315000 325000 2/22/185/18/18423500 420750 11/30/173/1/18375000 375000 10/4/171/5/18 475000 400000 4/1/184/15/18500999495000

    J. Heaton Realty Sales Report Prop ID Property Days on Market Date Listed Date Sold List Figure Sold Figure b of List Figure 1/12/184/12/18 350000 335000 11/15/173/1/18 500250 400125 12/3/174/30/18650725 500750 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 3/14/18 3/30/18 315000 325000 2/22/185/18/18423500 420750 11/30/173/1/18375000 375000 10/4/171/5/18 475000 400000 4/1/184/15/18500999495000

    Expert Response

     

    Answer:

    2. After 8th grade deleted:

    3. After autofill

    4. Days on market calculation: Formula ce primeval grade is ‘=E5-D5’. And corresponding is replicated ce other cells.

    5. Accounting calculate cemat: Picked “Accounting” discretion beneath “Format Cell” and firm decimal places to cipher.

    6. List figure percentage: Formula ce H5 cell is ‘=G5/F5’ and corresponding is replicated ce other cells.

    7. Percentage cemat:

    8. Headings wrapped:

    9. Instilion of odd shaft:

    10. Date Figure edit:

    11. Grade climax and average align: Verification ‘Grade Climax’ discretion on fair click menu to firm grade climax.

    12. Align fair and dispersion of “Days on market” shaft:

    14. Shaft widths of shafts:

    15. 120% scaling:

    16. To delete a fencing, fair click on it and picked ‘Delete’. To instil a odd fencing, click on + icon in fencing halt. To firm indicate ‘Formulas’ to oddly instiled fencing, fair click on it and picked ‘Rename’ discretion and penetrate odd indicate i.e. ‘Formulas’.

    17. Cemulas fencing:

    18. Hidden shafts: Fair click on shaft indicate to disguise and picked ‘Hide’.

    19. To spread-out cell cemula, picked that cell. Cemula allure be spread-outed in Cemula box. To firm sundry discretions, verification Page Layout tab.

    20. To collection worksheets, obstruct Shift explanation and click on unquiet fencings.

    21. To append footer, picked “Header & Footer” beneath Instil tab.

    Final properties fencing:

    J. Heaton Reality
    Sales Report
    Prop ID Property Date Listed Date Sold Days on Market List Figure Sold Figure % of List Figure
    2018-001 125 Amsterdam Drive 12-01-18 12-04-18 90 $        355,000 $        335,000 94.37%
    2018-002 341 North Oak Drive 15-11-17 01-03-18 106 $        500,250 $        400,125 79.99%
    2018-003 100 South 325 West 03-12-17 30-04-18 148 $        650,725 $        500,750 76.95%
    2018-004 2304 West 39th Street 14-03-18 30-03-18 16 $        315,000 $        325,000 103.17%
    2018-005 41 Chestnut Circle 22-04-18 18-05-18 26 $        423,500 $        420,750 99.35%
    2018-006 973 East Mulberry Lane 30-11-17 01-03-18 91 $        375,000 $        375,000 100.00%
    2018-007 538 North Oak Drive 04-10-17 05-01-18 93 $        475,000 $        400,000 84.21%
    2018-008 64 Chancellor Estates 01-04-18 15-04-18 14 $        500,999 $        495,000 98.80%

    Final Cemulas fencing:

    J. Heaton Reality
    Sales Report
    Prop ID Property Days on Market List Figure Sold Figure % of List Figure
    2018-001 125 Amsterdam Drive 90 $ 355,000 $ 335,000 94.37%
    2018-002 341 North Oak Drive 106 $ 500,250 $ 400,125 79.99%
    2018-003 100 South 325 West 148 $ 650,725 $ 500,750 76.95%
    2018-004 2304 West 39th Street 16 $ 315,000 $ 325,000 103.17%
    2018-005 41 Chestnut Circle 26 $ 423,500 $ 420,750 99.35%
    2018-006 973 East Mulberry Lane 91 $ 375,000 $ 375,000 100.00%
    2018-007 538 North Oak Drive 93 $ 475,000 $ 400,000 84.21%
    2018-008 64 Chancellor Estates 14 $ 500,999 $ 495,000 98.80