FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

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____
A
SUM
B
AVERAGE
C
MAX
D
MIN
E
IF
Explanation: 

Detailed explanation-1: -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: -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-3: -The Excel AVERAGE function is used to generate a number that represents a typical value from a range, distribution, or list of numbers. It is calculated by adding all the numbers in the list, then dividing the total by the number of values within the list.

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