FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB 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]

Which of these formulas will find the correct average of the cells?

A	=AVERAGE(A1:A10)
B	=MEAN(A1:A10)
C	AVERAGE(A1:A10)
D	=(A1+A2+A3+A4+A5+A6+A7+A8+A9+A10)/10

Explanation:

Detailed explanation-1: -=AVERAGE(number1, [number2], …) The function uses the following arguments: Number1 (required argument) – This is the first number of a cell reference or a range for which we want the average. Number2 (optional argument) – They are the additional numbers, cell references or a range for which we want the average.

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

Detailed explanation-3: -Calculate the average for nonadjacent cells Click the cell that contains the average that you just created, cell A8 in this example. The formula is displayed in the formula bar, =AVERAGE(A2:A7) if you’re using the sample data.

Detailed explanation-4: -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.