I need help with the following please.

Mid-Level Exercises 1 Biology Department Teaching Schedule As the department head of the biology department at a university, you prepare and finalize the faculty teaching schedule. Scheduling preparation takes time because you must ensure that you do not book faculty for different courses at the same time or double-book a classroom with two different classes. You downloaded the Spring 2015 schedule as a starting point and edited it to prepare the Spring 2016 schedule, and now you need to sort and filter the schedule to review it from several perspectives. a. Open e04m 1 Classes and save it as e04ml Classes_LastFirst. b. Freeze the panes so that the column labels do not scroll offscreen. c. Convert the data to a table and name the table Spring2016. d. Apply Table Style Light 14 to the table. DISCOVER H e. Sort the table by Instructor, then Days, and then Start Time. Create a custom sort order for Days so that it appears in this sequence: MTWR, MWF, MW, M, W, F, TR, T, R. (The day abbreviations are as follows: M = Monday, T = Tuesday, W = Wednesday, R = Thursday, F = Friday.) f. Remove duplicate records from the table. Excel should find and remove three duplicate records. g. Copy the Faculty sheet, place the copied worksheet to the right of the Faculty sheet, and then rename the duplicate worksheet Rooms. Sort the data in the Rooms sheet by Room in ascending order, then by Days using the custom sort order you created in step e, and finally by Start Time from earliest to latest time. h. Copy the Rooms sheet, place the copied worksheet to the right of the Rooms sheet, and then rename the duplicate worksheet Prime Time. i. Filter the table in the Prime Time sheet to show only classes scheduled on any combination of Monday, Wednesday, and Friday. Include classes that meet four days a week (MTWR). Do not include any other combination of Tuesday or Thursday classes, though. Also filter the table by classes that start between 9:00 AM and 12:00 PM. The status bar indicates 20 of 75 records found. j. Insert a field on the right side of the Credits field in the Faculty sheet. Type the label Capacity. Insert a lookup function that looks up the room number, compares it to the lookup table in the Room Capacity worksheet, and returns the room capacity. Make sure the function copies down the entire column. k. Select the first three sheet tabs and set 0.2" left and right margins, Landscape orientation, and 95% scaling. Repeat the column labels on all pages. On the Faculty sheet, decrease some column widths so that the Capacity column will print on the same page as the other columns. I. Display the Faculty sheet in Page Break Preview. Adjust any page breaks so that classes for a par- ticular instructor do not split between pages. m. Display the Rooms sheet in Page Break Preview. Adjust any page breaks so that classes for a par- ticular room do not split between pages, if necessary. Set the worksheet to print 1 page wide and 3 pages tall. n. Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of all four sheets. o. Save and close the workbook, and submit based on your instructor's directions.A B C D E F G H K ID Prefix Course Section Course Name Days Start Time End Time Room Instructor Credits 2 11685 BIOL 1010 101 General Biology MWF 7:00 AM 7:50 AM SCI 115 Bergstedt, Jenny A 3 15651 BIOL 1010 107 General Biology MWF 9:00 AM 9:50 AM SCI 117 Heaton, Daren N 4 15320 BIOL 1010 108 General Biology TR 8:30 AM 9:45 AM SCI 117 Heaton, Daren N 5 19744 BIOL 1010 105 General Biology MWF 9:00 AM 9:50 AM SCI 115 Johnson, Edith L. 11482 BIOL 1010 113 General Biology MWF 12:00 PM 12:50 PM SCI 115 Johnson, Edith L. 19483 BIOL 1010 114 General Biology MWF 12:00 PM 12:50 PM SCI 117 Klopping, Ingrid M. 8 11711 BIOL 1010 102 General Biology TR 7:00 AM 8:15 AM SCI 115 Lawrence, Margarent 9 13505 BIOL 1010 104 General Biology TR 8:30 AM 9:45 AM SCI 115 Lawrence, Margarent 10 19838 BIOL 1010 502 General Biology TR 2:30 PM 3:45 PM SCI 117 Martinez, Carlotta 11 13136 BIOL 1010 106 General Biology MWF 10:00 AM 10:50 AM SCI 115 Naegle, Paul K. 12 16828 BIOL 1010 111 General Biology MWF 11:00 AM 11:50 AM SCI 115 Naegle, Paul K. P P P P W W W W W W W W W W W W W W W W W W 13 16849 BIOL 1010 116 General Biology TR 1:00 PM 2:15 PM SCI 117 Naegle, Paul K. 14 18113 BIOL 1010 501 General Biology TR 7:00 PM 8:15 PM SCI 115 Reynolds, Stephanie Beth 15 17146 BIOL 1010 115 General Biology MWF 1:00 PM 1:50 PM SCI 117 Siosi, Taulanga 16 12672 BIOL 1010 103 General Biology TR 7:00 AM 8:15 AM SCI 117 STAFF 17 14016 BIOL 1010 112 General Biology TR 11:30 AM 12:45 PM SCI 115 Sun, Hing 18 15930 BIOL 1010 110 General Biology TR 10:00 AM 11:15 AM SCI 115 Wagner, Vivian J 19 13705 BIOL 1010 109 General Biology MWE 10:00 AM 10:50 AM SCI 117 Wagner, Vivian J 20 14184 BIOL 1015 102 General Biology Laboratory M 1:00 PM 2:50 PM SCI 210 Ellsworth, Stephen K. 21 19801 BIOL 1015 501 General Biology Laboratory R 6:00 PM 7:50 PM SCI 210 Ellsworth, Stephen K 22 18554 BIOL 1015 101 General Biology Laboratory M 11:00 AM 12:50 PM SCI 210 Johnson, Edith L. 23 16342 BIOL 1015 103 General Biology Laboratory W 1:00 PM 2:50 PM SCI 210 STAFF 24 11590 BIOL 1610 103 College Biology I MW 1:00 PM 2:50 PM SCI 115 Klopping, Ingrid M. 25 11590 BIOL 1610 103 College Biology I MW 1:00 PM 2:50 PM SCI 115 Klopping, Ingrid M. 26 18455 BIOL 1610 106 College Biology I MW 4:00 PM 5:50 PM SCI 115 Klopping, Ingrid M. 27 15687 BIOL 1610 101 College Biology I MTWR 8:00 AM 8:50 AM SCI 117 Martinez, Carlotta 28 12136 BIOL 1610 102 College Biology I MTWR 11:00 AM 11:50 AM SCI 117 Martinez, Carlotta 29 12843 BIOL 1610 501 College Biology I TR 5:00 PM 6:40 PM SCI 115 Matthews, Cascandra D. 30 14448 BIOL 1610 104 College Biology I TR 1:00 PM 2:50 PM SCI 115 Sherbotie, Geraldine Mary 31 13404 BIOL 1610 105 College Biology I MWF 8:00 AM 8:50 AM SCI 115 Sherbotie, Geraldine Mary 32 18698 BIOL 1615 103 College Biology I Laboratory R 7:00 AM 9:50 AM SCI 210 Ellsworth, Stephen K. 33 12948 BIOL 1615 102 College Biology I Laboratory W 7:00 AM 9:50 AM SCI 210 Fredrickson, Cynthia Marie 34 16437 BIOL 1615 106 College Biology I Laboratory W 10:00 AM 12:50 PM SCI 210 Fredrickson, Cynthia Marie 35 12258 BIOL 1615 105 College Biology | Laboratory 10:00 AM 12:50 PM SCI 210 Johnson, Edith L. 36 18254 BIOL 1615 108 College Biology I Laboratory 1:00 PM 3:50 PM SCI 210 Johnson, Edith L. 37 13075 BIOL 1615 110 College Biology | Laboratory W 5:00 PM 7:50 PM SCI 210 Pinkard, Alesha M. 38 18781 BIOL 1615 107 College Biology | Laboratory 10:00 AM 12:50 PM SCI 210 Reynolds, Stephanie Beth 39 11320 BIOL 1615 109 College Biology I Laboratory 1:00 PM 3:50 PM SCI 210 Reynolds, Stephanie Beth 40 11178 BIOL 1615 104 College Biology I Laboratory 7:00 AM 9:50 AM SCI 210 STAF 41 17513 BIOL 1615 111 College Biology I Laboratory 4:00 PM 6:50 PM SCI 210 STAFF 42 16146 BIOL 1615 101 College Biology I Laboratory 7:00 AM 9:50 AM SCI 210 STAFF W W HI 43 18861 BIOL 1620 101 College Biology II MWF 1:00 PM 1:50 PM SCI 119 Wagner, Vivian J 44 17020 BIOL 1620 102 College Biology II MWF 2:00 PM 2:50 PM SCI 119 Wagner, Vivian JA B C D F G H YYUBIICI) VIVIITS 45 19859 BIOL 1625 202 College Biology II Laboratory R 12:00 PM 1:50 PM SCI 210 Forester, Joshua Paul 46 11292 BIOL 1625 203 College Biology II Laboratory R 2:00 PM 3:50 PM SCI 210 Forester, Joshua Paul 47 19007 BIOL 1625 201 College Biology II Laboratory R 4:00 PM 5:50 PM SCI 210 Forester, Joshua Paul 48 12832 BIOL 1625 204 College Biology II Laboratory T 4:00 PM 5:50 PM SCI 210 Forester, Joshua Paul BIOL 1625 4:00 PM 5:50 PM SCI 210 Forester, Joshua Paul WHWWHAPPY 49 12832 204 College Biology II Laboratory T 50 18638 BIOL 2500 101 Environment Biology TR 11:30 AM 12:45 PM SCI 119 Lawrence, Margarent 51 19074 BIOL 3400 101 Cell Biology TR 10:00 AM 11:15 AM SCI 214 Sun, Hing 52 13440 BIOL 3405 201 Cell Biology Laboratory M 3:00 PM 5:50 PM SCI 214 Reynolds, Stephanie Beth 53 14261 BIOL 3500 601 Genetics M 6:00 PM 8:30 PM SCI 215 Blaszcak, Adam G 1 13822 BIOL 3500 101 Genetics MWF 9:00 AM 9:50 AM SCI 216 Bockelman, Travis K. 3 55 18790 BIOL 3500 102 Genetics MWF 12:00 PM 12:50 PM SCI 216 Bockelman, Travis K. 3 6 19160 BIOL 3505 201 Genetics Tutorial F 10:00 AM 10:50 AM SCI 215 Pinkard, Alesha M. 0.5 57 17007 BIOL 3505 202 Genetics Tutorial F 11:00 AM 11:50 AM SCI 215 Pinkard, Alesha M. 0.5 58 18621 BIOL 3505 203 Genetics Tutorial F 9:00 AM 9:50 AM SCI 215 STAFF 0.5 59 14636 BIOL 3505 801 Genetics Tutorial M 8:40 PM 9:30 PM SCI 215 STAFF 0.5 60 19473 BIOL 3515 201 Advanced Genetics Laboratory M 1:00 PM 3:00 PM SCI 215 Bockelman, Travis K. 61 16745 BIOL 3515 801 Advanced Genetics Laboratory W 6:00 PM 8:00 PM SCI 215 Bockelman, Travis K. 62 11724 BIOL 3550 601 Molecular Biology R 7:00 PM 9:30 PM SCI 215 Hughes, Jennifer E. 63 12015 BIOL 3550 101 Molecular Biology TR 10:00 AM 11:15 AM SCI 215 Reynolds, Stephanie Beth 64 16946 BIOL 3555 801 Experiments Molecular Biology T 7:00 PM 10:00 PM SCI 215 Hughes, Jennifer E 65 19754 BIOL 3555 201 Experiments Molecular Biol Lab F 7:00 AM 9:50 AM SCI 214 Naegle, Paul K. 66 15531 BIOL 3600 102 Biological Chemistry TR 2:30 PM 3:45 PM SCI 119 Heaton, Daren N 67 11867 BIOL 3600 101 Biological Chemistry MWF 9:00 AM 9:50 AM SCI 119 Warburton, Daren Zane 68 15472 BIOL 3605 202 Biochemistry Laboratory F 10:00 AM 1:50 PM SCI 214 Warburton, Daren Zane 69 19487 BIOL 3605 201 Biochemistry Laboratory F 2:00 PM 5:50 PM SCI 214 Warburton, Daren Zane W N A W W W W W W W H H W W H H W W H H 70 15639 BIOL 3700 101 General Ecology MWF 8:00 AM 8:50 AM SCI 119 Lawrence, Margarent 71 17973 BIOL 4200 101 Teaching Methods in Science WF 2:30 PM 3:45 PM ED 301 Pinkard, Alesha M. 72 16840 BIOL 4200 102 Teaching Methods in Science WF 4:00 PM 5:15 PM ED 301 Pinkard, Alesha M. 73 17308 BIOL 4500 101 Principles of Evolution MWF 10:00 AM 10:50 AM SCI 119 Matthews, Cascandra D. 74 18797 BIOL 4500 102 Principles of Evolution MWF 11:00 AM 11:50 AM SCI 119 Matthews, Cascandra D. 5 18797 BIOL 4500 102 Principles of Evolution MWF 11:00 AM 11:50 AM SCI 119 Matthews, Cascandra D. 76 16432 BIOL 4890 104 Student Research TBA TBA TBA TBA Heaton, Daren N 77 12806 BIOL 4890 103 Student Research TBA TBA TBA TBA Hughes, Jennifer E. 78 19784 BIOL 4890 101 Student Research TBA TBA TBA TBA Pinkard, Alesha M. 79 11485 BIOL 4890 102 Student Research TBA TBA TBA TBA Sherbotie, Geraldine Mary 80A B C D Room Capacity 2 ED 301 30 3 SCI 115 50 4 SCI 117 42 5 SCI 119 28 6 SCI 210 32 7 SCI 214 28 8 SCI 215 24 9 SCI 216 24 10