Finance, Vlook Excel

 The Nurse Leadership team at Medical Center Hospital, working with each department, has agreed on a listing of color designated scrubs uniforms based on the employee’s home department.  The listing is:  Maternal Child: Navy tops / Navy bottoms  Therapy Services: Red tops / Black bottoms  Pharmacy: Galaxy Blue tops & bottoms  Respiratory: Royal Blue tops & bottoms  Lab: Wine tops / Olive bottoms  Med Surg Floors: Seal Blue tops & bottoms The following employees have been hired recently and report to orientation on the first Monday of the month.  What color uniforms should they wear to orientation?  Gabriella M. – Pharmacy  Tammy G. – Therapy  Debra V. – Respiratory  Matthew D. – Lab  Maricar P. – Lab  Joann D. – Med Surg  Eva W. – Maternal Child The Excel file UniformColor.xls has been started for your use.  Create a nested IF formula to lookup the correct color for each employee.  Next, create a VLOOKUP formula to do the same.  Both formulas should use range names within the formulas 

Excel Chapter 12 Assignment 

The Nurse Leadership team at Medical Center Hospital, working with each department, has agreed on a 

listing of color designated scrubs uniforms based on the employee’s home department.  The listing is: 

 Maternal Child: Navy tops / Navy bottoms   Therapy Services: Red tops / Black bottoms   Pharmacy: Galaxy Blue tops & bottoms   Respiratory: Royal Blue tops & bottoms   Lab: Wine tops / Olive bottoms   Med Surg Floors: Seal Blue tops & bottoms 

The following employees have been hired recently and report to orientation on the first Monday of the 

month.  What color uniforms should they wear to orientation? 

 Gabriella M. – Pharmacy   Tammy G. – Therapy   Debra V. – Respiratory   Matthew D. – Lab   Maricar P. – Lab   Joann D. – Med Surg   Eva W. – Maternal Child 

The Excel file UniformColor.xls has been started for your use.  Create a nested IF formula to lookup the 

correct color for each employee.  Next, create a VLOOKUP formula to do the same.  Both formulas 

should use range names within the formulas.  Submit your file with the naming convention – Last Name 

UniformColor for grading. 

Rubric: 

 Range Names Used – 0.6 points   IF Formula correct – 1.2 points   VLOOKUP Formula correct – 1.2 points 

Order a similar paper and get 15% discount on your first order with us

Dr. Padma Myers
Dr. Padma Myers
98% Success Rate
Read More
“Hello, I deliver nursing papers on time following instructions from the client. My primary goal is customer satisfaction. Welcome for plagiarism free papers”
Stern Frea
Stern Frea
98% Success Rate
Read More
Hi! I am an English Language and Literature graduate; I have written many academic essays, including argumentative essays, research papers, and literary analysis.
Dr. Ishid Elsa
Dr. Ishid Elsa
98% Success Rate
Read More
"Hi, count on me to deliver quality papers that meet your expectations. I write well researched papers in the fields of nursing and medicine".
Dr. Paul P. Klug
Dr. Paul P. Klug
99% Success Rate
Read More
"A top writer with proven reliability and experience. I have a 99% success rate, overall rating of 10. Hire me for quality custom written nursing papers. Thank you"

How Our Essay Writing Service Works

Tell Us Your Requirements

Fill out order details and instructions, then upload any files or additional materials if needed. Then, confirm your order by clicking “Place an Order.”

Make your payment

Your payment is processed by a secure system. We accept Mastercard, Visa, Amex, and Discover. We don’t share any informati.on with third parties

The Writing Process

You can communicate with your writer. Clarify or track order with our customer support team. Upload all the necessary files for the writer to use.

Download your paper

Check your paper on your client profile. If it meets your requirements, approve and download. If any changes are needed, request a revision to be done.

Recent Questions

Stay In Touch!

Leave your email and get discount promo codes and the best essay samples from our writers!
Chat with us
WhatsApp Your Assignment!
Hello! Welcome! We have writers online to help you at any time!