FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Both the COUNT and COUNTA functions ignore which of the following?
A
Bold
B
Numbers
C
Formats
D
Blanks
Explanation: 

Detailed explanation-1: -The COUNTA function does not count empty cells. If you do not need to count logical values, text, or error values (in other words, if you want to count only cells that contain numbers), use the COUNT function.

Detailed explanation-2: -COUNTA counts cells that contain ‘something’. Each of those ‘blank’ cells contains a formula. Each formula returns a result. The result in those blank cells is most likely a null string ( “” ), which has an appearance similar to that of an empty cell.

Detailed explanation-3: -COUNT counts how many cells in a range contain numeric data (numbers). COUNTA counts how many populated cells in a range (i.e. not blank). COUNTBLANK counts how many blank cells in a range. COUNTIF counts how many cells in a range meet a certain condition.

There is 1 question to complete.