USING MICROSOFT EXCEL
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: -COUNT function counts cells that contain only numbers, but COUNTA function counts cells that are not blank, including numbers. As Date and Time values are stored as serial numbers in Excel so these values are counted in both of these functions.