Please help with a step to step solution please note I already create the range name

. Create the range names for the data in columns as follows: (Column B Designation) (Column C Service) (Column D Diploma) (Column E Degree) (Column F Probationary) (Column G HRate ) (Column H Benefits) (Column I Cost ) ( K2:M4 RateTable)

.B. Create a formula (VLOOKUP) in column G that will fill in the correct hourly rate for each staff member based on his or her designation using an exact match. Use range names as appropriate. Make sure the formula is copied to all the rows as needed. 5 c. The hospital does not pay benefits if the employee is on probation. Create a formula (IF) in column H that will calculate the benefits cost as 28% of the hourly rate if the staff member is not probationary. Use range names as appropriate. Make sure the formula is copied to all the rows as needed. 4 d. Create a formula in column I that adds the hourly rate and benefit cost. Use range names as appropriate. Make sure the formula is copied to all the rows as needed

File Home Insert Page Layout Formulas Data Review View Help Share Comments X Insert Calibri 11 AA ab Wrap Text General T. 47 o DX Delete v Paste BIU Ideas A EE 3 Merge & Center $ - % ) 60 .00 .000 Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity 112 X for A B C D E F G H J K L M Total Cost Per RN Hourly RPN Hour Bonus Benefits Per Hour 24.50 Registered Practical Nurse Diploma Yes Designation Service NP 1 RN 2 RN 2 NP 1 RN 1 Degree No Yes Yes No Yes Hourly Probationary Rate Yes 23.50 No 35.75 No 35.75 No 23.50 Yes 35.75 Yes 24.50 No 35.75 Yes No Yes Yes 1 Yes No RPN RN 2 No Yes RN 2 Yes Yes No 35.75 RN 3 Yes Yes No 35.75 4 Name 5 Elaine Campbell 6 Paula Sanderson 7 Fernando Este 8 Tania Zavitz 9 David Featherstone 10 Dana Casselman 11 Amanda Sanchez 12 Savana Ruiz 13 Rene Quenneville 14 Kelly O'Brien 15 Terry Mason 16 Jay Bjorg 17 Kelly Lund 18 Xiu Zheng 19 Nadir Abouzeen 20 Sam Vargas 21 Lynn Pietre 22 Noreen Kalir 23 Lana Bourne 4 Yes No No 24.50 RPN RN 3 No Yes No 35.75 RN 1 Yes Yes Yes 35.75 23.50 1 Yes No Yes NP NP RPN 3 Yes No No Yes 23.50 24.50 2 No Yes RN 2 Yes Yes No RN 1 Yes Yes No 35.75 35.75 23.50 24.50 No Yes Yes 3 NP RPN No 2 No Yes Statistical Database Labs + Ready EO + 1009 HH Type here to search j c . X 2:37 PM 10/29/2020 File Home Insert Page Layout Formulas Data Review View Help Share Comments X Insert Calibri 11 AA ab Wrap Text General T. 47 o DX Delete v Paste BIU Ideas A EE 3 Merge & Center $ - % ) 60 .00 .000 Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity 112 X for A B C D E F G H J K L M Total Cost Per RN Hourly RPN Hour Bonus Benefits Per Hour 24.50 Registered Practical Nurse Diploma Yes Designation Service NP 1 RN 2 RN 2 NP 1 RN 1 Degree No Yes Yes No Yes Hourly Probationary Rate Yes 23.50 No 35.75 No 35.75 No 23.50 Yes 35.75 Yes 24.50 No 35.75 Yes No Yes Yes 1 Yes No RPN RN 2 No Yes RN 2 Yes Yes No 35.75 RN 3 Yes Yes No 35.75 4 Name 5 Elaine Campbell 6 Paula Sanderson 7 Fernando Este 8 Tania Zavitz 9 David Featherstone 10 Dana Casselman 11 Amanda Sanchez 12 Savana Ruiz 13 Rene Quenneville 14 Kelly O'Brien 15 Terry Mason 16 Jay Bjorg 17 Kelly Lund 18 Xiu Zheng 19 Nadir Abouzeen 20 Sam Vargas 21 Lynn Pietre 22 Noreen Kalir 23 Lana Bourne 4 Yes No No 24.50 RPN RN 3 No Yes No 35.75 RN 1 Yes Yes Yes 35.75 23.50 1 Yes No Yes NP NP RPN 3 Yes No No Yes 23.50 24.50 2 No Yes RN 2 Yes Yes No RN 1 Yes Yes No 35.75 35.75 23.50 24.50 No Yes Yes 3 NP RPN No 2 No Yes Statistical Database Labs + Ready EO + 1009 HH Type here to search j c . X 2:37 PM 10/29/2020