Only complete a-h. Please show formula used if any or describe the step taking to get each letter . Thank You

COMPUTER EXERCISES 16-1. Enter the real estate worksheet in Figure 1-3 (in Chapter 1). (a) Change the range of the data into a table. For each of the following begin with the original table from (a). (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. () Use Filters to display all of the homes with 4 or more bedrooms. (f) Use Filters to display all of the homes that cost between $150,000 and $250,000. (g) Use Filters to display all of the homes that are on a lot of at least 0.75 acres, heat with oil, and cost under $300,000. (h) Use a Total Row to find the average number of bedrooms, lot size, age, and price of homes for sale. (1) Use the PivotTable tool to find the total value of the homes for sale of each heat type and number of bedrooms 6) Use the PivotTable tool to find the average value of the homes for sale of each heat type and number of bedrooms. (k) Use the PivotTable tool to find the average age of the homes for sale of each heat type and number of baths. (1) Double-click on one of the entries in the Pivot Table in (k) to see the underlying data. X 5. Real Estate - Excel & Share File Home Insert Page Layout Formulas Data Review View Tell me... Sign in Arial - 110 % Conditional Formatting P ED BIU A A Format as Table Paste Alignment Number Cells Editing > A Cell Styles Clipboard Font Styles