USING MICROSOFT EXCEL
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: -The SUMIF function can be only used for adding a single continuous range based on a single specified range with a single criterion, whereas, SUMIFS can be applied over multiple continuous ranges.
Detailed explanation-2: -Additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs.
There is 1 question to complete.