1. On the Documentation sheet, do the following: a) Enter your name in cell B3. b) Make your name link to your email address. c) Add a screenTip that says Email me for questions about the Review. d) Use an Excel function to enter the current date in cell B4. 2. On the Orders sheet, convert the invoice data range to an Excel table. Name it OrdersTbl. Add a freeze pane to the Orders sheet at cell B2. 3. On the Business Sheet, filter the FilteredBusinessTbl to only show the Business Customers. Also, add the Total Row to sum the Net Amount. 4. On the Retail Sheet, filter the FilteredRetailTbl to only show the Retail Customers. Also, add the Total Row to sum the Net Amount. 5. On the Dashboard sheet, in cell B2, calculate the Total Net Amount from the Business & Retail customers by pulling from the Business & Retail sheets. Format the answer as Currency with no decimals. 6. On the Mid-May Orders sheet, filter the FilterMayTbl to only show data with Order Dates between May 10, 2020 and May 20, 2020 (inclusive). 7. On the Sort by City sheet, sort the SortTbl by Delivered To and by Customer Type, both in ascending order. 8. On the Filter by Type sheet, click the FilterTypeTbl and add a Customer Type slicer. Move the slicer to the Dashboard sheet in cells A6:A10. Set the columns to 2. 9. On the Dashboard sheet, in cell B12, calculate the number of customers in the FilterTypeTbl. 10. On the Dashboard sheet, in cell B13, calculate the total Net Amount in the FilterTypeTbl. 11. On the Dashboard sheet, in cell B14, calculate the average Discount in the FilterTypeTbl. 12. Test out the slicer by clicking on Retail and Seniors. Leave these two selected. 13. On the Subtotals sheet, use the Subtotal command button to display the order amount total for each Customer Type in the Order Amount column. Make sure your table is sorted in the correct sequence for the required totals and remember to covert the table to a range before subtotaling. 14. On the Orders sheet, in cell I1, type Level. In cell I2, use the VLOOKUP function to appropriately categorize the Net Amount based on the Amount_Level found on the Lookup Table sheet. 15. From the OrdersTbl on the Orders sheet, create a PivotTable and PivotChart and place them in a new worksheet. Name the worksheet PivotTable and PivotChart. Create them to look like the ones below. Be sure to change Number Format of the Net Amount! 16. Add a Customer Type slicer to the PivotTable.