You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team Using Microsoft Excel. You want the report to appear in the following format: You want the Remark…

Question

Exhibits

Options

• A=IF(E2>=1200,"Improve in Next Quarter","Well Done")
• B=IF(E2<=1200,"Well Done","Improve in Next Quarter")
• C=IF(E2>=1200,"Well Done","Improve in Next Quarter")
• D=IF(E2>1200,"Improve in Next Quarter","Well Done")

• A
  5% (3)
• B
  9% (6)
• C
  70% (45)
• D
  16% (10)

Explanation

In order to accomplish the task, you will have to insert the following formula in the F2 cell: =IF(E2>=1200,"Well Done","Improve in Next Quarter") Answer option A is incorrect. This will display the wrong messages for the given conditions. The first expression after the logical condition is returned by the IF function when the condition is Answer option B is incorrect. This formula will not accomplish the task as the logical condition is not correct. The specified condition in this formula is testing for values less than or equal to 1200. Whereas, the question's requirement is to evaluate values greater than or equal to 1200. Answer option D is incorrect. This formula will not accomplish the task because of the two First, the equal sign is missing in the condition. Second, the expressions are not in the correct

No community discussion yet for this question.