DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Bold
|
|
|
Numbers
|
|
|
Formats
|
|
|
Blanks
|
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.