FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To calculate the average in a range we use the formula ____
A
=sum()
B
=max()
C
=average()
D
=round()
Explanation: 

Detailed explanation-1: -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-2: -Average This is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5. Median The middle number of a group of numbers.

Detailed explanation-3: -key and click the cells that you want to average, and then press RETURN. For example, select A2, A4, and A7, and then press RETURN. Excel replaces the selected range reference in the AVERAGE function with cell references for the cells that you selected. In this example, the result is 8.

Detailed explanation-4: -The AVERAGE Function[1] is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. The function is used to calculate the arithmetic mean of a given set of arguments in Excel.

Detailed explanation-5: -Explanation: The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants. The AVERAGE function calculates the average of numbers provided as arguments.

There is 1 question to complete.