that's all there is

Address City Province Postal Code Location Street 1 2 3 3 4 7 5 3 9 10 11 12 13 14 15 16 1. Open the data file EL2-U1-SA2-LabRevenue-DataFile.xlsx that was provided with this projed. Save the file as El2-U2-SA2-LabRevenue 2. Add a header to all of the worksheets, it should include your name at the left and the sheet name at the right 3. The Revenue and Revenue Subtotal worksheets contains information for a diagnostic laboratory It tracks the doctor's ID, the doctor's name, the location numi where patients go to have their testing done, and the monthly revenue received from each location. The Locations workshoot contains the address information each location number 4. Search the Internet to find a diagnostic laboratory that is located in your city. Find five different locations around your city for this laboratory. On the Locations worksheet, fill in the missing address information Print the worksheet 5. In the Revenue worksheet, convert the laboratory revenue data to a table. Do not include the title Laboratory Revenue. Adjust each column width so that the headers can be read 6. Add a formula in column P to calculate the yearly revenue Provide an appropriate header and adjust the column width 7 Create a validation rule, input message and error alert for locations in the Revenue worksheet. The location must be 1.2.3.4 or 5 8. Filter the data to show only Location 1 Print page 1 9. Make the Revenue Subtotal worksheet active Calculate subtotals for each month and calculate yearly revenue at each change in name Adjust column widths where needed and then display the second outline level . Print page 1 10 Create a copy of the Revenue Subtotal worksheet and rename the copy Pivot Table Data On the Pivot Table Data worksheet, remove the subtotaling Create a Pivot Table report on a new page to summarize the revenue received by each doctor (Name) for January February, and March Change the sheet name to Pivot Table 11. Add a PivotChart below the Pivot Table using a column style Add an appropriate title to the PivotChart high point 12. In Column E of the Plvot Table worksheet, create an appropriate Sparkline Show 13. Add a header to the worksheet, it should include your name at the left and the sheet name at the right 14. Adjust the worksheet so that it prints on one page and print the worksheet. D N P R Jun 358 20 Jul 349 Sep Au 299 45 Dec Nov 678 21 20 Oct 450 32 17 167 19 156 99 134 189 23 45 112 371 50 147 312 202 147 180 202 2 ID Name Laboratory Revenue Location 3 5001 Dr. Jon Macintre Jan Feb Mar Apr May 4 1 5001 Dr. Jon Macintre 546 678 789 621 5 487 2 5001 Dr. Jon Macintre 20 25 21 31 3 45 5001 Dr Jon Macintre 7 4 24 5001 Dr. Jon Macintre 102 167 189 199 5 8 5002 De Ba McGliudy 1 9 5002 Dr. McGlicudy 13 2 10 5002 Dr Ba Milicudy 3 115002 Dr Ba McGlicudy 33 38 34 44 58 4 12 5002 Dr & McGilicudy 169 115 180 202 212 5 559 11 2009 gre Brun 691 802 634 500 1 2 14, 500, Happ 2 169 115 149 De, 180 202 212 3 23 16 5003 Dr. Sam Brown 4 516 648 759 591 457 004 Dr 5 31 36 32 42 18 5004 Dr. Ja Graham 1 111 116 112 122 138 19 5004 Dr. Graham 2 1 20100GF 220 272 337 350 309 15004 Dr | Gira 253 199 296 2004 Dr. Cart 23 5005 Dr. Jack Blundell 1 543 189 554 586 245005 Dr. Jack Blundet 25 5005 Dr. Jack Blundel 189 140 201 233 257 25 5005 Or Jack Blundell lie 233 275 313 27 5005 Dr Jack Blundel 25 28 5000 Dr Gertrude Felder 16 - 29 5000 Dr. Gertrude Felder 2 156 157 187 181 30 5000 Dr. Gertrude Folder 3 496 442 Eng 529 530 31 5000 Dr. Gertrude Felder 43 174 32 5006 Dr Gertrude Header 175 105 199 Locations Revenue Revenue Subtotal 328 2.,23,,8, 648 88,,, 269 56 1.36 = 16g~50 9: :":""gal 111 ,..... - , ,E-R,5,,,, 269 190 272 304 231 :".. wu, 337 254 Be 359 2000 dg2,91,, 521 554 578 122 192 220 212 255 181 474 19 439 709 O P Location Feb Jan 546 20 Laboratory Revenue Mar Apr May 789 521 487 21 31 45 24 167 189 199 Jun 358 20 Jul 349 10 Aug 299 45 Sep 320 20 Oct 450 Nov 678 21 Dec 765 25 is 156 102 99 102 134 156 180 17 167 10 - 209 15 17 3 4 5 1 2 3 4 5 1 2 - 13 - 34 180 802 33 169 559 44 212 500 115 891 2. 115 50 147 312 3 169 292 115 362 634 371 463 222 773 180 212 147 222 180 23 518 31 111 848 457 2. ID Name 3 5001 Dr Jon Macintre 4 5001 Dr Jon Macintre 5 5001 Or Jon Machtre 6 5001 Or Jon Macintre 75001 Dr. Jon Macintre B 5002 Dr. Ba McGcudy 9 5002 Or BMcGiudy 10 5002 Or Ba Melicudy 115002 Dr. Ba McGilicudy 12 5002 Or Ba Melicudy 13 5003 Dr Sam Brown 14 5003 Or Sam Brown 15 5003 Dr. Sam Brown 165003 Dr. Sam Brown 17 5003 Dr Sam Brown 18 5004 Dr J Graham 19 5004 Dr Graham 205004 Dr Graham 21 5004 Drs Graham 22 5004 DE JOnham 23 5005 Dr Jack Blundel 24 5005 Dr. Jack Blundell 25 500S Dr Jack Blundel 28 5005 Or Jack Blundel 27 5005 Dr. Jack Blundel 28 5006 Dr Gertrude Felder 29 5005 Dr Gertrud Feader 305006 Dr. Gertrude Felder 315005 Dr. Gertrude velder 32 500S Dr Gertrude Folder Locations 735 759 32 112 269 50 138 42 101 4 5 1 2 3 4 5 1 2 131 116 1 272 199 359 326 253 gle.NEW E90 ::: 326 , 337 284 ARE.3.28 8.8 1982. 8.99 9.688.818...8 272 100 304 231 ,,m 93,3,58., * SAA.2018 549 489 554 521 189 192 248 313 23 145 4 5 1 2 3 4 $ 189 160 201 220 175 233 25 18 150 301 157 196 442 307 43 174 579 175 Revenus Subtotal 181 474 27 119 174 104 Revence 27 Address City Province Postal Code Location Street 1 2 3 3 4 7 5 3 9 10 11 12 13 14 15 16 1. Open the data file EL2-U1-SA2-LabRevenue-DataFile.xlsx that was provided with this projed. Save the file as El2-U2-SA2-LabRevenue 2. Add a header to all of the worksheets, it should include your name at the left and the sheet name at the right 3. The Revenue and Revenue Subtotal worksheets contains information for a diagnostic laboratory It tracks the doctor's ID, the doctor's name, the location numi where patients go to have their testing done, and the monthly revenue received from each location. The Locations workshoot contains the address information each location number 4. Search the Internet to find a diagnostic laboratory that is located in your city. Find five different locations around your city for this laboratory. On the Locations worksheet, fill in the missing address information Print the worksheet 5. In the Revenue worksheet, convert the laboratory revenue data to a table. Do not include the title Laboratory Revenue. Adjust each column width so that the headers can be read 6. Add a formula in column P to calculate the yearly revenue Provide an appropriate header and adjust the column width 7 Create a validation rule, input message and error alert for locations in the Revenue worksheet. The location must be 1.2.3.4 or 5 8. Filter the data to show only Location 1 Print page 1 9. Make the Revenue Subtotal worksheet active Calculate subtotals for each month and calculate yearly revenue at each change in name Adjust column widths where needed and then display the second outline level . Print page 1 10 Create a copy of the Revenue Subtotal worksheet and rename the copy Pivot Table Data On the Pivot Table Data worksheet, remove the subtotaling Create a Pivot Table report on a new page to summarize the revenue received by each doctor (Name) for January February, and March Change the sheet name to Pivot Table 11. Add a PivotChart below the Pivot Table using a column style Add an appropriate title to the PivotChart high point 12. In Column E of the Plvot Table worksheet, create an appropriate Sparkline Show 13. Add a header to the worksheet, it should include your name at the left and the sheet name at the right 14. Adjust the worksheet so that it prints on one page and print the worksheet. D N P R Jun 358 20 Jul 349 Sep Au 299 45 Dec Nov 678 21 20 Oct 450 32 17 167 19 156 99 134 189 23 45 112 371 50 147 312 202 147 180 202 2 ID Name Laboratory Revenue Location 3 5001 Dr. Jon Macintre Jan Feb Mar Apr May 4 1 5001 Dr. Jon Macintre 546 678 789 621 5 487 2 5001 Dr. Jon Macintre 20 25 21 31 3 45 5001 Dr Jon Macintre 7 4 24 5001 Dr. Jon Macintre 102 167 189 199 5 8 5002 De Ba McGliudy 1 9 5002 Dr. McGlicudy 13 2 10 5002 Dr Ba Milicudy 3 115002 Dr Ba McGlicudy 33 38 34 44 58 4 12 5002 Dr & McGilicudy 169 115 180 202 212 5 559 11 2009 gre Brun 691 802 634 500 1 2 14, 500, Happ 2 169 115 149 De, 180 202 212 3 23 16 5003 Dr. Sam Brown 4 516 648 759 591 457 004 Dr 5 31 36 32 42 18 5004 Dr. Ja Graham 1 111 116 112 122 138 19 5004 Dr. Graham 2 1 20100GF 220 272 337 350 309 15004 Dr | Gira 253 199 296 2004 Dr. Cart 23 5005 Dr. Jack Blundell 1 543 189 554 586 245005 Dr. Jack Blundet 25 5005 Dr. Jack Blundel 189 140 201 233 257 25 5005 Or Jack Blundell lie 233 275 313 27 5005 Dr Jack Blundel 25 28 5000 Dr Gertrude Felder 16 - 29 5000 Dr. Gertrude Felder 2 156 157 187 181 30 5000 Dr. Gertrude Folder 3 496 442 Eng 529 530 31 5000 Dr. Gertrude Felder 43 174 32 5006 Dr Gertrude Header 175 105 199 Locations Revenue Revenue Subtotal 328 2.,23,,8, 648 88,,, 269 56 1.36 = 16g~50 9: :":""gal 111 ,..... - , ,E-R,5,,,, 269 190 272 304 231 :".. wu, 337 254 Be 359 2000 dg2,91,, 521 554 578 122 192 220 212 255 181 474 19 439 709 O P Location Feb Jan 546 20 Laboratory Revenue Mar Apr May 789 521 487 21 31 45 24 167 189 199 Jun 358 20 Jul 349 10 Aug 299 45 Sep 320 20 Oct 450 Nov 678 21 Dec 765 25 is 156 102 99 102 134 156 180 17 167 10 - 209 15 17 3 4 5 1 2 3 4 5 1 2 - 13 - 34 180 802 33 169 559 44 212 500 115 891 2. 115 50 147 312 3 169 292 115 362 634 371 463 222 773 180 212 147 222 180 23 518 31 111 848 457 2. ID Name 3 5001 Dr Jon Macintre 4 5001 Dr Jon Macintre 5 5001 Or Jon Machtre 6 5001 Or Jon Macintre 75001 Dr. Jon Macintre B 5002 Dr. Ba McGcudy 9 5002 Or BMcGiudy 10 5002 Or Ba Melicudy 115002 Dr. Ba McGilicudy 12 5002 Or Ba Melicudy 13 5003 Dr Sam Brown 14 5003 Or Sam Brown 15 5003 Dr. Sam Brown 165003 Dr. Sam Brown 17 5003 Dr Sam Brown 18 5004 Dr J Graham 19 5004 Dr Graham 205004 Dr Graham 21 5004 Drs Graham 22 5004 DE JOnham 23 5005 Dr Jack Blundel 24 5005 Dr. Jack Blundell 25 500S Dr Jack Blundel 28 5005 Or Jack Blundel 27 5005 Dr. Jack Blundel 28 5006 Dr Gertrude Felder 29 5005 Dr Gertrud Feader 305006 Dr. Gertrude Felder 315005 Dr. Gertrude velder 32 500S Dr Gertrude Folder Locations 735 759 32 112 269 50 138 42 101 4 5 1 2 3 4 5 1 2 131 116 1 272 199 359 326 253 gle.NEW E90 ::: 326 , 337 284 ARE.3.28 8.8 1982. 8.99 9.688.818...8 272 100 304 231 ,,m 93,3,58., * SAA.2018 549 489 554 521 189 192 248 313 23 145 4 5 1 2 3 4 $ 189 160 201 220 175 233 25 18 150 301 157 196 442 307 43 174 579 175 Revenus Subtotal 181 474 27 119 174 104 Revence 27