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 |
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 |
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 |
EXP ECH01 H4 – Real Estate Sales Report 2.1
EXP ECH01 H4 – Real Estate Sales Report 2.1EXP ECH01 H4 – Real Estate Sales Report 2.1EXP ECH01 H4 – Real Estate Sales Report 2.1
Project Description:
Project Description: Project Description: 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.
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.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.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:
Instructions: Instructions: Instructions:
For the purpose of grading the project you are required to perform the following tasks:
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 |
Step
Instructions
Points Possible
Step
Instructions
Points Possible
Step
Step
StepStepStep
Instructions
Instructions
InstructionsInstructionsInstructions
Points Possible
Points Possible
Points PossiblePoints PossiblePoints 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
1
Start Excel. Download and open the file named exploring_e01_grader_h4_start.xlsx.
0.000
1
1
111
Start Excel. Download and open the file named exploring_e01_grader_h4_start.xlsx.
Start Excel. Download and open the file named exploring_e01_grader_h4_start.xlsx.
Start Excel. Download and open the file named exploring_e01_grader_h4_start.xlsx.exploring_e01_grader_h4_start.xlsx
0.000
0.000
0.000
2
Delete row 8, which has incomplete sales data. The owners took their house off the market.
5.000
2
2
222
Delete row 8, which has incomplete sales data. The owners took their house off the market.
Delete row 8, which has incomplete sales data. The owners took their house off the market.
Delete row 8, which has incomplete sales data. The owners took their house off the market.
5.000
5.000
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
3
3
333
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.
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.
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
10.000
10.000
4
Format the prices in the range E5:F12 with Accounting Number Format with zero decimal places.
5.000
4
4
444
Format the prices in the range E5:F12 with Accounting Number Format with zero decimal places.
Format the prices in the range E5:F12 with Accounting Number Format with zero decimal places.
Format the prices in the range E5:F12 with Accounting Number Format with zero decimal places.
5.000
5.000
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
5
5
555
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.
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.
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
10.000
10.000
6
Format the values in the range G5:G12 with Percent Style with two decimal places.
5.000
6
6
666
Format the values in the range G5:G12 with Percent Style with two decimal places.
Format the values in the range G5:G12 with Percent Style with two decimal places.
Format the values in the range G5:G12 with Percent Style with two decimal places.
5.000
5.000
5.000
7
Wrap the headings in the range A4:G4.
5.000
7
7
777
Wrap the headings in the range A4:G4.
Wrap the headings in the range A4:G4.
Wrap the headings in the range A4:G4.
5.000
5.000
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
8
8
888
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.
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.
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. Date Sold List Price Days to Market
4.000
4.000
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
9
9
999
Apply Align Right and increase the indent two times on the days on market formula results in the range E5:E12.
Apply Align Right and increase the indent two times on the days on market formula results in the range E5:E12.
Apply Align Right and increase the indent two times on the days on market formula results in the range E5:E12.
5.000
5.000
5.000
10
Delete the empty column B.
5.000
10
10
101010
Delete the empty column B.
Delete the empty column B.
Delete the empty column B.
5.000
5.000
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
11
11
111111
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.
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.
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.41 Chestnut Circle 4/22/2016Amsterdam Drive $355,000
5.000
5.000
5.000
12
Select the property rows (rows 5:12) and set a 20 row height.
5.000
12
12
121212
Select the property rows (rows 5:12) and set a 20 row height.
Select the property rows (rows 5:12) and set a 20 row height.
Select the property rows (rows 5:12) and set a 20 row height.20
5.000
5.000
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
13
13
131313
Set the Days on Market column width to 9. Set the List Price and Sold Price column widths to 11.86.
Set the Days on Market column width to 9. Set the List Price and Sold Price column widths to 11.86.
Set the Days on Market column width to 9. Set the List Price and Sold Price column widths to 11.86.911.86.
6.000
6.000
6.000
14
Select Landscape orientation and set the scaling to 130%.
10.000
14
14
141414
Select Landscape orientation and set the scaling to 130%.
Select Landscape orientation and set the scaling to 130%.
Select Landscape orientation and set the scaling to 130%.
10.000
10.000
10.000
15
Center the data horizontally and vertically on the page.
10.000
15
15
151515
Center the data horizontally and vertically on the page.
Center the data horizontally and vertically on the page.
Center the data horizontally and vertically on the page.
10.000
10.000
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
16
16
161616
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.
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.
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.Exploring Series
10.000
10.000
10.000
17
Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0.000
17
17
171717
Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0.000
0.000
0.000
Total Points
100.000
Total Points
Total Points
Total PointsTotal PointsTotal Points
100.000
100.000
100.000100.000100.000
