$2.$ In the CarValues worksheet, insert a PivotTable using these guidelines: Use CarValues as the table$/$range$.$ Place the Pivot Table in a new worksheet$\mathrm{.}3.$ Rename the PivotTable worksheet as: $20$ Year Estimate $-$ Classics$4.$ Add the Last Name and Car Year fields to the Rows area.RowsE ValuesLast NameCar Year$5.$ In cell A$3,$ change the Row Labels display name to: Members$6.$ Add the Current Value field to the Values area$\mathrm{.}7.$ In cell B$3,$ change the Sum of Current Value display name to: Current Values$8.$ Apply the Accounting number format to the range B$4$:$61$ and then decrease the decimal places so no decimals display$\mathrm{.}9.$ Add a calculated field to the PivotTable using these guidelines: Name: Estimated Value Formula: $=$ 'Current Value'$+(\text{'}$AVG per Year'$*20)10.$ In cell C$3,$ change the display name to: $20$ Year Estimate$11.$ Modify the PivotTable layout as follows: Subtotals: Do not show subtotals. Report Layout: Show in tabular form$\mathrm{.}12.$ Apply the PivotTable style Light Yellow, Pivot Style Light $18\mathrm{.}13.$ Insert a slicer using these guidelines: Slicer to Insert: Status Height: $1\mathrm{.}1"$ Width: $1.25"$ Filter by: Classic Position it below the PivotTable$\mathrm{.}14.$ Insert a $3-$D Area PivotChart$\mathrm{.}15.$ Set the PivotChart height to $5"$ and the width to $10"\mathrm{.}16.$ Close the PivotTable Fields pane and then position the PivotChart to the right of the PivotTable$\mathrm{.}17.$ Save your workbook.