Project Description Work Real Estate Agent Riverwood Really Independent Real Estate Agency Q43794796
Not sure how to do the second part of number 9.
Project Description: You work as a real estate agent for Riverwood Really, an independent real estate agency in Utah. As part of your end of year reports, you compile a list of homes that have sold in your sales region. To complete your report you will create an Excel table apply Fiters, Sort, perform basic calculations using unqualified structured references, and prepare the document to print Steps to Perform: Step Instructions Points Possible Start Excel. Download and open the file named Exp19_Excel_Ch04 Assessment_Homes xlsx. Grader has automatically added your last name to the beginning of the filename. Freeze the panes so that the column labels do not scroll offscreen. Convert the data to a table and name the table Sales Apply Purple, Table Style Dark 10 to the table. Remove duplicate records from the table. Excel should find and remove eight duplicate record. O Add a new column in column I named Days on Market. Use unqualified structured references to calculate the days on market (Sale date – Listing date) in column 1. Set column I’s width to Apply a Total Row to the Sales table, set the selling price and Days on Market totals to Average Use Quick Analysis to apply Top 10% conditional formatting to column F. Apply 3 Traffic Lights (untimmed) conditional formatting icon set to column 1. Set the icon to display green for homes that sold within 45 days, yellow for 46 to 90, and red to homes that took more than 90 days to sell Filter the data to only display sales by the Selling Agent Hernandez Sort the table in Ascending order by City (Column C) Set the range A1183 as the print area File Hone s t Draw Page Layout Formulas Data Review View Help Design Tell me what you want to do Comments ME 13 12 . H o tell ListingDell 1 Trans 1 Address k ood Road 11 W OCA 314 Tip View Drive 14 W OME So South Poole Way City Singapore Cedar Hemande American Fork Goodrich DESE 400,000 American Fork Goodrich SSSSS 0.0001 ***** 7610 Wood Court 12021 23/2001 19 20 01 Wed W e Lyter von ArcaFor Codrich Ane u rs 000 South Sunt 2010 2 Tp Viewe Arcano 2001 wewe un 27 224 RAPS 28 Way FM 400 2011 29 Easton Way FM 100 1 M RV SRL 0000S $ 50 51 Sales Data type here to search ON OG A-44AN Show transcribed image text Project Description: You work as a real estate agent for Riverwood Really, an independent real estate agency in Utah. As part of your end of year reports, you compile a list of homes that have sold in your sales region. To complete your report you will create an Excel table apply Fiters, Sort, perform basic calculations using unqualified structured references, and prepare the document to print Steps to Perform: Step Instructions Points Possible Start Excel. Download and open the file named Exp19_Excel_Ch04 Assessment_Homes xlsx. Grader has automatically added your last name to the beginning of the filename. Freeze the panes so that the column labels do not scroll offscreen. Convert the data to a table and name the table Sales Apply Purple, Table Style Dark 10 to the table. Remove duplicate records from the table. Excel should find and remove eight duplicate record. O Add a new column in column I named Days on Market. Use unqualified structured references to calculate the days on market (Sale date – Listing date) in column 1. Set column I’s width to Apply a Total Row to the Sales table, set the selling price and Days on Market totals to Average Use Quick Analysis to apply Top 10% conditional formatting to column F. Apply 3 Traffic Lights (untimmed) conditional formatting icon set to column 1. Set the icon to display green for homes that sold within 45 days, yellow for 46 to 90, and red to homes that took more than 90 days to sell Filter the data to only display sales by the Selling Agent Hernandez Sort the table in Ascending order by City (Column C) Set the range A1183 as the print area
File Hone s t Draw Page Layout Formulas Data Review View Help Design Tell me what you want to do Comments ME 13 12 . H o tell ListingDell 1 Trans 1 Address k ood Road 11 W OCA 314 Tip View Drive 14 W OME So South Poole Way City Singapore Cedar Hemande American Fork Goodrich DESE 400,000 American Fork Goodrich SSSSS 0.0001 ***** 7610 Wood Court 12021 23/2001 19 20 01 Wed W e Lyter von ArcaFor Codrich Ane u rs 000 South Sunt 2010 2 Tp Viewe Arcano 2001 wewe un 27 224 RAPS 28 Way FM 400 2011 29 Easton Way FM 100 1 M RV SRL 0000S $ 50 51 Sales Data type here to search ON OG A-44AN
Expert Answer
Answer to Project Description: You work as a real estate agent for Riverwood Really, an independent real estate agency in Utah. As…
OR