### Free Educational Resources

• > Exploring - Excel Chapter 4: Homework Project 1 Mountain View Realty
+

# Exploring - Excel Chapter 4: Homework Project 1 Mountain View Realty

##### Rating:
(0)
Author: matthew stock
##### Description:

http://homework.plus/exploring-excel-chapter-4-homework-project-1-mountain-view-realty/

Mountain View Realty

Project Description:
A coworker developed a spreadsheet listing houses listed and sold during the past several months. She included addresses, location, list price, selling price, listing date, and date sold. You need to convert the data to a table. You will manage the large worksheet, prepare the worksheet for printing, sort and filter the table, include calculations, and format the table.

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

Instructions

Points Possible

1

0

2

In the Sales Data worksheet, freeze the top row.

5

3

In the Sales Data worksheet, convert the data to a table and apply Table Style Medium 17.

6

4

In the Sales Data worksheet, remove duplicate records in the table.

5

5

In the Sales Data worksheet, insert a new field to the right of the Selling Price field. Name the new field Percent of List Price.

6

6

In the Sales Data worksheet, create a formula in cell E2  with structured references to calculate what percent the selling price is of the list price.Format the field with Percent Style with one decimal place in the range E2:E43.

6

7

In the Sales Data worksheet, insert a new field to the right of the Sale Date field. Name the new field Days on Market. Create a formula with structured references to calculate the number of days on the market.

6

8

In the Sales Data worksheet, add a total row to display the average percent of list price and average number of days on market. Apply the General number format to the average number of days on market. Type Averages in cell A44.

10

9

In the Sales Data worksheet, sort the table by City in alphabetical order and add a second level to sort by Days on Market with the houses on the market the longest at the top within each city.

8

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial