FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

What Excel function is used to calculate the average of a range of cells?

A	IF
B	AVERAGE
C	SUM
D	AVERAGEIF

Explanation:

Detailed explanation-1: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.

Detailed explanation-2: -Description. Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

Detailed explanation-3: -The formula to calculate the average of given numbers is equal to the sum of all the values divided by the total number of values.

There is 1 question to complete.