USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The function used to find the average value is ____
|
|
SUM
|
|
|
MAX
|
|
|
AVERAGE
|
|
|
COUNT
|
Explanation:
Detailed explanation-1: -If you want to calculate the average of only the values that meet certain criteria, use the AVERAGEIF function or the AVERAGEIFS function.
Detailed explanation-2: -How to Calculate Average. The average of a set of numbers is simply the sum of the numbers divided by the total number of values in the set. For example, suppose we want an average of 24, 55, 17, 87 and 100 . Simply find the sum of the numbers: 24 + 55 + 17 + 87 + 100 = 283 and divide by 5 to get 56.6 .
There is 1 question to complete.