If A1:A5 contains 3, "Ali", 7, blank, 10 then =COUNT(A1:A5) returns:

  1. 20
  2. 3
  3. 5
  4. 4
Answer

B) 3

Only 3, 7 and 10 are numbers.

Computer Science MCQ · More Lab: MS Excel MCQs · Practise