Question

5 Real estate agents study the number of days houses are on the 10 market. In some cases, the longer a house is on the market, it might indicate the asking price is too high. Enter a formula in cell C5 that calculates the number of days the first house was on the market by subtracting the date listed from the date sold. Copy the formula to the range C:C13

Answer 1

To calculate the number of days a house was on the market, subtract the date listed from the date sold. Copy the formula to calculate the number of days for other houses.

Step-by-step explanation:

To calculate the number of days the first house was on the market, you need to subtract the date listed from the date sold. You can use the formula =date_sold - date_listed in cell C5. Then, you can copy this formula to the range C:C13 by selecting cell C5, dragging the fill handle down to cell C13, and releasing the mouse button. This will automatically adjust the formula for each row.