mountain-view-realty-project-description

Share on facebook
Facebook
Share on google
Google+
Share on twitter
Twitter
Share on linkedin
LinkedIn

Mountain View Realty

Project Description:

You just got an internship at
Mountain View Realty, a real estate firm that focuses in the North Utah County
area. The previous intern developed a spreadsheet listing houses listed and
sold during the last several months. She included addresses, location, list
price, selling price, listing date, and date sold. You need to convert the
data to a table and manipulate the 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

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

0

2

Freeze
the first row (column headers) on the Sales Data worksheet.

3

3

Convert
the data in the range A1:I25 to a table, and then apply the Table Style
Medium 17.

6

4

Remove
duplicate records from the table.

4

5

Insert
a column to the right of the Selling Price field. Name the new field Percent of List Price and
adjust the width of that column to 22.00 (159 pixels).

4

6

Create
a formula with structured references in cell G2 to calculate the percent of
the list price (that is, the selling price divided by the list price).

8

7

Format
the Percent of List Price column (G2:G22) with the Percent number type with
one decimal place.

4

8

Add
a total row to display the average percent of list price and average number
of days on market. Format the average number of days on market as a whole
number. Change the label for the total row to Averages.

13

9

Sort
the table in alphabetical order by the City column. Add a second sorting
level to sort the days on market for each city from largest to smallest.

12

10

Format
the Sales Data worksheet so that the column headings will show on all pages.

5

11

Insert
a page break above row 12 on the Sales Data worksheet. Remove the vertical
page break. Be sure to switch back to Normal view, if necessary.

9

12

On
the Filtered Data worksheet, filter the data to display properties in the
cities of Alpine, Cedar Hills, and Eagle Mountain (column C).

6

13

Filter
the data to display records for houses that were on the market for 30 days
or more.

6

14

Apply
the 3 Arrows (Colored) icon set to the days on market values (J2:J19).

4

15

Apply
the Gradient Fill Light Blue Data Bar conditional formatting to the selling
prices (F2:F19).

4

16

Create
a new conditional format rule that applies Yellow fill (fourth column,
bottom row) and bold font to values that are greater than or equal to 98% in
the Percent of List Price column (G2:G19).

12

17

Ensure
that the worksheets are correctly named and placed in the following order in
the workbook: Sales Data, Filtered Data. Save and close the workbook, and
submit based on your instructor’s directions.

0

Total Points

100

More to explorer

English, Literature & Philology

One of the central concerns with regard to the structuring of this class has been to demonstrate the ways in which histories

Answer:

Title: mountain-view-realty-project-description

This question has been Solved!

Click the button below to order this solution.

Leave a Reply

Your email address will not be published. Required fields are marked *

Open chat