USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUMIF
|
|
|
AVERAGEIF
|
|
|
COUNTIF
|
|
|
TOTALSUM
|
Detailed explanation-1: -You could also use the COUNTIFS function. Counts the number of cells with a value greater than 55 in cells B2 through B5. The result is 2. Counts the number of cells with a value not equal to 75 in cells B2 through B5.
Detailed explanation-2: -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-3: -=COUNTIF(Range, criteria) The COUNTIF function uses the following arguments: Range (required argument) – This defines one or several cells that we wish to count. The range of cells are those cells that will be tested against the given criteria and counted if the criteria are satisfied.
Detailed explanation-4: -The COUNTIF function counts the number of cells within a range that meet the criteria entered. A filter in Excel displays only a portion of the table data based on matching criteria. A large + sign icon displays next to column headings when a filter is invoked in a table.