please help me solve this excel question with explanation.

Visual Benchmark Demonstrate Your Proficiency v] USING TABLE AND DATA TOOLS IN A CALL LIST 1. Open WPMCallList.xlsx. 2. Save the workbook and name it EL2-C3-VB1-WPMCallList. 3. Format and apply data tools as required to duplicate the worksheet in Figure 3.10 using the following information: The worksheet has Table Style Medium 5 applied to the table range. Look closely at the sorted order. The table is sorted by three levels using the fields Designation, Hourly Rate, and Hire Date. Shift cost equals the hourly rate times 8 hours. Use Flash Fill to split the names into two columns. Include the Total row and apply the appropriate banded options. 4. Save, print, and then close EL2-C3-VB1-WPMCallList.xlsx. 2. USING SUBTOTALS IN A CALL LIST 1. Open EL2-C3-VB1-WPMCallList.xlsx 2. Save the workbook and name it EL2-C3-VB2-WPMCallList. 3. Create subtotals and view the revised worksheet at the appropriate level to display as shown in Figure 3.11 on the next page. 4. Save, print, and then close EL2-C3-VB2-WPMCallList.xlsx. Figure 3.10 Visual Benchmark 1 1 38.50 38.50 NO 952 Ne Rere Yes 10 11 12 1 14 Que 41 Dem Wellington Park Medical Center Nursing Division Casual Relief Callie Telepon 4/28/2000 555-345 No Yes 022/2002 555-6 Yes Yes Weeds only 10/8/2015 555-1279 Yes 10 2211998 532548 Yes Weekends only 99/2001 555-591 Yes 1110001 555- NO Yes No 4/27/19 -Y No No 8/15 200) 555-6663 Yes Weekends 555-164) Ne No 7/18 2005 555-4545 TES 5/14/2007 555-59 Yes 5/6/2011 555-1561 Yes Ves Ne 4/15 2012 555-5457 Yes Wes 4212005555-7183 Yes Yes N 1005 1997*3-613 No No To Weekends on 7/15/2005 555-013 Yes No Yes ArtRate and Shicos 21 1965 Sanderson 18642 Tone EN 78452 Terry EN 4515 David Featherstone 46955 Orlando RN 56983 Amanda Sanchez RY 17944 Fernando Este IN Bjor 95555 Sam IN Sing EN 58612 Savana 96721 Norte RN LPN 48652 Der 58164 Land Donne 90467 Nade About UN 35.00 22.50 22.50 > 22.50 22.50 22 50 22.50 21 308.00 308.00 308.00 280.00 250.00 280.00 264.00 180.00 10. INDO . I BODO 80.00 180.00 180.00 172.00 150.00 114.00 134.00 126.00 124.00 116.00 11 Wage NO 16 18 19 21 Yes 16.73 15.25 15.30 14.50 4. Save, print, and then close EL2-C3-VB2-WPMCallList.xlsx Figure 3.10 Visual Benchmark 1 Wellington Park Medical Center 5 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Payroll First Name Last Name Designation 19658 Paula Sanderson RN 38642 Tania Ravi RN 78452 Terry Mason RN 95523 Lynn Petre RN 45908 David Featherstone RN 46956 Orlando Zambian RN 56983 Amanda Sanchez RN 58429 Rene Quenneville RN 59417 Denis LaPierre RN 37944 Fernando Este RN 78647 Jay Bjorg RN 95558 Sam Vargas RN 98731 Zal Singh RN 58612 Savana RN 96721 Noreen Kalit RN 89367 Xiu Zheng LDN 14586 Alma Fernandez LPN 48652 Dana Casselman LPN 65412 Kelly Lund LPN 98164 Lana Bourne UPN 90467 Nadir Aboureen LPN 68415 Kelly O Brien LPN Nursin Division Casual Relief Call List Hire Date Telephone or Dp Day Shih Only Night Shift Only! Eithe Shift 428/2000 555-3485 No No No Yes 6/22/2002555-6969 Yes Yes No Weekends only 10/8/2015 555-1279 Yes NO Yes No 10/22/1998 555-2548 Yes Yes No Weekends only 9/9/2001 555-5961 No No No Yes 11/10/2001 555-1186 No Yes NO No 4/27/1999 555-4896 Yes No Yes No 8/15/2001 555-4661 Yes Yes No Weekends only 8/23/2003 555-8643 No No Yes No 7/18/2005 555-4545 No No No Yes 5/14/2007 555-6598 No No No Yes 1/2 2009 555.4571 No No No 5/6/2011 555-3561 Yes Yes No No 4/15/2012 555-8457 Yes No Weekends only 4/3/2009 555-1876 Yes Yes No No 4/21/2005 555-7383 Yes Yes No No 8/3/1997 555-7412 Yes No No Yes 10/13/1997 555-5325 Yes No No 11/19/1998 555-36B4 No Yes No Weekends only 7/15 2008 555-9012 Yes Yes No No 8/12/2006 555-9021 No No No Yes 120720122335-6344 No Yes NO Weekends only Average Hourly rate and Shin Costa Hourly Hate 38.50 38.50 38.50 35.00 35.00 35.00 33.00 22.50 22.50 22.50 22.50 22.50 22.50 22.50 21.50 18.75 Shift Cost 308.00 308.00 308.00 280.00 280.00 280.00 264.00 180.00 180.00 180.00 180.00 180.00 180.00 180.00 172.00 150.00 134.00 134.00 126.00 124.00 116.00 110.00 197911 Yes Yes 25 20 16,75 15.75 15.50 14.50 135 24.74 Figure 3.11 Visual Benchmark 2 Wellington Park Medical Center Nursing Division Casual Relief Call List Designation e Date Telephone Op Day Only! Night Only! RN Average LPN Average Grand Average Parol Last ther Hourly rate cost 28.83 230.57 15.96 127.70 24 74 197.91 27 26 Done WPMCallList (4 of 4) RN No RN No Payroll No. Name 14586 Alma Fernandez 19658 Paula Sanderson 37944 Fernando Este 38642 Tania Ravi 45968 David Featherstone 46956 Orlando Zambian 48652 Dana Casselman 56983 Amanda Sanchez 58612 Savana Ruiz 68429 Rene Quenneville 68475 Kelly O'Brien 69417 Denis LaPierre 78452 Terry Mason 78647 Jay Bjorg 85412 Kelly Lund 89367 Xiu Zheng 90467 Nadir Abouzeen 95558 Sam Vargas 96523 Lynn Pietre 96721 Noreen Kalir 98364 Lana Bourne 98731 Zail Singh Wellington Park Medical Center Nursing Division Casual Relief Call List Designation Hire Date Telephone OR Exp? Day Shift Only? Night Shift Only? Either Shift? LPN 8/3/97 555-7412 Yes No No Yes 4/28/00 555-3485 No No Yes RN 7/18/05 555-4545 No No No Yes RN 6/22/02 555-6969 Yes Yes No Weekends only RN 9/9/01 555-5961 No No No Yes 11/10/01 555.1186 No Yes No No LPN 10/15/97 555-6325 Yes No Yes RN 4/27/99 555-4896 Yes No Yes No RN 4/15/12 555-8457 No Yes Weekends only RN 8/15/03 555-4663 Yes Yes No Weekends only LPN 1/20/12 555-6344 No Yes No Weekends only RN 8/23/03 555-8643 No No Yes No RN 10/8/15 555-1279 Yes No Yes No RN 5/14/07 555-6598 No No No Yes LPN 11/19/98 555-3684 No Yes No Weekends only LPN 4/23/06 555-7383 Yes Yes No No LPN 8/12/08 555-9023 No No No Yes RN 3/2/09 555-4571 No No No Yes RN 10/22/98 555-2548 Yes Yes No Weekends only RN 4/3/09 555-1876 Yes Yes No No LPN 7/15/08 555-9012 Yes Yes No No RN 5/6/11 555-3561 Yes Yes No No Yes Hourly Rate 16.75 38.50 22.50 38.50 35.00 35.00 16.75 33.00 22.50 22.50 13.75 22.50 38.50 22.50 15.75 18.75 14.50 22.50 35.00 21.50 15.50 22.50 Visual Benchmark Demonstrate Your Proficiency v] USING TABLE AND DATA TOOLS IN A CALL LIST 1. Open WPMCallList.xlsx. 2. Save the workbook and name it EL2-C3-VB1-WPMCallList. 3. Format and apply data tools as required to duplicate the worksheet in Figure 3.10 using the following information: The worksheet has Table Style Medium 5 applied to the table range. Look closely at the sorted order. The table is sorted by three levels using the fields Designation, Hourly Rate, and Hire Date. Shift cost equals the hourly rate times 8 hours. Use Flash Fill to split the names into two columns. Include the Total row and apply the appropriate banded options. 4. Save, print, and then close EL2-C3-VB1-WPMCallList.xlsx. 2. USING SUBTOTALS IN A CALL LIST 1. Open EL2-C3-VB1-WPMCallList.xlsx 2. Save the workbook and name it EL2-C3-VB2-WPMCallList. 3. Create subtotals and view the revised worksheet at the appropriate level to display as shown in Figure 3.11 on the next page. 4. Save, print, and then close EL2-C3-VB2-WPMCallList.xlsx. Figure 3.10 Visual Benchmark 1 1 38.50 38.50 NO 952 Ne Rere Yes 10 11 12 1 14 Que 41 Dem Wellington Park Medical Center Nursing Division Casual Relief Callie Telepon 4/28/2000 555-345 No Yes 022/2002 555-6 Yes Yes Weeds only 10/8/2015 555-1279 Yes 10 2211998 532548 Yes Weekends only 99/2001 555-591 Yes 1110001 555- NO Yes No 4/27/19 -Y No No 8/15 200) 555-6663 Yes Weekends 555-164) Ne No 7/18 2005 555-4545 TES 5/14/2007 555-59 Yes 5/6/2011 555-1561 Yes Ves Ne 4/15 2012 555-5457 Yes Wes 4212005555-7183 Yes Yes N 1005 1997*3-613 No No To Weekends on 7/15/2005 555-013 Yes No Yes ArtRate and Shicos 21 1965 Sanderson 18642 Tone EN 78452 Terry EN 4515 David Featherstone 46955 Orlando RN 56983 Amanda Sanchez RY 17944 Fernando Este IN Bjor 95555 Sam IN Sing EN 58612 Savana 96721 Norte RN LPN 48652 Der 58164 Land Donne 90467 Nade About UN 35.00 22.50 22.50 > 22.50 22.50 22 50 22.50 21 308.00 308.00 308.00 280.00 250.00 280.00 264.00 180.00 10. INDO . I BODO 80.00 180.00 180.00 172.00 150.00 114.00 134.00 126.00 124.00 116.00 11 Wage NO 16 18 19 21 Yes 16.73 15.25 15.30 14.50 4. Save, print, and then close EL2-C3-VB2-WPMCallList.xlsx Figure 3.10 Visual Benchmark 1 Wellington Park Medical Center 5 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Payroll First Name Last Name Designation 19658 Paula Sanderson RN 38642 Tania Ravi RN 78452 Terry Mason RN 95523 Lynn Petre RN 45908 David Featherstone RN 46956 Orlando Zambian RN 56983 Amanda Sanchez RN 58429 Rene Quenneville RN 59417 Denis LaPierre RN 37944 Fernando Este RN 78647 Jay Bjorg RN 95558 Sam Vargas RN 98731 Zal Singh RN 58612 Savana RN 96721 Noreen Kalit RN 89367 Xiu Zheng LDN 14586 Alma Fernandez LPN 48652 Dana Casselman LPN 65412 Kelly Lund LPN 98164 Lana Bourne UPN 90467 Nadir Aboureen LPN 68415 Kelly O Brien LPN Nursin Division Casual Relief Call List Hire Date Telephone or Dp Day Shih Only Night Shift Only! Eithe Shift 428/2000 555-3485 No No No Yes 6/22/2002555-6969 Yes Yes No Weekends only 10/8/2015 555-1279 Yes NO Yes No 10/22/1998 555-2548 Yes Yes No Weekends only 9/9/2001 555-5961 No No No Yes 11/10/2001 555-1186 No Yes NO No 4/27/1999 555-4896 Yes No Yes No 8/15/2001 555-4661 Yes Yes No Weekends only 8/23/2003 555-8643 No No Yes No 7/18/2005 555-4545 No No No Yes 5/14/2007 555-6598 No No No Yes 1/2 2009 555.4571 No No No 5/6/2011 555-3561 Yes Yes No No 4/15/2012 555-8457 Yes No Weekends only 4/3/2009 555-1876 Yes Yes No No 4/21/2005 555-7383 Yes Yes No No 8/3/1997 555-7412 Yes No No Yes 10/13/1997 555-5325 Yes No No 11/19/1998 555-36B4 No Yes No Weekends only 7/15 2008 555-9012 Yes Yes No No 8/12/2006 555-9021 No No No Yes 120720122335-6344 No Yes NO Weekends only Average Hourly rate and Shin Costa Hourly Hate 38.50 38.50 38.50 35.00 35.00 35.00 33.00 22.50 22.50 22.50 22.50 22.50 22.50 22.50 21.50 18.75 Shift Cost 308.00 308.00 308.00 280.00 280.00 280.00 264.00 180.00 180.00 180.00 180.00 180.00 180.00 180.00 172.00 150.00 134.00 134.00 126.00 124.00 116.00 110.00 197911 Yes Yes 25 20 16,75 15.75 15.50 14.50 135 24.74 Figure 3.11 Visual Benchmark 2 Wellington Park Medical Center Nursing Division Casual Relief Call List Designation e Date Telephone Op Day Only! Night Only! RN Average LPN Average Grand Average Parol Last ther Hourly rate cost 28.83 230.57 15.96 127.70 24 74 197.91 27 26 Done WPMCallList (4 of 4) RN No RN No Payroll No. Name 14586 Alma Fernandez 19658 Paula Sanderson 37944 Fernando Este 38642 Tania Ravi 45968 David Featherstone 46956 Orlando Zambian 48652 Dana Casselman 56983 Amanda Sanchez 58612 Savana Ruiz 68429 Rene Quenneville 68475 Kelly O'Brien 69417 Denis LaPierre 78452 Terry Mason 78647 Jay Bjorg 85412 Kelly Lund 89367 Xiu Zheng 90467 Nadir Abouzeen 95558 Sam Vargas 96523 Lynn Pietre 96721 Noreen Kalir 98364 Lana Bourne 98731 Zail Singh Wellington Park Medical Center Nursing Division Casual Relief Call List Designation Hire Date Telephone OR Exp? Day Shift Only? Night Shift Only? Either Shift? LPN 8/3/97 555-7412 Yes No No Yes 4/28/00 555-3485 No No Yes RN 7/18/05 555-4545 No No No Yes RN 6/22/02 555-6969 Yes Yes No Weekends only RN 9/9/01 555-5961 No No No Yes 11/10/01 555.1186 No Yes No No LPN 10/15/97 555-6325 Yes No Yes RN 4/27/99 555-4896 Yes No Yes No RN 4/15/12 555-8457 No Yes Weekends only RN 8/15/03 555-4663 Yes Yes No Weekends only LPN 1/20/12 555-6344 No Yes No Weekends only RN 8/23/03 555-8643 No No Yes No RN 10/8/15 555-1279 Yes No Yes No RN 5/14/07 555-6598 No No No Yes LPN 11/19/98 555-3684 No Yes No Weekends only LPN 4/23/06 555-7383 Yes Yes No No LPN 8/12/08 555-9023 No No No Yes RN 3/2/09 555-4571 No No No Yes RN 10/22/98 555-2548 Yes Yes No Weekends only RN 4/3/09 555-1876 Yes Yes No No LPN 7/15/08 555-9012 Yes Yes No No RN 5/6/11 555-3561 Yes Yes No No Yes Hourly Rate 16.75 38.50 22.50 38.50 35.00 35.00 16.75 33.00 22.50 22.50 13.75 22.50 38.50 22.50 15.75 18.75 14.50 22.50 35.00 21.50 15.50 22.50