USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, “John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal “John."
Detailed explanation-2: -Sum range (optional argument) – This is an array of numeric values (or cells containing numeric values) that are to be added together if the corresponding range entry satisfies the supplied criteria. If the [sum range] argument is omitted, the values from the range argument are summed instead.
Detailed explanation-3: -The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria.
Detailed explanation-4: -=SUMIF(range, “<>criteria”, [sum range]) Where comparison operator “not equal to” needs to enclose in double quotation marks (“ “). The SUMIF function sums the value if the value in the corresponding range is not equal to criteria value.