$1\mathrm{.}5$ Using the data on the Employee Data worksheet, insert a PivotTable on the "Position" worksheet to calculate the percentage of employees for each type of position by region.

a$.$ Construct the PivotTable with "Position" as the Row Labels.

b$.$ Place "Region" as the Column Labels.

c$.$ Use an appropriate presentation of Salary as the values field. There are no blank salary cells and each employee accounts for one salary data point.

$14$

$1\mathrm{.}6$ Using the data on the Employee Data worksheet, insert a PivotTable on the "Managers" worksheet to determine which locations have regional or sales managers.

a$.$ Construct the PivotTable with "Location" as the Row Labels.

b$.$ Place "Region" as the Column Labels.

c$.$ Use the sum of "Experience" as the PivotTable Values.

d$.$ Add $"$Po$$ition$"$ as a "Report Filter".

e$.$ Use the filter to display only "Regional Managers" and "Sales Managers" in the PivotTable.

$1\mathrm{.}7$ Using the data on the Employee Data worksheet, insert a Pivot ${?}^T$ able on the "Salespersons" worksheet to calculate the percent of grand total each position makes up in each region.

a$.$ Construct the PivotTable with "Position" as the Row Labels.

b$.$ Place "Region" as the Column Labels.

c$.$ Use an appropriate presentation of "Salary" as the PivotTable values.

$12$