Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 77-427 Topic 9 Question 33 Discussion

Actual exam question for Microsoft's exam
Question #: 33
Topic #: 9
[All Questions]

Which of the following formulas will provide the required result?

Show Suggested Answer Hide Answer
Suggested Answer: D

In order to get the required result, you will have to insert the following formula in the B7 cell: COUNTIFS(B2:B5,'=Yes',C2:C5,'=Yes') Only Sarah and David have exceeded their January and February quotas, therefore the formula will provide 2 as the result. Answer option C is incorrect. The COUNTIF function of Excel does not support multiple criteria. Answer options A and B are incorrect. This formula will count all the cells that have the value 'Yes' in the range B2:C5. As multiple criteria are not applied in the formula, it will provide 6 as the result.


Comments

Currently there are no comments in this discussion, be the first to comment!


Save Cancel