Question: . ( 1 5 points ) The company is trying to categorize all properties into A and B groups. Add information to column I with

.(15 points) The company is trying to categorize all properties into A and B groups. Add information to column I with column heading Category. Any property having at most $10,000 difference between its asking and selling price, regardless of which one is higher, and with at most 50 days on the market before its sold is categorized as A, otherwise B. Hint: you might want to consider using the function ABS to find out the absolute difference between two numbers; f.(5 points) Add a conditional formatting rule to column I so that all category A cells be displayed in Green Fill with Dark Green Text;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!