ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 77-888 All Questions

View all questions & answers for the 77-888 exam
Go to Exam

Exam 77-888 topic 1 question 24 discussion

Actual exam question from Microsoft's 77-888
Question #: 24
Topic #: 1
[All 77-888 Questions]

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 column to be filled through a conditional formula. The criteria to give the remark is as follows:
✑ If the sales of the First Quarter are greater than or equal to 1200, display "Well Done"
✑ If the sales of the First Quarter is less than 1200, display "Improve in Next Quarter"
You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:

Which of the following conditional formulas will you insert to accomplish the task?

  • 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")
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
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 TRUE.
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 reasons.
First, the equal sign is missing in the condition. Second, the expressions are not in the correct order.
by Shahid_416 at Nov. 22, 2023, 11:47 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Shahid_416
1 year, 7 months ago
C. =IF(E2>=1200,"Well Done","Improve in Next Quarter")
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel