DATABASE FUNDAMENTALS
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. The COUNTA function does not count empty cells.
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: -The CountA function counts the number of records that aren’t blank in a single-column table. This function includes empty text ("") in the count. The CountIf function counts the number of records in a table that are true for a logical formula.