The function in Excel that is used to calculate the average of a group of values or data is.....

USING THE RIGHT LEFT AND MID FUNCTIONS 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]

The function in Excel that is used to calculate the average of a group of values or data is____

A	SUM
B	AVERAGE
C	MAX
D	IF

Explanation:

Detailed explanation-1: -AutoSum lets you find the average in a column or row of numbers where there are no blank cells. Click a cell below the column or to the right of the row of the numbers for which you want to find the average. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.

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: -Enter the following formula, without quotes, to find the arithmetic mean of your set of numbers: “=AVERAGE(A:A)". Press “Enter” to complete the formula and the mean of your numbers will appear in the cell.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL