Format the field with the custom name Above or Below Average and apply Accounting number format to the field. 10 15 Set 12.25 width for column B and column C, change the row height of row 3 to 30, and apply word wrap to cell C3. 4 16 Create a clustered column PivotChart from the PivotTable. Move the PivotChart to a new sheet named Chart. Hide all field buttons in the PivotChart, if necessary. Note, Mac users, select the range A3:C8 in the PivotTable. On the Insert tab, click Recommended Charts, and then click Clustered Column to make the chart. 10 17 Add a chart title above the chart and type Expenses by Employee. Change the chart style to Style 14. 6 18 Apply 11 pt font size to the value axis and display vertical axis as Accounting with zero decimal places. 4 19 Create a footer on all worksheets with your name in the left section, the sheet name code in the center section, and the file name code in the right section. 3 20 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Subtotals, Summary, Chart, Totals, Expenses. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Close