pen e$01$m$2$Sales and save it as e$01$m$2$Sales$\_$LastFirst.

b$.$ Delete the row containing $640$ North Oak Drive. The owners took their house off the market.

c$.$ Cut the row containing $973$ East Mulberry Lane. Insert cut cells on row $10.$ Existing data

should move down.

d$.$ Type$2024-001$ in cell A$5$ and use Auto Fill to complete the series to assign a property ID to

each property.

e$.$ Use the semi$-$selection method to build a formula that calculates the number of days the first

house was on the market in cell C$5$ by subtracting the date listed from the date sold. Copy the

formula to the range C$6$:C$13.$

f$.$ Format list prices and sold prices with Accounting Number Format with zero decimal places.

g$.$ Calculate the sales price percentage of the list price in cell H$5$ by dividing the sold price by

the list price. Format the percentages with two decimal places. Copy the formula to the range

H$6$:H$13.$ The first house was listed for $$350,000,$ but it sold for only $$335,000.$ Therefore, the

sale percentage of the list price is $95\mathrm{.}71\%.$

h$.$ Center horizontally and wrap the headings on row $4.$

i$.$ Insert a new column between the Date Sold and List Price columns. Move the Days on Market

range C$4$:C$13$ to the range F$4$:F$13.$ Delete the empty column C$.$

j$.$ Edit the date sold of the $41$ Chestnut Circle house to be $4/22/2024.$

k$.$ Select the range A$5$:H$13,$ set a $25$ row height, and apply Middle Align.

l$.$ Apply the All Borders border style to the range A$4$:H$13.$ Adjust column widths as