Discuss Forum

1.  In Excel, the COUNTA() function

  • A. counts cells having alphabets
  • B. counts cells having alphabets
  • C. counts cells having alphabets
  • D. counts cells having alphabets

Answer: Option D

Explanation:

The correct answer is 4. counts non-empty cells. The COUNTA() function counts cells that contain any type of information, including numbers, text, logical values, and error values, but it does not count cells that are completely empty.  
  • It does not count empty cells, but it counts cells with an empty string (""). 
  • It counts cells with alphabets and cells with numbers. 
  • It counts cells with formulas that return a value, even if that value is an empty string. 

Post your comments here:

Name:
Mobile:
Email:(Optional)

» Your comments will be displayed only after manual approval.