A1 X V fx B C D E F G H Total Students Average Rate Total Due 10 1 FirstName LastName ClassStanding Subject TotalSessions Rate Date 12 Barrett Gonzales Sophomore Science 15 $50 1/10/18 13 Wang Vincent Junior Microsoft Office 10 $40 12/11/17 14 Daphne Buckner Junior Other $45 11/24/17 15 Irma Dickson Sophomore Microsoft Office 7 $25 11/25/17 16 Beard Senior Math 1 $35 9/3/17 17 Leroy Reeves Senior Other 11 $30 1/13/18 18 Ursa Price Senior Marketing 1 $45 4/20/18 19 Franks Senior Math S $45 3/26/18 20 Jena Lane Senior Microsoft Office 14 $35 4/17/18 21 Zenia Foreman Senior Microsoft Office 9 550 12/12/17 22 Stone Hicks Freshman Microsoft Office 11 $50 4/30/18 23 Samantha Kelley Freshman Microsoft Office 2 $50 10/3/17 24 Brenna Haney Junior Microsoft Office 1 $40 1/7/18 25 Hiram Calhoun Junior Microsoft Office 9 $30 2/28/18 26 Sonia Guthrie Freshman Microsoft Office 12 $45 4/11/18 27 Alana Mcmillan Junior Microsoft Office 11 $35 4/16/18 B Rebecca Holman Junior Microsoft Office 13 $40 2/3/18 29 Lara Roth Senior English 2 $50 10/31/17 30 Bruce Fitzgerald Senior Microsoft Office 14 $40 3/14/18 31 Seth Young Freshman Microsoft Office 6 $30 2/6/18 32 Tana Neal Sophomore Marketing S $40 9/14/17 33 Jamal Meyer Junior Microsoft Office 6 $25 3/26/18 34 Adena Henry Senior Math 7 $40 9/26/17 35 Rashad Guthrie Freshman Microsoft Office 14 $45 1/27/18 36 Chava Vang Senior Microsoft Office 8 $50 4/17/18 37 Alexa Alvarez Senior Science 1 $25 9/25/17 38 Shelby Herman Sophomore Math 13 $40 3/30/18 39 Christine Tyson Junior Other 9 $35 10/18/17 40 Renee Mcfadden Freshman Math 10 $45 12/6/17 41 Zachary Herman Sophomore Microsoft Office 3 $45 8/29/17 42 Karen Lynn Senior Math 14 $35 2/20/18 43 Warren Butler Freshman Math 11 $45 9/26/17 44 Moana Kline Junior Microsoft Office $35 10/20/17 45 Idola Hunt Junior Other $35 3/31/18 StudentData Filter Analysis +\fand b z to answer Pivot Analyst H A B D E F G C 1. Click the drop-down arlow in cell AZ and B2 to answer Pivot Analysis question 1. 3 2. Click the drop-down arrow in cell A4 to answer Pivot Analysis question 2. 5 3. Click the drop-down arrow in cell A6 to answer Pivot Analysis question 3. G 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 StudentData Filter Analysis +