USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
ROUND function
|
|
|
COUNTA function
|
|
|
SUM function
|
|
|
INT function
|
Detailed explanation-1: -The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
Detailed explanation-2: -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-3: -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-4: -=COUNTA(value1, [value2], …) The Excel countif not blank formula uses the following arguments: Value1 (required argument) – This is the value at which we evaluate the function. Value2 (optional argument) – Additional arguments that represent the values that we wish to count.
Detailed explanation-5: -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.