# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### 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?
 A SUM IF B AVERAGE IF C IF ERROR D 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.