DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which function is used to calculate the average of more than one criterion?
|
|
SUM IF
|
|
|
AVERAGE IF
|
|
|
IF ERROR
|
|
|
AVERAGE IFS
|
Explanation:
Detailed explanation-1: -The AVERAGEIFS Function[1] is an Excel Statistical function that calculates the average of all numbers in a given range of cells, based on multiple criteria.
Detailed explanation-2: -The AVERAGEIFS function syntax has the following arguments: Average range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers.
Detailed explanation-3: -=AVERAGEIF(range, criteria, [average range]) The AVERAGEIF function uses the following arguments: Range (required argument) – This is the range of one or more cells that we want to average. The argument may include numbers or names, arrays, or references that contain numbers.
There is 1 question to complete.