FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

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.