DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUM
|
|
|
COUNT
|
|
|
COUNTA
|
|
|
MAX
|
Detailed explanation-1: -The COUNTA function does not count empty cells. If you do not need to count logical values, text, or error values (in other words, if you want to count only cells that contain numbers), use the COUNT function. If you want to count only cells that meet certain criteria, use the COUNTIF function or the COUNTIFS function.
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(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-4: -The COUNTA function is used to count the number of cells that are not empty in a range. To count the number of non-empty cells within a range or range name the function COUNTA can be used.