Apothecary Sales Rep List \begin{tabular}{|c|c|c|c|l|c|c|r|r|r|} \hline Region & Div & Dist & Rep & Lname & Fname & Gender & Age & Sales & Quota \\ \hline 2 & B & 2 & 101 Knight & Tonya & F & 31 & 2,167,301 & 3,000,000 \\ \hline 1 & A & 2 & 108Li & Chang & M & 25 & 4,544,023 & 5,000,000 \\ \hline 3 & B & 2 & 120 Law & Sam & F & 58 & 4,893,014 & 5,000,000 \\ \hline 1 & B & 2 & 207 Free & Lucy & F & 32 & 3,718,292 & 4,000,000 \\ \hline 1 & B & 2 & 208 Great & Jim & M & 37 & 989,483 & 2,000,000 \\ \hline 2 & A & 3 & 210 May & Rodney & M & 23 & 2,565,942 & 3,000,000 \\ \hline 1 & B & 1 & 212 Lempke & Pat & M & 56 & 5,560,345 & 6,000,000 \\ \hline 3 & B & 2 & 298 Patel & Gandhi & M & 29 & 2,109,583 & 2,000,000 \\ \hline 2 & B & 2 & 299 Fenner & John & M & 32 & 3,693,219 & 5,000,000 \\ \hline 3 & A & 3 & 312 Penny & Josh & M & 32 & 2,210,459 & 3,000,000 \\ \hline 1 & A & 1 & 313 George & Doreen & F & 35 & 8,300,845 & 10,000,000 \\ \hline 3 & A & 1 & 406 Lopes & Pedro & M & 45 & 6,921,032 & 5,000,000 \\ \hline 3 & A & 1 & 432 Wheatly & Jane & F & 65 & 1,034,054 & 2,000,000 \\ \hline \end{tabular} 1. Convert the data in Cells A12:J25 into Table 2. Add Total row to show the count of Gender column, the average in Age column, and sums in the Sales and Quota columns as shown above. 3. Use the Advanced Filter function to extract data with criteria (Region=3, Gender=M, and Quota> =3,000,000 ). Place the criteria under the Criteria Range section and place the results starting on row 30. Criteria Range Anothecarv Sales Rep List