I just need help figuring out the calculations

Capstone Exercise are an analyst for an athorised Geeenwich Workshop" rt dealer (www.greenwichworkshop.com). Customers in artwurk: Title (tiele of each piece of art). Type (the Release Date (the month and vear the art was released) epecially fond of James C. Christennen s art. You prepared a list of h '' "urn-such as limited Edition Print or Anniversary Edition nvas. Edition Size (how many copies were produced for pur- chase). Release Date t Iss ue Price (the original retail price when the art was released). Value (the estimated current market value). Studylng and Est. he data will help you discuss value trends with art collectors. Sort, Subtotal, and Outline Data ou want to organize data to facilitate using the Subtotal feature to display the average issue price and estimated value by Type a. Open eO Se 1 FineArt and save it as e05c1FineArt LastFirst b. Click the Subtotals sheet tab. Sort the data by Type and further sort it by the Title, both in alphabetical order c. Use the Subtotal feature to insert subtotal rows by Type to identify the highest Issue Price and Est. Value. d. Collapse the data by displaying only the subtotals and grand total rows. e. Set a print area for the range D1:1247. Set the scalin to fit to one page. eate a PivotTable want to create a PivotTable to analyze the art by Type, I , and Est. Value. In addition, you will rename the works he PivotTable. Click the Christensen sheet tab and create a bla PivotTable on a new worksheet. ame the worksheet Sold Out. Capstone Exercise are an analyst for an athorised Geeenwich Workshop" rt dealer (www.greenwichworkshop.com). Customers in artwurk: Title (tiele of each piece of art). Type (the Release Date (the month and vear the art was released) epecially fond of James C. Christennen s art. You prepared a list of h '' "urn-such as limited Edition Print or Anniversary Edition nvas. Edition Size (how many copies were produced for pur- chase). Release Date t Iss ue Price (the original retail price when the art was released). Value (the estimated current market value). Studylng and Est. he data will help you discuss value trends with art collectors. Sort, Subtotal, and Outline Data ou want to organize data to facilitate using the Subtotal feature to display the average issue price and estimated value by Type a. Open eO Se 1 FineArt and save it as e05c1FineArt LastFirst b. Click the Subtotals sheet tab. Sort the data by Type and further sort it by the Title, both in alphabetical order c. Use the Subtotal feature to insert subtotal rows by Type to identify the highest Issue Price and Est. Value. d. Collapse the data by displaying only the subtotals and grand total rows. e. Set a print area for the range D1:1247. Set the scalin to fit to one page. eate a PivotTable want to create a PivotTable to analyze the art by Type, I , and Est. Value. In addition, you will rename the works he PivotTable. Click the Christensen sheet tab and create a bla PivotTable on a new worksheet. ame the worksheet Sold Out