You are the Human Resources director for the company and you are interested in analyzing the hiring and compensation practices in your company. The Employee Data worksheet contains information about 1200 sales employees of your company. This information includes the Gender, Name, Location (city), Region, Position, and Salary for each employee. Complete the tasks by manipulating the PivotTables on each worksheet in the workbook to answer the questions on the questions worksheet.

Task #	Points	Task Description
1	11	Manipulate the PivotTable on the # Employees worksheet to determine how many total employees are in each region by calculating the number of salaries in each region. Note there are no blank salary cells and each employee accounts for one salary data point. Place Region as the Row Labels of the PivotTable, and an appropriate presentation of Salary as the PivotTable Values.
2	2	Select the number of employees in the West region using the drop-down list in cell C12 of the "Questions" worksheet.
3	11	Manipulate the PivotTable on the Experience worksheet to calculate the average work experience by position for each location. Construct the PivotTable with Location as the Row Labels, Position as the Column Labels, and an appropriate presentation of Experience as the Values for the PivotTable.
4	2	Select the average number of years experience for salespersons in Phoenix using the drop-down list in cell C13 of the "Questions" worksheet.
5	11	Manipulate the PivotTable on the Max Salary worksheet to calculate the maximum salary by gender and position. Construct the PivotTable with Position as the Row Labels, Gender as the Column Labels, and an appropriate presentation of salary as the PivotTable values.
6	2	Select the maximum salary for Female Regional Managers using the drop-down list in cell C14 of the Questions worksheet.
7	12	Manipulate the PivotTable on the Average Salary worksheet to determine if there is gender discrimination with respect to average salaries in the company. Construct the PivotTable with Position as the Row Labels, Gender as the Column Labels, and an appropriate presentation of Salary as the PivotTable Values.
8	2	There would be evidence of gender discrimination with respect to salary if males have a higher average salary for three or more positions in the company. Select Yes or No using the drop-down list in cell C15 of the Questions worksheet if there is evidence of gender discrimination in the company.
9	14	Manipulate the PivotTable on the Position worksheet to calculate the percentage of employees for each type of position. Note that there are no blank salary cells and each employee accounts for one salary data point. Construct the PivotTable with Position as the Row Labels, Region as the Column Labels, and an appropriate presentation of Salary as the values field.
10	2	Select the approximate percentage of all employees that are Salespersons using the drop-down list in cell C16 of the "Questions" worksheet.
11	15	Manipulate the PivotTable on the Regional Managers worksheet to determine which locations have regional managers. Construct the PivotTable with Location as the Row Labels, Region as the Column Labels, and the sum of Experience as the PivotTable Values. Use Position as a Report Filter and display only Regional Managers in the PivotTable.
12	2	Select the number of years experience for the Regional Manager in the East region using the drop-down list in cell C17 of the "Questions" worksheet.
13	12	Manipulate the PivotTable on the Salary Difference worksheet to calculate the Salespersons' difference from the average Sales Managers salaries in each region. Construct the PivotTable with Position as the Row Labels, Region as the Column Labels, and an appropriate presentation of Salary as the PivotTable values.
14	2	Select the average difference between Salesperson and Sales Manager salaries in the West region using the drop-down list in cell C18 of the "Questions" worksheet.