Excel Tables The SalesOrders worksheet shows orders. Some research needs to be done to locate a group of information. make a table starting at J$2$ to look up sales tax. Central sales tax is $7\%,$ East is $8\%,$ West is $9\%,$ and South is $5\%.$ J$1$ put in text $$Tax Table$,$ display the tax rates in K column as $\%$ Insert a column before column H and call it Sales Tax Table In Sales Tax column do VLOOKUP for the sales tax rate using values from column B$.$ Set VLOOKUP as exact match. Define the range for the vlookup as absolute reference. Update the calculations in column H to include sales tax as part of the calculation Convert the Orders dataset into an Excel Table $($remember you only need to select one cell to make excel table$)$ Then, locate the records of the dataset that comply with all the following characteristics: Region is East or West. Rep is Parent. Format the Cost and Total to be currency $($$$)$ Copy total sales values column H for rep Parent in the East and West region and paste values into column P$.$ Add a sum at the bottom of the values in column P to show total sales for Parent in the East and West Regions Select columns A thru H and make a named range called $$Sales$$ E Add a Total row and use the properties of the Total Row to calculate: the sum of Total $($column H$).$ the sum of units $($column E$)$ F Apply the Olive Green, Table Style Medium $11$ to the table Pivot Tables and Pivot Charts Pivot Table $1$ : Use the SalesOrders worksheet and make a Pivot Table on new worksheet with a filter on Region, row of Rep, column of Item and sum of Units, Sum of Total Filter the information so that only $$East$$ region is displayed. Format total to display in currency format Which Rep has the most revenue? Answer in cell M$1$ of this sheet. Rename the PivotTable's worksheet: SalesPivot.