• Determine if a property is a Best Buy - Write a formula in cell I2, which can be copied down the column, to determine if the property is a best buy. A property is a best buy if the selling price per bedroom is less than $45,000.
• Determine if a property is a Hard to sell Write a formula in cell J2, which can be copied down the column, to determine if the property is a hard to sell. A property is a hard to sell if it is not a best buy.

• Determine (True or False) if all the properties are Best Buys. In cell J12, write a formula to determine if all of the properties are Best Buys.
• Write a formula in cell J13, to determine the number of properties on this list. Do not just enter the numerical value.

A B C D E F G H J Sold # Bed Asking Selling above 1 Address City rooms Price $ Price $ asking 2 120 East Lake St Columbus 3 118,125 113,925 FALSE 3 55 Southwest Blvd Westerville 4 208,000 209,500 TRUE 4 9 Acre Drive Columbus 3 175,000 143,000 FALSE 5 57 East 5th Av Columbus 2 83,000 67,000 FALSE 6 92 Downey St Gahanna 5 289,000 286,000 FALSE 7 2200 Birch Run Gahanna 3 179,000 172,000 FALSE 8 85 N. Drexel Av Delaware 6 525,000 475,000 FALSE 9 10 11 12 (T/F) Are all of the houses Best Buys? 13 Number of houses sold in total 14 Number of houses sold in Columbus 15 (T/F) More houses are in the mid-priced range than are hard to sell. 16 None of the Houses are Hard to sell Properties 17 Hard to below 90% Mid-Price sell of asking House Best Buy Property FALSE FALSE FALSE TRUE TRUE TRUE TRUE FALSE FALSE TRUE FALSE TRUE FALSE FALSE +