EXCEL HELP Using version 16.53 Excel for Mac What formula are the talking about? The =lookup? I don't know if it's the p

Post by **answerhappygod** » Mon Jun 06, 2022 5:27 pm

EXCEL HELP
Using version 16.53 Excel for Mac
What formula are the talking about? The
=lookup? I don't know if it's the phrasing
but I just don't fully understand what I'm
supposed to do.
Below is what my sheet currently looks like

: Excel Help Using Version 16 53 Excel For Mac What Formula Are The Talking About The Lookup I Don T Know If It S The P 1 (39.33 KiB) Viewed 22 times

These are the instructions. I needhelp with both I guess
These are the instructions. I need
help with both I guess

: Excel Help Using Version 16 53 Excel For Mac What Formula Are The Talking About The Lookup I Don T Know If It S The P 2 (25.03 KiB) Viewed 22 times

And this (vvvvvvv) is what it's supposed tolook like.
And this (vvvvvvv) is what it's supposed to
look like.

: Excel Help Using Version 16 53 Excel For Mac What Formula Are The Talking About The Lookup I Don T Know If It S The P 3 (29.6 KiB) Viewed 22 times

0.0 2.... Home Insert Draw Page Layout Formulas Data Review fx Σ. Financial Loge Text & & & More Parc Tire arerence Talridge Regional Medical Center Staffing and Financial Summary by Department m port 1 29 71 38 34 29 41 27 37 Function 121 Department Comary Care 11 mastr 13 14 18 1 177 1 2 23 26 MO Documentation $ 12 1 SP 6 1 S 2 11 p " it 15 ST . . 101 Departments 35 31 4 23 17 . 27 138 Budget 295 4 21 0 3 3 3 NP EX19 CT CS1-4e StephanieCouto 2 De hare P Tap View Tell me Never 2013 34% 52501 S 75 On 2,347,39 $282, IN 385383,100 T AN 118 AIN'S 12400,200 1130433 713,333 Nchange 2010 5208 *** 3.300 2.30% 450 LIK kaps 1208 Fx №e thee Wich For Charing whe H V Ab Department m kpp T Tum 201 Schage from 3030 y YOU CN CC D 9 Formula Builder Sear Most Recently Used TODAY DATE SUM AVERAGE HYPERLINK COUNT MAX SIN S Al ABS Sx TODAY Syntax TODAY Qg Comments Insert Function the data formad Morelan histo

13. The Department summary table should look up the department abbreviation and return all of the data listed. It needs to be filled out. To begin, next to the cell listed "Department", use a function to search the staff table data (not including the row of headings and the total row) and return the department name based on the abbreviation above. The formula will be copied, so make sure it always references the abbreviation. 14. Copy the formula down to complete the Department summary table, and edit the copied formulas to return the values from the headings listed in the left-hand column.

Final Figure 1: Departments Worksheet Microsoft product screenshot reprinted with permission from Microsoft Incorporated. Copyright © 2018 Cengage Learning. All Rights Reserved. Tallridge Regional Medical Center Staffing and Financial Summary by Department Staff Abbreviation Department Tu 2011 B change from 2020 cou 8 15 28 145 5250,78 19%$ 18782,009 Departmentummary Abbreviation ICU Department Intensive Care MD n 7 IMR 8 IND 17 17 AN 22 ICU 10 NEU toes 0% 2,347,502 400.00 IN 55281,100 7% 511000024 6 15 Nursingy C 9 Support Total Tumover 17 ONC Oncology $ 47% 13 RAD 11% 19% 12,448.25 108274SS 75.832.322 14 Turnover 2021 Budget change from 2020 15 6/13/2021 Today's dete Documentation Departments Budget MD 3 12 * 27 22 15 17 1 104 4 15 . 17 . 22 120 72 13 14 29 41 17 37 199 21 0 5 1 3 . 9.30% 0.20% 3.30% LION 130% 6.30% 1.20% AHN 34 5 $8,282,372