The writer is very fast, professional and responded to the review request fast also. Thank you.
Book/movie review
22/08/2022
Home Town Realty
You work for a local real estate agency called Home Town Realty. It has a running Excel workbook of all properties it is permitted to show including both sold and unsold properties. The sales people use this workbook as a reference point to see whether houses have sold or new listings are available when out with prospective buyers. You received a new set of listings from another agency and need to add them to your existing workbook.
Perform Preliminary Work
You will make a new worksheet title row to enhance the worksheet’s appearance.
a. Open 01_test_chap_data1 and save as
01_test_chap_LastFirst
b. Type
Home Town Realty
in
cell A1.
Merge and center
cells A1:H1
c. Change the column width of column D to
5.0 characters (40 pixels)
Add Newly Provided Listings
North Hills Properties has provided new listings that need to be added to the existing listings you have on file.
d. Add a new worksheet named
NH Listings
e. Open 01_test_chap_data2 and copy the new listings. Close 01_test_chap_data2. Use the Paste option (Keep Source Column Widths) to paste the new listings into the NH Listings worksheet.
f. You realize the column names do not match your existing listings. Insert a column before Street and enter
House ID
in A1. Type
112
into
cell A2
g. Make a formula in
cell A3
that increases
by 1. Use AutoFill to add House ID to each row in the worksheet.
h. Insert a column before Sold and label it
Listing Agency
. Add the listing agency in
cell F2
as
North Hills Properties
. Use the AutoFill to fill the remaining Listing Agency fields as
i. Copy
cells A2:H5
from the NH Listings worksheet and paste them into
cell A13
in the Listing worksheet.
j. Apply
text wrapping
to column F so that the entire listing agency name is visible.
Manually Update Records
You are missing house 111 from the list that was sold last week. You need to re-enter the data.
k. Insert a row after House ID 110 and enter the following information:
House ID = 111
Street = 1243 Ben Franklin Pkwy.
City, State, Zip = Philadelphia, PA 19121
Listing Agency = Home Town Realty
Sold = Yes
Date = 4/12/17
l. One of the sellers has decided to not sell their property and wants to have their listing removed. Delete the entire row for House ID 108.
Finalize the Workbook
You will add a custom footer and change the page orientation.
m. Add a custom footer that includes your
First Name and Last Name, Instructor Name, and Date
n. Set the page orientation to
Landscape
o. Save and close the file. Based on your instructor’s directions submit 01_test_chap_LastFirst.
G7XfixABCDEFGHK-House ID StreetCityState ZipSoldDateN1112 3191 Walnut StreetPhiladelphiaPA191043113 234 South StreetPhhiladelphiaPA19111A114 322 Pepper RunCherry HillNJ08002LO115 1121 Easy StreetPhiladelphiaPA19122O)78O1011121314Sheet1Sheet2 Sheet3+Ready160%
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more