Consider the PivotTable on the # Employees$$worksheet$.$How many employees are in the West Region?

$245$

$13$ Million

$20$ Million

$370$

$3$

Consider the PivotTable on the Experience worksheet.$$What is the average number of years experience for Salespersons in Phoenix?

$17$

$3\mathrm{.}1$

$15\mathrm{.}7$

$127\mathrm{.}1$

$1956\mathrm{.}9$

$15\mathrm{.}4$

$1495\mathrm{.}5$

$4$

Consider the PivotTable on the Max Salary$$worksheet$.$What is the maximum salary for Regional Managers who work the morning shift?

$202800$

$62100$

$205600$

$100400$

$179200$

$160000$

$5$

Consider the PivotTable on the Average Salary worksheet.$$Is there evidence that employees working one shift make more than employees working the other shift?

Yes

No

$6$

Consider the PivotTable on the Position worksheet.$$Appromately what percentage of employees are Salespersons in the South region?

$95\%$

$97\%$

$93\%$

$94\%$

$19\%$

$17\%$

$29\%$

$7$

Consider the PivotTable on the Managers worksheet.$$How many total years experience do$$managers of the East region have?

$75$

$39$

$78$

$10$

$17$

$35$

$52$

$23$

$8$

Consider the PivotTable on the Salary Difference worksheet.$$What is the difference between the average salaries for Salespersons and Sales Managers in the West region?