What would the result be of a formula added in B5 of =countif(A1:A3,A5)? You may assume that the data is good.

What would the result be of a formula added in B5 of =countif(A1:A3,A5)? You may assume that the data is good.

(A) 2

(B) 10

(C) 40

(D) 3

Explanation

The result be of a formula added in B5 of =countif(A1:A3,A5) is 2 because the formula wants to count how many times “Ben” occurs in the range A1-A3.

Conclusion

This question is from the Quiz section of the first lesson “Working with Data in Excel” from the HubSpot Excel for Marketers course. You can find answers to all the quiz questions asked in this course on our HubSpot Excel for Marketers Lesson Quiz Answers page.

Leave a Comment

Share via
Copy link
Powered by Social Snap