I just need to know what formula I would use in excel. I dont need the answer, I just need to know what formula to use after =

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

• 15.7
• 17
• 15.4
• 127.1
• 1495.5
• 3.1
• 1956.9

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

• 160000
• 202800
• 205600
• 179200
• 100400
• 62100

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

• 19%
• 93%
• 17%
• 29%
• 95%
• 94%
• 97%

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

• 78
• 52
• 10
• 39
• 23
• 17
• 35
• 75

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{1} & \multirow[t]{2}{*}{ A } & & c & \multirow[t]{2}{*}{ D } & \multirow[t]{2}{*}{E} & \multirow[t]{2}{*}{F} & \multirow[t]{2}{*}{ G } & \multirow[t]{2}{*}{H} & \multirow[t]{2}{*}{1} \\ \hline & & & & & & & & & \\ \hline 2 & & Employee \# & Shift & Name & Location & Region & Position & Experience & Salary \\ \hline 3 & & 131 & Morning & Deanne Abbott & Philadelphia & East & Salesperson & 1 & $29,400 \\ \hline 4 & & 793 & Afternoo & Santos Adams & New York & East & Salesperson & 7 & $25,400 \\ \hline 5 & & 479 & Morning & Ronda Adkins & Phoenix & West & Salesperson & 10 & $82,200 \\ \hline 6 & & 609 & Afternoo & Kory Adkins & Chicago & Midwest & Salesperson & 5 & $73,000 \\ \hline 7 & & 652 & Morning & Charlene Adkins & Houston & South & Salesperson & 23 & $61,200 \\ \hline 8 & & 675 & Afternoo & Tracy Aguilar & Chicago & Midwest & Salesperson & 16 & $27,200 \\ \hline 9 & & 1057 & Afternoo & Marquis Aguilar & Houston & South & Intern & 0 & $14,300 \\ \hline 10 & & 543 & Morning & Regina Aguirre & Los Angeles & West & Salesperson & 13 & $62,600 \\ \hline 11 & & 636 & Morning & Francesca Alexander & New York & East & Salesperson & 14 & $48,200 \\ \hline 12 & & 258 & Morning & Reba Allen & Chicago & Midwest & Salesperson & 5 & $43,500 \\ \hline 13 & & 821 & Morning & Hattie Allison & San Antonio & South & Salesperson & 17 & $62,500 \\ \hline 14 & & 907 & Afternoo & Luke Allison & Chicago & Midwest & Salesperson & 16 & $76,900 \\ \hline 15 & & 1118 & Morning & Bernadine Allison & Chicago & Midwest & Salesperson & 9 & $69,900 \\ \hline 16 & & 69 & Morning & Latoya Alvarado & Los Angeles & West & Salesperson & 9 & $84,700 \\ \hline 17 & & 111 & Morning & Charmaine Alvarado & Dallas & South & Salesperson & 27 & $46,500 \\ \hline 18 & & 306 & Morning & Angie Alvarado & Chicago & Midwest & Intern & 1 & $7,100 \\ \hline 19 & & 801 & Afternoo & Rubin Alvarado & Los Angeles & West & Salesperson & 16 & $71,300 \\ \hline 20 & & 1176 & Morning & Susie Alvarez & Houston & South & Salesperson & 30 & $60,300 \\ \hline 21 & & 647 & Morning & Nettie Andersen & Dallas & South & Salesperson & 20 & $78,600 \\ \hline 22 & & 759 & Morning & Deena Andersen & Detroit & Midwest & Salesperson & 10 & $38,000 \\ \hline 23 & & 891 & Morning & Sofia Andersen & Houston & South & Salesperson & 10 & $74,900 \\ \hline 24 & & 1107 & Morning & Cherie Andersen & Dallas & South & Salesperson & 3 & $50,000 \\ \hline 25 & & 300 & Afternoo & August Andrade & San Antonio & South & Salesperson & 4 & $40,300 \\ \hline 26 & & 656 & Morning & Johanna Andrade & Los Angeles & West & Salesperson & 13 & $44,300 \\ \hline 27 & & 213 & Morning & Sophie Arellano & New York & East & Salesperson & 9 & $28,600 \\ \hline 28 & & 1064 & Afternoo & Garrett Arias & Houston & South & Salesperson & 29 & $67,100 \\ \hline 29 & & 852 & Afternoo & Vince Armstrong & Dallas & South & Salesperson & 5 & $80,600 \\ \hline 30 & & 56 & Afternoo & Jeremy Arnold & Los Angeles & West & Salesperson & 12 & $82,100 \\ \hline 31 & & 550 & Afternoo & Ethan Arnold & Detroit & Midwest & Salesperson & 26 & $34,400 \\ \hline 32 & & 778 & Morning & Carissa Arnold & Dallas & South & Salesperson & 17 & $54,200 \\ \hline 33 & & 1155 & Afternoo & Garrett Arroyo & Phoenix & West & Salesperson & 18 & $68,100 \\ \hline 34 & & 251 & Morning & Rowena Ashley & Detroit & Midwest & Salesperson & 9 & $32,000 \\ \hline 35 & & 1037 & Afternoo & Zachery Atkinson & Phoenix & West & Salesperson & 3 & $65,700 \\ \hline 36 & & 90 & Afternoo & Shannon Avery & Philadelphia & East & Salesperson & 15 & $33,400 \\ \hline 37 & & 921 & Morning & Josefa Avery & San Antonio & South & Salesperson & 24 & $82,300 \\ \hline 38 & & 1154 & Morning & Yvette Avery & Phoenix & West & Salesperson & 5 & $31,700 \\ \hline 39 & & 299 & Morning & Trudy Avila & Los Angeles & West & Salesperson & 25 & $79,500 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{1} & \multirow[t]{2}{*}{ A } & & c & \multirow[t]{2}{*}{ D } & \multirow[t]{2}{*}{E} & \multirow[t]{2}{*}{F} & \multirow[t]{2}{*}{ G } & \multirow[t]{2}{*}{H} & \multirow[t]{2}{*}{1} \\ \hline & & & & & & & & & \\ \hline 2 & & Employee \# & Shift & Name & Location & Region & Position & Experience & Salary \\ \hline 3 & & 131 & Morning & Deanne Abbott & Philadelphia & East & Salesperson & 1 & $29,400 \\ \hline 4 & & 793 & Afternoo & Santos Adams & New York & East & Salesperson & 7 & $25,400 \\ \hline 5 & & 479 & Morning & Ronda Adkins & Phoenix & West & Salesperson & 10 & $82,200 \\ \hline 6 & & 609 & Afternoo & Kory Adkins & Chicago & Midwest & Salesperson & 5 & $73,000 \\ \hline 7 & & 652 & Morning & Charlene Adkins & Houston & South & Salesperson & 23 & $61,200 \\ \hline 8 & & 675 & Afternoo & Tracy Aguilar & Chicago & Midwest & Salesperson & 16 & $27,200 \\ \hline 9 & & 1057 & Afternoo & Marquis Aguilar & Houston & South & Intern & 0 & $14,300 \\ \hline 10 & & 543 & Morning & Regina Aguirre & Los Angeles & West & Salesperson & 13 & $62,600 \\ \hline 11 & & 636 & Morning & Francesca Alexander & New York & East & Salesperson & 14 & $48,200 \\ \hline 12 & & 258 & Morning & Reba Allen & Chicago & Midwest & Salesperson & 5 & $43,500 \\ \hline 13 & & 821 & Morning & Hattie Allison & San Antonio & South & Salesperson & 17 & $62,500 \\ \hline 14 & & 907 & Afternoo & Luke Allison & Chicago & Midwest & Salesperson & 16 & $76,900 \\ \hline 15 & & 1118 & Morning & Bernadine Allison & Chicago & Midwest & Salesperson & 9 & $69,900 \\ \hline 16 & & 69 & Morning & Latoya Alvarado & Los Angeles & West & Salesperson & 9 & $84,700 \\ \hline 17 & & 111 & Morning & Charmaine Alvarado & Dallas & South & Salesperson & 27 & $46,500 \\ \hline 18 & & 306 & Morning & Angie Alvarado & Chicago & Midwest & Intern & 1 & $7,100 \\ \hline 19 & & 801 & Afternoo & Rubin Alvarado & Los Angeles & West & Salesperson & 16 & $71,300 \\ \hline 20 & & 1176 & Morning & Susie Alvarez & Houston & South & Salesperson & 30 & $60,300 \\ \hline 21 & & 647 & Morning & Nettie Andersen & Dallas & South & Salesperson & 20 & $78,600 \\ \hline 22 & & 759 & Morning & Deena Andersen & Detroit & Midwest & Salesperson & 10 & $38,000 \\ \hline 23 & & 891 & Morning & Sofia Andersen & Houston & South & Salesperson & 10 & $74,900 \\ \hline 24 & & 1107 & Morning & Cherie Andersen & Dallas & South & Salesperson & 3 & $50,000 \\ \hline 25 & & 300 & Afternoo & August Andrade & San Antonio & South & Salesperson & 4 & $40,300 \\ \hline 26 & & 656 & Morning & Johanna Andrade & Los Angeles & West & Salesperson & 13 & $44,300 \\ \hline 27 & & 213 & Morning & Sophie Arellano & New York & East & Salesperson & 9 & $28,600 \\ \hline 28 & & 1064 & Afternoo & Garrett Arias & Houston & South & Salesperson & 29 & $67,100 \\ \hline 29 & & 852 & Afternoo & Vince Armstrong & Dallas & South & Salesperson & 5 & $80,600 \\ \hline 30 & & 56 & Afternoo & Jeremy Arnold & Los Angeles & West & Salesperson & 12 & $82,100 \\ \hline 31 & & 550 & Afternoo & Ethan Arnold & Detroit & Midwest & Salesperson & 26 & $34,400 \\ \hline 32 & & 778 & Morning & Carissa Arnold & Dallas & South & Salesperson & 17 & $54,200 \\ \hline 33 & & 1155 & Afternoo & Garrett Arroyo & Phoenix & West & Salesperson & 18 & $68,100 \\ \hline 34 & & 251 & Morning & Rowena Ashley & Detroit & Midwest & Salesperson & 9 & $32,000 \\ \hline 35 & & 1037 & Afternoo & Zachery Atkinson & Phoenix & West & Salesperson & 3 & $65,700 \\ \hline 36 & & 90 & Afternoo & Shannon Avery & Philadelphia & East & Salesperson & 15 & $33,400 \\ \hline 37 & & 921 & Morning & Josefa Avery & San Antonio & South & Salesperson & 24 & $82,300 \\ \hline 38 & & 1154 & Morning & Yvette Avery & Phoenix & West & Salesperson & 5 & $31,700 \\ \hline 39 & & 299 & Morning & Trudy Avila & Los Angeles & West & Salesperson & 25 & $79,500 \\ \hline \end{tabular}