SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 305 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 22 Nov 2017 My Price 10.00

small real estate company in Indianapolis want to analyze sales

Please follow the instructions in the first document to complete the assignment in the second document (excel sheet).

  • EXP ECH01 H4 - Real Estate Sales Report 2.1

     

    Project Description:

    You own a small real estate company in Indianapolis. You want to analyze sales for selected properties. Your assistant prepared a spreadsheet with sales data. You need 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.

     

    Instructions:

    For the purpose of grading the project you are required to perform the following tasks:

    Step

    Instructions

    Points Possible

    1

    Start Excel. Download and open the file named exploring_e01_grader_h4_start.xlsx.

    0.000

    2

    Delete row 8, which has incomplete sales data. The owners took their house off the market.

    5.000

    3

    Enter a formula in cell B5 that calculates the number of days the first house was on the market. Copy the formula to the range B6:B12.

    10.000

    4

    Format the prices in the range E5:F12 with Accounting Number Format with zero decimal places.

    5.000

    5

    Enter a formula in cell G5 that calculates the sales price percentage of the list price for the first house. The first house was listed for $350,000, but it sold for only $335,000. Therefore, the sale percentage of the list price is .9571. Copy the formula to the range G6:G12.

    10.000

    6

    Format the values in the range G5:G12 with Percent Style with two decimal places.

    5.000

    7

    Wrap the headings in the range A4:G4.

    5.000

    8

    Insert a new column between the Date Sold and List Price columns. Move the the Days to Market data to the new blank column E by moving the range B4:B12 to E4:E12.

    4.000

    9

    Apply Align Right and increase the indent two times on the days on market formula results in the range E5:E12.

    5.000

    10

    Delete the empty column B.

    5.000

    11

    Edit the list date of the 41 Chestnut Circle house to be 4/22/2016. Edit the list price of the house on Amsterdam Drive to be $355,000.

    5.000

    12

    Select the property rows (rows 5:12) and set a 20 row height.

    5.000

    13

    Set the Days on Market column width to 9. Set the List Price and Sold Price column widths to 11.86.

    6.000

    14

    Select Landscape orientation and set the scaling to 130%.

    10.000

    15

    Center the data horizontally and vertically on the page.

    10.000

    16

    Insert a footer with the text Exploring Series on the left side, the current date code in the center, and the current time code on the right side.

    10.000

    17

    Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

    0.000

     

    Total Points

    100.000

     

     

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 22 Nov 2017 12:11 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)