FUNDAMENTALS OF COMPUTER

Previous

DATABASE FUNDAMENTALS

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The COUNTA function ignores text.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -The COUNTA function counts cells containing any type of information, including error values and empty text ("").

Detailed explanation-2: -Empty cells, logical values, text, or error values in the array or reference are not counted. If you want to count logical values, text, or error values, use the COUNTA function.

Detailed explanation-3: -COUNTA counts all values in a dataset, including those which appear more than once and text values (including zero-length strings and whitespace).

There is 1 question to complete.
Previous