15. Create a Pivot Table, based on the EmployeeData, in a New Sheet and label it PVT Salary (26 max.) a. Use the following settings for the PVT Salary pivot table fields: b. In the Rows section, add Location and Sex (2) c. In the Values section add: i. Count of Annual Salary: (2) 1. Custom name: Num. Employee (2) 2. Format value Number with 0 decimals (2) ii. Sum of Annual Salary: (2) 1. Custom name: Sum of Salary (2) 2. Format Currency with 2 decimals (2) iii. Average of Annual Salary: (2) 1. Custom name: Average of Salary (2) 2. Format Currency with 2 decimals (2) d. Set the Report Layout to Show in Outline form (2) e. Add the title SALARY STATISTICS in cell A1, Style Heading 1 (2) f. Make column A1 width AutoFit