Project Description:
You are a real estate analyst who works for Mountain View Realty in the North Utah County area. You have consolidated a list of houses sold during the past few months and want to analyze the data. For a simple analysis, you will outline the data and use the Subtotal feature. You will then create two PivotTables and a PivotChart to perform more in-depth analysis.
Steps to Perform:
Step |
Instructions |
Points Possible |
1 |
Start Excel. Download and open the file named Exp19_Excel_Ch05_ML1_RealEstate.xlsx. Grader has automatically added your last name to the beginning of the filename. |
0 |
2 |
Before subtotaling the data, you want to calculate the selling price as a percentage of the asking price. |
5 |
3 |
Real estate agents often analyze how long houses are on the market. You will calculate the number of days between the listing date and the sale date. |
5 |
4 |
You are about ready to subtotal the data. First, you will sort the data. |
9 |
5 |
You want to display subtotals for three columns to analyze the averages. |
10 |
6 |
Now you are ready to format the data and set a print area to print only a select portion of the worksheet. |
3 |
7 |
Select individually columns G and J and change the column width to 10. Change the row height to 24 for the first row. |
3 |
8 |
Go to cell C101, read the questions, and type the correct answers in the respective highlighted cells in the range G102:G106. Do not copy and paste results from the subtotal rows. Type the numeric values rounded to the nearest whole number. |
5 |
9 |
PivotTables help you analyze different perspectives of data. You will create a PivotTable using the Sales Data worksheet. |
10 |
10 |
Part of the process is arranging and rearranging fields to provide the perspective to represent the data best. In addition, you want to display average values instead of total values. |
9 |
11 |
Now you want to focus on real estate data for only two cities. |
2 |
12 |
Go back to the Sales Data worksheet. You realize that a selling price is incorrect. |
3 |
13 |
You want to format the PivotTable. |
10 |
14 |
You want to create another PivotTable to look at the selling prices by city. |
5 |
15 |
Change the value to display averages not sums. Apply the Accounting Number Format with zero decimal places to the values. Apply Light Blue, Pivot Style Medium 2 to the PivotTable. |
6 |
16 |
You decide to create a PivotChart to illustrate the PivotTable data visually. |
7 |
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme