ZuoTi.Pro
Question

EX16 XL _CH01_GRADER ML2 HW - Real Estate Sales Report 1.3 Project Description: You own a small real estate company in Indianapolis. You track the real estate properties you list for dlients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want 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: Points Possible Step Instructions 1 Start Excel. Download and open the file named eot grader h3.xlsx 0.000 2 Delete row 8, which has incomplete sales data. The owners took their house off the market. 3.000 Type 2018 001 in cell AS and use Auto Fill to complete the series to assign a property ID to each property in the range A6:A12. 5.000 Enter a formula in cell C5 that calculates the number of days the first house was on the market. Copy the formula to the range C6:C12. Format the range C5:C12 with Number format with zero decimal places 10.000 Format the list prices and sold prices in the range F5:G12 with Accounting Number Format 5.000 with zero decimal places Enter a formula in cell HS that calculates the sales price percentage of the list price for the first house. The second house was listed for $500,250, but it sold for only $400,125. Therefore, the sale percentage of the list price is 7999. Copy the formula to the range H6:H12 10.000
7 Format the values in the range H5:H12 with Percent Style with two decimal places. 5.000 8 Wrap the headings in the range A4:H4 2.000 Insert a new column between the Date Sold and List Price columns. Move the Days to Market data to the new blank column F by moving the range C4:C12 to F4:F12. Delete column C 9 5.000 Updated: 09/11/2017 Current Instruction docx Office 2016 myitlab:grader Instructions Excel Project Points Step Instructions ible Edit the list date of the 41 Chestnut Cirole house to be 4/22/2018. Edit the list price of the house on Amsterdam Drive to be $355,000. 10 5.000 11 Select the property rows (rows 5:12) and set a 25 row height and apply Middle Align. 5.000 Apply the All Borders border style to the range A4:H12. 12 3.000
13 Apply Align Right and increase the indent two times on the days on market formula results in 5.000 the range E5:E12. Set the Days on Market column width to 9. Set the List Price and Sold Price column widths to 11.86. 14 15 | Apply 120% scaling. 2.000 16 Delete the Properties sheet and insert a new sheet named Formulas. 5.000 Use the Select All feature to select all data on the Houses Sold worksheet and copy it to the 17 Formulas 5.000 Hide the Date Listed and Date Sold columns in the Formulas worksheet. 18 5.000 19 Display cell formulas. Set options to print gridlines and row and column headings. Set 6.86 column width for column E and 6 for column H. 3.000 20 Group the two worksheets. Select Landscape orientation. Center the page horizontally and vertically between the margins. 7.000 With both worksheets still grouped, insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side. 5.000 22 Save the workbook. Close the workbook and then exit Excel, Submit the workbook as directed. 0.000 Total Points 100.0on
J. Heaton Realty Sales Report 4 Prop ID Property Days on Market Date Listed Date Sold List Price Sold Price of List Price 125 Amsterdam Drive 341 North Oak Drive 100 South 325 West 386 East Elm Street 2304 West 39th Street 41 Chestnut Circle 973 East Mulberry Lane 538 North Oak Drive 64 Chancellor Estates 01/12/18 04/12/18 350000 335000 11/15/17 03/01/18 500250 400125 12/03/17 04/30/18 650725 500750 03/01/18 03/14/18 03/30/18 315000 325000 02/22/18 05/18/18 423500 420750 11/30/17 03/01/18 375000 375000 10/04/17 01/05/18 475000 400000 04/01/18 04/15/18 500999 495000 9 10 12 13 14 15 16 17 18 20 21 23 24 25 26
business   economics   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

J. Heaton Realty Sales Report % of List Prop ID Date Listed Date Sold Days on Market List Price Sold Price Price Property 2018 125 Amsterdam 12-4 12-1-2018 2018 001 rive 3| 355,000 | 335,000 | 94.37% 2018341 North Oak 002 Drive 11/15/173/1/18 106| 500.250 | 400.125 | 79.99% 2018 003 04-30 12/3/17 2018 100 South 325 West 148| 650,725 | 500,750 | 76.95% 2018 004 2304 West 39th Street 3/14/18 3/30/18 16 315,000325,000 103.176 2018- 005 41 Chestnut Circle 2/22/18 5/18/18 85| 423,500 | 420,750 | 99.35% 2018- 973 East Mulberry 006 Lane 11/30/17 3/1/18 91| 375,000 | 375,000 | 100.00% 2018- 538 North Oak 007 Drive 10/4/17 1/5/18 93| 475,000 | 400,000 | 84.21% 2018- 64 Chancellor 008 Estates 4/1/184/15/18 14| 500,999 | 495,000 | 98.80% some of the feature as asked in 16, 17 and 20 are only be possible in excel. some of the requirement are not properly showing in this box, as it would appear in excel

0 0
Add a comment
Know the answer?
Add Answer to:
EX16 XL _CH01_GRADER ML2 HW - Real Estate Sales Report 1.3 Project Description: You own a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Oject Description: u own five apartment complexes. You created a dataset listing the apartment nu...

    please post with pictures of step by step solution oject Description: u own five apartment complexes. You created a dataset listing the apartment numbers, apartment complex mes, as last remodeled. You want artments need to number of bedrooms, rental price, whether the apartment is occupied or not, and the date the apartment to insert some functions to perform calculations to help you decide which be remodeled. To focus on the apartments that need to be remodeled, you will use vanced...

  • Project Description: An independent real estate firm that specializes in home sales needs to create a database in which...

    Project Description: An independent real estate firm that specializes in home sales needs to create a database in which to store its records. In the following project, you will open a database containing information about the properties the real estate firm has listed. You will work with a table in which to store agent information, and then sort the table. You create a relationship between two tables and enforce referential integrity. You also apply filters, sort a table, and save...

  • In this project, you will work with sales data from Top’t Corn, a popcorn company with...

    In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will begin by inserting a new worksheet and entering sales data for the four food truck locations, formatting the data, and calculating totals. You will create a pie chart to represent the total units sold by location and a column chart to represent sales by popcorn type. You will format the charts, and...

  • EX16_XL_CH05_GRADER_CAP_AS - Travel Expenses 1.8 Project Description: <Project Description> Steps to Perform: Step Instructions Points Possible...

    EX16_XL_CH05_GRADER_CAP_AS - Travel Expenses 1.8 Project Description: <Project Description> Steps to Perform: Step Instructions Points Possible 1 Start Excel. Open the downloaded Excel file named exploring_e05_grader_a1_Expenses.xlsx. Save the workbook as exploring_e05_grader_a1_Expenses_LastFirst, replacing LastFirstwith your own name. 0 2 On the Subtotals worksheet, use the Sort dialog box to sort the data by Employee and further sort by Category, both in alphabetical order. 4 3 Use the Subtotals feature to insert subtotal rows by Employee to calculate the total expense by...

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

    Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name. 0 2 On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20. 7 3 On the Sales worksheet,...

  • Can you please provide the formula for the worksheet also. CASE PROBLEMS Level 1- Analyzing Sales...

    Can you please provide the formula for the worksheet also. CASE PROBLEMS Level 1- Analyzing Sales for Crèmes Ice Cream Judd Hemming is the eastern regional marketing manager for Crèmes Ice Cream. Eac quarter, he completes two separate analyses: an analysis comparing ice cream flavor sale volumes from all regional locations with the same quarter sales volumes from the previou year and an analysis comparing total sales in dollars, including mean, median, mode, and standard deviation, of sales by store....

  • Hello, I need some help with some Excel formulas. a. Open Excel_Ch11HW.xlsx and save it as...

    Hello, I need some help with some Excel formulas. a. Open Excel_Ch11HW.xlsx and save it as Excel_Ch11HW_LastNameFirstName. b. Click cell H4, the cell containing the ending date for the first loan. Enter the formula to compute the ending date, based on the starting date and the term of the loan. For the sake of simplicity, you don’t have to account for leap year. To compute the ending date, multiply the term of the loan by 365 and add that result...

  • You are the systems manager for Blue City Movies Rentals and you have been asked to create a report on historical sales data. To complete your task you will combine and edit data from multiple sources using Excel’s Power add-ins, XML, and tex

    You are the systems manager for Blue City Movies Rentals and you have been asked to create a report on historical sales data. To complete your task you will combine and edit data from multiple sources using Excel’s Power add-ins, XML, and text functions.Instructions:For the purpose of grading the project you are required to perform the following tasks:StepInstructionsPoints Possible1Open e10c2MovieRentals.xlsx and save the workbook with the name e10c2MovieRentals_LastFirst.02Import the movie data from the delimited file e10c2Movies.txt and rename the new worksheet Inventory.Hint: On the Data tab,...

  • You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts

    EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.6 Project Description:You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report that details all aspects of the business, including: employee tax withholding, facility management, sales data, and product inventory. To complete the task, you will duplicate existing formatting, utilize various conditional logic functions, complete an amortization table with financial functions, visualize data with PivotTables, and lastly...

  • Formulas - Setup the worksheet with formulas! 1. Open the MT Data file and save it...

    Formulas - Setup the worksheet with formulas! 1. Open the MT Data file and save it as MT School Budget. Select the Budget sheet if it's not already showing on your screen. 2. In D11, calculate the Fall Term Total by adding the One-Time amount (B11) to the Monthly amount (C11) multiplied by the Months in the Term (B5). Make sure to use an absolute reference in the formula so that it will copy correctly in the next step. Note:...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT