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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started