Exit 77-888 Excel 2010 Expert
Question 5 of 5
0% complete
Q5 Single choice

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")