USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
COUNT
|
|
|
COUNTIF
|
|
|
COUNTA
|
|
|
SUMIF
|
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.
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. If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS function.
Detailed explanation-3: -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.