Microsoft Exam 77-427 Topic 9 Question 33 Discussion

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.