1. Enter a formula in cell M7 using the VLOOKUP function to find an exact match for the department abbreviation. Look up the department abbreviation (cell M6) using an absolute reference, search the staff table data (the range A6:J13) using an absolute reference, and return the department name (the 2nd column). (Please explain step by step)

2. Select the range A14:J14 and then add a thin top border to each cell using the Automatic color.

3. Copy the formula in cell M7 to the range M8:M15, and edit the copied formulas to return the value from the column indicated by the label in column L.

4. 

A B D E G H K L M N 1 Tallridge Regional Medical Center Staffing and Financial Summary by Department 2 3 4 Staff Department MD RN Support Total Turnover Turnover % 2021 Budget Department summary 28 Abbreviation 5 6 CCU 7 EMR 8 END 9 ICU 10 NEU 11 OBS 12 ONC 13 RAD 14 Coronary Care Emergency Endocrinology Intensive Care Neurology Obstetrics Oncology Radiology Total 5 12 3 17 6 6 8 27 6 22 15 17 3 8 106 15 33 4 15 8 17 9 72 13 54 29 43 17 37 293 4 21 0 5 1 3 8 4 4 46 14% $ 29% $ 0% $ 9% $ 3% $ 7% $ 47% $ 11% $ 15% $ 5,250,768 18,782,039 2,847,592 9,282,172 5,283,109 11,010,924 12,448,265 10,927,453 75,832,322 % change from 2020 5.20% 9.30% 0.20% 2.30% -1.50% 3.30% 6.10% 1.20% 3.26% Abbreviation Department MD RN Support Total Turnover Turnover % 2021 Budget % change from 2020 ICU Intensive Care 17 22 15 54 5 9% $9,282,172 9 5 2 59 27 128 2.30% Last update 15 16 17 19 5/13/21 2/26/21 Today's date