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)$

Custom name: Num. Employee $(2)$

Format value Number with $0$ decimals $(2)$

ii$.$ Sum of Annual Salary: $(2)$

Custom name: Sum of Salary $(2)$

Format Currency with $2$ decimals $(2)$

iii. Average of Annual Salary: $(2)$

Custom name: Average of Salary $(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 A$1,$ Style Heading $1(2)$

f$.$ Make column A$1$ width AutoFit $(2)$

Create a pivot chart graph. $(16$ max