DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You can use the SUMIFS, COUNTIFS, and AVERAGEIFS functions to perform ____ operations on a range of data.
|
|
STATISTICAL
|
|
|
COUNTING
|
|
|
MATH
|
|
|
None of the above
|
Explanation:
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: -Additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs.
There is 1 question to complete.