Home Insert Draw Design Layout References>> Share Comm Arial 14 A A Aa EX16 XL_CH05_GRADER CAP_AS- Travel Expenses 1.7 Project Description: You are the manager of an information technology (IT) team. Your employees go to training workshops and national conferences to keep up-to-date in the field. You created a list of expenses by category for each employee for the last six months. Now you want to subtotal the data to review total costs by employee and then create a PivotTable to look at the data from different perspectives Steps to Perform: Step Points Possible Instructions 1 Start Excel. Open the downloaded Excel le named exploring e05 grader a1 Expenses.xisx Save the workbook as exploring-eOS-g der-al-Expenses-LastFirst, replacing Lastent with your own name. 2 On the Subtotals worksheet, sort the data by Employee and further sort by Category, both in alphabetical order 3 Use the Subtotals feature to insert subtotal rows by Employee to calculate the total expense by emplovee. 4 Collapse the Donaldson and Hart sections to show only their totals. Leave the other employees' individual rows displayed. Use the Expenses worksheet to create a blank PivotTable on a new worksheet named Summary. Name the PivotTable Categories. 6 Use the Category and Expense fields, enabling Excel to determine where the fields go in the PivotTable. Modify the Values field to determine the average expense by category. Change the custom name to Average Expense. Format the Values field with Accounting number type. Type Category in cell A3 and change the Grand Totals layout option to On for Rows Ony Page 1 of 2 5 of 633 words Focus 120% Home Insert Draw Design Layout References>> Share Comm Arial 14 A A Aa EX16 XL_CH05_GRADER CAP_AS- Travel Expenses 1.7 Project Description: You are the manager of an information technology (IT) team. Your employees go to training workshops and national conferences to keep up-to-date in the field. You created a list of expenses by category for each employee for the last six months. Now you want to subtotal the data to review total costs by employee and then create a PivotTable to look at the data from different perspectives Steps to Perform: Step Points Possible Instructions 1 Start Excel. Open the downloaded Excel le named exploring e05 grader a1 Expenses.xisx Save the workbook as exploring-eOS-g der-al-Expenses-LastFirst, replacing Lastent with your own name. 2 On the Subtotals worksheet, sort the data by Employee and further sort by Category, both in alphabetical order 3 Use the Subtotals feature to insert subtotal rows by Employee to calculate the total expense by emplovee. 4 Collapse the Donaldson and Hart sections to show only their totals. Leave the other employees' individual rows displayed. Use the Expenses worksheet to create a blank PivotTable on a new worksheet named Summary. Name the PivotTable Categories. 6 Use the Category and Expense fields, enabling Excel to determine where the fields go in the PivotTable. Modify the Values field to determine the average expense by category. Change the custom name to Average Expense. Format the Values field with Accounting number type. Type Category in cell A3 and change the Grand Totals layout option to On for Rows Ony Page 1 of 2 5 of 633 words Focus 120%
