Which of the following functions is used to calculate the average of a range of cells in Excel?
Which of the following functions is used to calculate the average of a range of cells in Excel?
درج ذیل میں سے کون سا فنکشن ایکسل میں سیلز کی رینج کی اوسط کا حساب لگانے کے لیے استعمال ہوتا ہے؟
Explanation
To calculate the average in Excel, you can use the AVERAGE function:
- Formula =AVERAGE(number1, [number2], …)
- Arguments: Number1 is required, and Number2 is optional
- Example =AVERAGE(A1:A20) returns the average of the numbers in the range A1:A20