MyEducator Tasks

$1\mathrm{.}4$ Using the data on the

$1\mathrm{.}5$ Using the data on the

$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 "Position" as a "Report Filter".

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

$16$

$1\mathrm{.}7$ Using the data on the