USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
COUNT
|
|
|
SUM
|
|
|
AVERAGE
|
|
|
MIN
|
Detailed explanation-1: -Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.
Detailed explanation-2: -The COUNT Function[1] is an Excel Statistical function. This function helps count the number of cells that contain a number, as well as the number of arguments that contain numbers.
Detailed explanation-3: -COUNT()-Returns the number of rows.
Detailed explanation-4: -To count numbers only, use the COUNT function. To count numbers and text, use the COUNTA function. To count with multiple conditions, use the COUNTIFS function. To count empty cells, use the COUNTBLANK function.