Interpret the following Excel statement in cell C2 regarding an employees annual performance rating Cell B2 contains the employees performance score Performance scores in cell C2 have been rounded to the nearest whole number IF(B2 249, Excellent , IF(B2 200, Good , IF(B2 150, Satisfactory , Poor ))) A If cell B2 contains a score higher than 249, then the text, Excellent will be displayed in cell C2 Otherwise, if cell B2 contains a score of 200 to 249 inclusive, then the text, Good will be displayed in cell C2 Otherwise, if cell B2 contains a score of 150 to 199 inclusive, then the text, Satisfactory will be displayed in cell C2 Otherwise, if cell B2 contains a score of 149 or below, then the text, Poor will be displayed in cell C2 B If cell B2 contains a score of 249 or higher, then the text, Excellent will be displayed in cell C2 Otherwise, if cell B2 contains a score of 200 to 248 inclusive, then the text, Good will be displayed in cell C2 Otherwise, if cell B2 contains a score of 150 to 199 inclusive, then the text, Satisfactory will be displayed in cell C2 Otherwise, if cell B2 contains a score of 149 or below, then the text, Poor will be displayed in cell C2 C If cell B2 contains a score higher than 250, then the text, Excellent will be displayed in cell C2 Otherwise, if cell B2 contains a score of 200 to 249 inclusive, then the text, Good will be displayed in cell C2 Otherwise, if cell B2 contains a score of 150 to 199 inclusive, then the text, Satisfactory will be displayed in cell C2 Otherwise, if cell B2 contains a score of 149 or below, then the text, Poor will be displayed in cell C2 D If cell B2 contains a score higher than 250, then the text, Excellent will be displayed in cell C2 Otherwise, if cell B2 contains a score of 200 to 250 inclusive, then the text, Good will be displayed in cell C2 Otherwise, if cell B2 contains a score of 150 to 200 inclusive, then the text, Satisfactory will be displayed in cell C2 Otherwise, if cell B2 contains a score of 149 or below, then the text, Poor will be displayed in cell C2

The Answer is in the image, click to view ...

Question: Interpret the following Excel statement in cell C2 regarding an employees annual performance rating. Cell B2 contains the employees performance score. Performance scores in cell

Interpret the following Excel statement in cell C2 regarding an employees annual performance rating. Cell B2 contains the employees performance score. Performance scores in cell C2 have been rounded to the nearest whole number. =IF(B2>249, "Excellent", IF(B2>=200, "Good", IF(B2>=150, "Satisfactory", "Poor ")))

A.		If cell B2 contains a score higher than 249, then the text, Excellent will be displayed in cell C2. Otherwise, if cell B2 contains a score of 200 to 249 inclusive, then the text, Good will be displayed in cell C2. Otherwise, if cell B2 contains a score of 150 to 199 inclusive, then the text, Satisfactory will be displayed in cell C2. Otherwise, if cell B2 contains a score of 149 or below, then the text, Poor will be displayed in cell C2.
B.		If cell B2 contains a score of 249 or higher, then the text, Excellent will be displayed in cell C2. Otherwise, if cell B2 contains a score of 200 to 248 inclusive, then the text, Good will be displayed in cell C2. Otherwise, if cell B2 contains a score of 150 to 199 inclusive, then the text, Satisfactory will be displayed in cell C2. Otherwise, if cell B2 contains a score of 149 or below, then the text, Poor will be displayed in cell C2.
C.		If cell B2 contains a score higher than 250, then the text, Excellent will be displayed in cell C2. Otherwise, if cell B2 contains a score of 200 to 249 inclusive, then the text, Good will be displayed in cell C2. Otherwise, if cell B2 contains a score of 150 to 199 inclusive, then the text, Satisfactory will be displayed in cell C2. Otherwise, if cell B2 contains a score of 149 or below, then the text, Poor will be displayed in cell C2.
D.		If cell B2 contains a score higher than 250, then the text, Excellent will be displayed in cell C2. Otherwise, if cell B2 contains a score of 200 to 250 inclusive, then the text, Good will be displayed in cell C2. Otherwise, if cell B2 contains a score of 150 to 200 inclusive, then the text, Satisfactory will be displayed in cell C2. Otherwise, if cell B2 contains a score of 149 or below, then the text, Poor will be displayed in cell C2.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

ID Salary Compa- Midpoint ratio Age Performance Service Gender Rating Raise Degree Gender Grade 1 Copy Employee Data set to this page. The ongoing question that the weekly assignments will focus on...

Week 1 Lecture 1 Class Approach to Statistics Statistics is basically a set of tools that allow us to get information out of data sets (we will get to the more formal definition below). As such, it...

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 65.1 27 36.1 61.4 46.6 73.3 39.7 23.2 74.6 22.8 23.4 62 40.7 23 24 51.1...

The objectives of this course were 1) to help you assess your existing leadership strengths and weaknesses, and 2) to help you develop a plan to address one or more leadership goal(s). The...

Set Week Three During this week, we will look at ways of testing multiple (more than two) data samples at the same time. We will continue to use the data and assignment file that we opened in Week 2,...

First Edition Actuarial Excel Data Analytics and Applications Guangwei Fan Guodong Li Jinfeng Wei Preface This iBook was written based on lecture notes from courses on actuarial technology and from...

The instructions are attached in the Division Performance Evaluation Division Performance Evaluation Project Using Excel In this assignment you will analyze the performance of PepsiCo or Marriott's...

ID Salary Compa Midpoint Age 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 66.6 26.4 35.3 56 47.5 75.5 41.5 22.8 74 24.1 23.6 63.4 41.4 23 23.6 44.1...

ID Salary Compa Midpoint Age 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 60 26.8 34.7 57.9 48.5 74.3...

Master Budget and Responsibility Accounting Kaizen approach to activity-based budgeting The Jerico store of Jiffy Mart, a chain of small neighborhood convenience stores, is preparing its...

What is the INB of III vs. Il if = 100? There are three 3-month-long options to treat studentitis, a depression-like condi- tion in which a student thinks he or she will be in college forever with no...

Imagine you are the Chief Financial Officer for XYZ International Limited, involved with hardware products. During the meeting with the Chief Executive Officer, he elaborated some concerns on the...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

1. If you were in Haywards position, how would you have handled the aftermath of the oil spill?

10. Does your organization maintain a committee charged with improving the working climate for all employees?

5. Do you receive a relatively equal number of opinions, feelings, and suggestions from all employees?