here is the problem I need help with

Issue Price ithe original retail price when the art was released and Est. Value (the estimated current market velue) Studying the data will help you discuss value trends with art collectors. Sort, Subtotal, and Outline Data You want to organize data to facilitate using the Subtotal feature to display the average issue price and estimated value by Type. a. Open e)5e 1 FineArt and save it as e0ScIFineArt LastFirst. b. Click the Subtotals sheet tab. Sort the data by Type and further sort it by the Title, both in alphabetical c. Use the Subtotal feature to insert subtotal rows by Type d. Collapse the data by displaying only the subtotals and e. Set a print area for the range D1:1247. Set the scaling order to identify the highest Issue Price and Est. Value grand total rows to fit to one page. Create a PivotTable You want to create a PivotTable to analyze the art by Type, Issue ce. and Est. Value. In addition, you will rename the worksheet and the PivotTable. PivotTable on a new worksheet. b. Name the worksheet Sold Out. c. Use the Type and Issue Price fields, enabling Excel to determine where the fields go. Add the Est. Value field to the VALUES area. Name the PivotTable Average Price by Type. d. e. Change Value Field Settings and Create a Calculated Field Excel displays the sum of the values by Type. However. you want to calculate the average values for each art type. In addition. you will calculate the percentage change from the Issue Price to the Est. Value. Finally, you will format the values and enter clear headings in the PivotTable. Modify the value fields to determine the average Issue Price and average Est. Value by type. a