Excel Module 6 SAM End of Module Project 2 | NP_EX19_EOM6-2 | Hallas Real Estate | HallasRealEstate
#Excel Module 6 SAM End of Module Project 2
#Module 6 SAM End of Module Project 2 | NP_EX19_EOM6-2
#Module 6 SAM End of Module Project 2NP_EX19_EOM6-2
#HallasRealEstate#Hallas_Real_Estate#End_of_Module#Cengage
#NP_EX19_EOM6-2_FirstLastName_1.xlsx#Excel_Module_6#ExcelModule6
#ExcelModule6EndofModuleProject2#ExcelModule6SAMEndofModuleProje
Contact:
WhatsApp : +92 3706351249
Email : mypearson100@gmail.com
Direct WhatsApp link
[ Ссылка ]
• Open the file NP_EX19_EOM6-2_FirstLastName_1.xlsx, available for download from the SAM website.
• Save the file as NP_EX19_EOM6-2_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• With the file NP_EX19_EOM6-2_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. Nico Hallas runs Hallas Realty, a small but growing real estate agency in Columbia, South Carolina. He keeps track of the listings of his four agents in an Excel workbook, and asks for your help in updating and analyzing the data. Switch to the Dahl worksheet, which contains a table named Dahl for Louisa Dahl's listings. Unfreeze the top row of the worksheet because the worksheet is not long enough to scroll.
2. Remove the filters from the Dahl table to display all of the data. Sort the data in ascending order first by the Listing Type field and then in descending order by the Sales Price field to make it easy to track her listings.
3. Nico wants to compare the average asking prices and average sales prices for the Dahl listings. Insert a Total Row in the Dahl table, and then use the Total row to calculate the average of the values in the Asking Price and Sales Price columns.
4. Switch to the Han worksheet, which contains listing information for Suki Han. Format the range A2:F10 as an Excel table with headers using the Olive Green, Table Style Medium 12 table style. Enter Han as the name of the table.
5. Nico needs to add a listing for Suki Han. Add the record shown in Table 1 to the end of the Han table.
