FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

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.

There is 1 question to complete.
Previous
Next