Skip to main content

Use of Average Function in Excel Worksheet With Examples

What is the Use of Average Function in Excel? 

The Average Function of Excel is used to get the average of the numbers in Excel Worksheet.

Syntax of Average Function in Excel 

 Average(number1, number2, number3, ... number N)  

use-of-average-function-in-excel-worksheet
For Example Average(10,15,20) will return 15. Because, Average is calculated by adding all the numbers and then dividing the total by count of the numbers.
In above example: Average = (10+15+20) / 3 Which evaluates to 45 / 3 that is 15.

Syntax of Average Function in Excel Using Cell references 


Average(cellRef1:CellRef2) 
where cellRef1 is the cell reference of the first cell and cellRef2 is the cell reference of the last cell in Average function to calculate the required average, in Excel worksheet.


how-to-use-Average-worksheet-function-Excel
Consider the above figure for example: the cells A2, B2, C2, D2 and E2 contains the numbers 5, 15, 30, 40, 50 respectively.

How To Implement Average Function in Excel

 First of all place the cursor in an empty cell to enter the function.
  • Type =
  • Type the function name AVERAGE
  • Type the left parenthesis (
  • Select the cell range A2 to E2 with the help of mouse so that the arguments A2:E2 will be automatically entered in the AVERAGE function. 
  • Note: that you may type A2:E2 by keyboard also.
  • Press Enter key (You need not to enter right parenthesis, it will be automatically included)
  • The result 28 will be displayed in the cell.
Labels:

Comments

Post a Comment

Popular posts from this blog

Convert Centimeters to Inches Python Programming | Python Program Conver...

YouTube Video Tutorial How to write a Python program to convert centimetres to inches Formula to convert centimetres to inches   Explanation of this Python Program This Python program prompts the user to enter a height in inches, converts it to centimeters, and then prints the converted value. It uses the conversion factor of 2.54 to perform the conversion and rounds the result to two decimal places before displaying it to the user. Here's an explanation of the provided Python program line by line: python inches = float ( input ( 'Enter the Height in inches to convert into centimeters:' )) This line prompts the user to enter a height in inches and assigns the entered value to the variable inches . The input() function is used to receive input from the user, and float() is used to convert the input into a floating-point number. python centimeters = inches * 2.54 This line calculates the equivalent value in centimeters by multiplying the inches variable by the conver...
Post a Comment
Read more

Converting Decimal Number system to Binary, Octal and Hexa Decimal with Examples and Vice Versa

Topics covered with examples: Converting Decimal Number system to Binary, Octal and Hexa Decimal with Examples and Vice Versa Number Systems in Computer Science and Conversion Method Conversion of Decimal number system to other  number systems Conversion of Decimal number system to binary number systems Conversion of Decimal number system to octal number systems Conversion of Decimal number system to hexadecimal number systems Conversion of    non-decimal Number system to Other non-decimal number system Conversion of other number systems to Decimal number system Conversion of binary number systems to Decimal number system Conversion of octal number systems to Decimal number system Conversion of  hexadecimal number systems to Decimal number system Q1. What is a Number System? What are different types of number system? Number system A number system is a set of digits, symbols and rules to express quantities in counting and c...
Post a Comment
Read more

Find Your Correct Age From Date of Birth

First of all click on First two digits to type Month number from keyboard like any number from 1 to 12. . Now click on next two digits and type day number of month that is date from 1 to 31. In the last step type the year of your birth in four digits like 1995.  Now click on the blue button with text "Calculate Age". Your accurate age will be displayed below the button. For example. If today is 09-16-2023 that is September 16, 2023 and you type birth date as 11-01-2000 that is November 1, 2000, your accurate age will be displayed as:Your age is 22 years, 10 months, and 15 days. Age Calculator Age Calculator Calculate Your Age Now! Enter your date of birth: Calculate Age As shown in the image below:
Post a Comment
Read more