Average Calculation Functions Overview
Which of the following functions is used to calculate the average of a range of cells in Excel?
درج ذیل میں سے کون سا فنکشن ایکسل میں سیلز کی رینج کی اوسط کا حساب لگانے کے لیے استعمال ہوتا ہے؟
Answer: AVERAGE
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
This question appeared in
Past Papers (2 times)
IB GD 7, GD 11, OM 7, OM 11 Past Papers PDF (1 times)
Pakistan IB Past Papers (1 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- which function returns the average of all the cells in a range that meet given criteria in MS Excel 2016
- Which formula is used to find the number of numerical cells in a range of cells in Excel?
- In Excel, if you want to calculate the sum of cells ranging from C1 to C12, then which of the following formula you will use?
- Which short cut key is used to calculate the range of cell in MS excel
- How can you sum up a range of cells in Excel?
- Where can you set the shading color of a range of cells in excel ?
- In MS excel, a _____________ identifies a range by the cells located at diagonally opposed corners.
- We calculate average marks of a student in the way as we calculate ____?
- Calculate the average of the following numbers: 12, 15, 20, 25, 30.
- Which of the following formulas MS-Excel 2016 will not be able to calculate? =SUM (AI: A5)*.5, =SUM (Sales)-A3, =SUM( AI: A5)/(10-10), =SUM(AI:A5)-10
