How does the average function works
CBSE, JEE, NEET, CUET
Question Bank, Mock Tests, Exam Papers
NCERT Solutions, Sample Papers, Notes, Videos
Posted by Mandeep Kaur 4 years, 8 months ago
- 2 answers
Yogita Ingle 4 years, 8 months ago
The AVERAGE function will average cells that contain numbers. Its syntax is:
=AVERAGE(value1, value2,...value30).
The arguments (e.g. value1) can be cell references, or values typed into the AVERAGE formula.
The following AVERAGE function example uses one argument -- a reference to cells A1:A5.
- Enter the sample data on your worksheet
- In cell A7, enter an AVERAGE formula, to average the numbers in column A: =AVERAGE(A1:A5)
- Press the Enter key, to complete the formula.
- The result will be 21.83, the average of the cells that contain numbers.
Cell A1 isn't included in the average, because it contains text, and the empty cell C3, is ignored.
Related Questions
Posted by Ansh Gautam 1 year, 3 months ago
- 0 answers
Posted by Moksh Sahu 1 year, 6 months ago
- 1 answers
Posted by Saumya Singh 1 year, 4 months ago
- 0 answers
Posted by Ketan Thakur 1 year, 2 months ago
- 3 answers
Posted by Suman Devi 1 year, 3 months ago
- 1 answers
Posted by Rakesh Sarkar 1 year, 4 months ago
- 0 answers
Posted by Hamza Ansari 1 year, 1 month ago
- 0 answers
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
Naveen Chaudhary 4 years, 8 months ago
0Thank You