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 Communicate Date Listed Date Sold List Worth Sold Worth b of List Worth 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 Communicate Date Listed Date Sold List Worth Sold Worth b of List Worth 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 Retort

     

    Answer:

    2. After 8th grade deleted:

    3. After autofill

    4. Days on communicate calculation: Formula control pristine grade is ‘=E5-D5’. And identical is replicated control other cells.

    5. Accounting calculate controlmat: Chosen “Accounting” discretion below “Format Cell” and regular decimal places to cipher.

    6. List worth percentage: Formula control H5 cell is ‘=G5/F5’ and identical is replicated control other cells.

    7. Percentage controlmat:

    8. Headings wrapped:

    9. Infuseion of strange support:

    10. Date Worth edit:

    11. Grade culmination and intermediate align: Explanation ‘Grade Culmination’ discretion on just click menu to regular grade culmination.

    12. Align just and multitude of “Days on communicate” support:

    14. Support widths of supports:

    15. 120% scaling:

    16. To delete a equivocation, just click on it and chosen ‘Delete’. To infexplanation a strange equivocation, click on + icon in equivocation obstruct. To regular indicate ‘Formulas’ to strangely infuseed equivocation, just click on it and chosen ‘Rename’ discretion and invade strange indicate i.e. ‘Formulas’.

    17. Controlmulas equivocation:

    18. Hidden supports: Just click on support indicate to blink and chosen ‘Hide’.

    19. To spread-out cell controlmula, chosen that cell. Controlmula get be spread-outed in Controlmula pummel. To regular several discretions, explanation Page Layout tab.

    20. To cluster worksheets, remain Shift explanation and click on disturbed equivocations.

    21. To subjoin footer, chosen “Header & Footer” below Infexplanation tab.

    Final properties equivocation:

    J. Heaton Reality
    Sales Report
    Prop ID Property Date Listed Date Sold Days on Communicate List Worth Sold Worth % of List Worth
    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 Controlmulas equivocation:

    J. Heaton Reality
    Sales Report
    Prop ID Property Days on Communicate List Worth Sold Worth % of List Worth
    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