Open e05_Patients_Data_Oct 18 and save it as e05_Patients_Data_Oct 18_LastFirst. Ensure that the August Data worksheet is active. Complete the following steps to sort the data: Click the Data tab and click Sort in the Sort \\& Filter group. Click the Sort by arrow and select Weekday. Click the Order arrow and select Custom List to open the Custom Lists dialog box. Select Sunday, Monday, Tuesday in the Custom lists section and click OK. Click OK in the Sort dialog box. Click Subtotal in the Outline group. Complete the following steps in the Subtotal dialog box: Click the At each change in arrow and select Weekday. Click the Use function arrow and select Average. Click the Patient-End check box to select it, keep the Nurses check box selected, and then click OK. Click the Group arrow in the Outline group on the Data tab, select Auto Outline, and then click OK. Click collapse above column G to collapse the outline Click the August Table sheet tab, click the Insert tab, click Recommended PivotTables in the Tables