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 ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 20, 2024

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.