Add a new sheet and name the sheet Sales-Analysis. Copy the cell range A3:F40 from the Reporting-Detail worksheet and paste it in the Sales-Analysis worksheet. The following instructions apply to the Sales-Analysis worksheet. AutoFit the columns. Apply the Accounting number format to cell range F2:F38. Select cell range A1:F38 and Insert a Table. In the Create Table dialog box, verify that the range for your data is correct and that the box for "My Table has Headers" has been checked. Click OK to close the dialog box. AutoFit the columns again. Select cell range A1:F38 and apply a different Table Style of your choice instead of the default Office style Set the Table Name for your table to be "SalesRegister" (without quotes; no space). Insert Filters to the Table range A1:F1. Then filter the data so that only the sales for the North Region display Sort the table by Net Sales in descending order Insert a Totals Row and verify that the SUM function is selected as the display value. Add a custom Header to the worksheet with your name in the left section and MEID in the right section of Header Add a custom Footer to the worksheet with today's date (be sure to use the Date function so that your date automatically updates) in the left section and the words "Lesson 7 Project 1" in the right section of the Footer. Adjust the margins of the worksheet to "Narrow" and set the page to be centered horizontally when printed. (Hint: These options can be adjusted on the File>Page Setup menu