Open the Clemenson04xlsx start file Click the Enable Editing button The file will be renamed automatically to include your name Change the project file name if directed to do so by your instructor Copy the PastProjected sheet place the copy before the Criteria sheet and name the copied sheet Adv Filter Create and format an Excel table Select cells A4E60 on the Adv Filter sheet Click the Quick Analysis tool and choose Tables Click Table Apply a table style Click cell A5 in the table Click the More button Table Design tab Table Styles group Alternate Instruction for Microsoft 365 Apps icon Click the More button Table Tools Design tab Table Styles group Select White Table Style Medium 15 Create an output range for an Advanced Filter Select cells A4E4 and copy and paste them to cell G4 Type Extract Range in cell G3 and set the font to Cambria 16 pt Adjust column widths for columns GK to show the labels Adjust row 4 to a height of 3375 45 pixels Create an Advanced Filter Click the Criteria sheet tab Type 123118 in cell A3 to find records after 2018 Type mri in cell B3 Type 123119 in cell A4 to find records after 2019 Type ct scan in cell B4 This criteria will find records dated 2019 or later for MRIs and records for CT scans dated 2020 or later Figure 494 AND criteria displays in rows 34 Figure 494 Criteria for Advanced Filter Click cell A5 on the Adv Filter sheet Click the Advanced button Data tab Sort Filter group Select the Copy to another location radio button Verify that the List range is cells A4E60 If the range is incorrect click and drag to select the range including the header row Click the Criteria range box and select cells A2B4 on the Criteria sheet Click the Copy to box and select cells G4K4 on the Adv Filter sheet Click OK in the Advanced Filter dialog box Sort data in the output range Select cell G5 and click the Sort button Data tab Sort Filter group Click the Sort by arrow and choose Image for the first level Verify that the Sort On selection is Cell Values and the Order is A to Z Click Add Level and choose Month as the Then by selection Verify or select Cell Values and Oldest to Newest for the second level Click OK