Step Instructions Possible Start Excel. Open the downloaded Excel file named 0 exploring_e05_grader_a1_Expenses.x/sx. Save the workbook as exploring_e05_grader_a1_Expenses_LastFirst, replacing LastFirst with your own name. 2 On the Subtotals worksheet, use the Sort dialog box to sort the data by 4 Employee and further sort by Category, both in alphabetical order. 3 Use the Subtotals feature to insert subtotal rows by Employee to 6 calculate the total expense by employee. 4 Collapse the Donaldson and Hart sections to show only their totals. 5 Leave the other employees' individual rows displayed. 5 Use the Expenses worksheet to create a blank PivotTable on a new 8 worksheet named Summary. Name the PivotTable Categories. 6 Use the Category and Expense fields, enabling Excel to determine 5 where the fields go in the PivotTable. 7 Modify the Values field to determine the average expense by category. 4 Change the custom name to Average Expense. 8 Format the Values field with Accounting number type. 4 9 Type Category in cell A3 and change the Grand Totals layout option to 5