DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
COUNTIF
|
|
|
SUM
|
|
|
AVERAGE
|
|
|
COUNT
|
|
|
COUNTA
|
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: -The COUNTA function counts the number of grades in Maths from B2 to B6, in English from C2 to C6, and in Computer from D2 to D6. It returns the values 3, 2, and 3 respectively.
Detailed explanation-3: -So, the difference between COUNT and COUNTA is the type of values that cells contain. Here are some points that differentiate both of these functions. COUNT function counts cells that contain only numbers, but COUNTA function counts cells that are not blank, including numbers.