DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
counts cells having alphabets
|
|
|
counts empty cells
|
|
|
counts cells having number
|
|
|
counts non-empty cells
|
Detailed explanation-1: -The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells.
Detailed explanation-2: -Use the COUNTA function to count only cells in a range that contain values. When you count cells, sometimes you want to ignore any blank cells because only cells with values are meaningful to you.
Detailed explanation-3: -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-4: -Solution: COUNTA function counts cells containing any type of information, including error values.