Exam 77-888 topic 1 question 26 discussion

Actual exam question from Microsoft's 77-888

Question #: 26
Topic #: 1

You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2010 for creating various types of reports. You have created a report in the format given below:

In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the B7 cell.
Which of the following formulas will provide the required result?

A. COUNTIF(B2:C5,"=Yes")
B. COUNTIFS(B2:C5,"=Yes")
C. COUNTIF(B2:B5,"=Yes",C2:C5,"=Yes")
D. COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")

Show Suggested 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.

by Shahid_416 at Nov. 22, 2023, 11:49 a.m.

Comments

Submit Cancel

Shahid_416

1 year, 7 months ago

Correct Answer: D

upvoted 1 times

...