A B D E 11 G H 1 2 3 4 Bdrms Current Listings Baths Lot Age 5 3 0.40 4 2 1.20 3 1 0.60 2 1 0.25 2 1 0.30 2 1 0.40 4 2 0.30 7 4 5 6 12 First Street 7 46 Hearthstone Road 8 690 Rice Avenue 9 90 Bay Road 10 455 Nathan Street 11 18 Garden Street 12 203 Somerset Avenue 13 34 Farley Place 14 26 Latern Lane 15 11 Panama Street 16 155 Auburn Blvd 17 123 Jamaica Way 18 315 Fremont Avenue 19 1322 Bellevue Road 20 5 Pond Street 21 999 Johnson Road 22 2.30 0.30 Price Heat 48 $ 390,000 Gas 3 $ 645,000 Oil 25 $ 179,950 Gas 33 $ 148,400 Oil 16 $ 91,400 Elec 12 $ 112,555 Elec 98 $ 359,600 Gas 52 $ 860,000 Solar 9 $ 504,300 Solar 38 $ 227,890 Gas 5 $ 568,000 Oil 671 $ 429,500 Gas 8 $ 932,800 Nuclear 56 $ 533,500 Elec 2 $ 475,400 Oil 34 $ 195,500 Oil 3 1 4 1 0.50 1.00 5 2 4 2 0.30 0.40 3 1 6 3 0.30 4 3 1.501 1.20 2 1 23 24 25 26 27 28 a) Change the range of the data into a table For each of the following begin with the original table, copy original to new tab for each exercise. Do not overwrite original. b) Sort all of the homes in descending order by price. c) Sort all of the homes in ascending order by heat type and within each heat type in descending order by number of bedrooms. d) Use Filters to display all of the homes that heat with gas. e) Use Filters to display all of the homes with 3 or more bedrooms. f) Use Filters to display all of the homes that cost between $225,000 and $375,000. g) Use Filters to display all of the homes that are on a lot of at least 0.40 acres, heat with gas, and cost over $200,000. h) Use a Total Row to find the average number of bedrooms, lot size, age, and price of homes for sale. i) Freeze the column headings and row headings so that they are stationary as the slide bar is used to scroll up and down and across. j) Use Conditional Formatting to highlight all the homes that are less than 10 years old (apply this formatting to the age column). k) Use Conditional Formatting to highlight all the homes with prices between $200,000 and $500,000 (apply this formatting to the price column)