USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
sumif
|
|
|
countif
|
|
|
if
|
|
|
average
|
Detailed explanation-1: -Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
Detailed explanation-2: -COUNTIFS(criteria range1, criteria1, [criteria range2, criteria2]…) criteria range1 (required)-defines the first range to which the first condition (criteria1) shall be applied. criteria1 (required)-sets the condition in the form of a number, cell reference, text string, expression or another Excel function.
Detailed explanation-3: -The difference between COUNTIF and COUNTIFS is that COUNTIF is designed for counting cells with a single condition in one range, whereas COUNTIFS can evaluate different criteria in the same or different ranges. When doing financial analysis, COUNTIF helps in doing a quick analysis.
Detailed explanation-4: -The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.
Detailed explanation-5: -=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.