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

Introduction to Algorithms and Algorithmic Notation With Examples

Topic: Introduction to Algorithm and Algorithmic Notation With Examples What is an Algorithm? The step by step procedure to solve a particular problem is called an Algorithm .  A Good Programmer always writes algorithms before developing programs. Algorithmic Notation with example algorithms  Advantages of  writing an Algorithm The process of solving a problem becomes simpler and easier with the help of  algorithm. There are less chance of errors in the program, if we design algorithms before writing our programs in any programming language. We can convert an algorithm into a program of any programming language. It is not dependent on any programming language. Therefore it is easy to understand for anyone even without programming knowledge. What is the Relationship between an Algorithm and a Program Sponsored Links An algorithm is the sequenc of steps to perform a task, whereas a program is the set of statements to perfor...
Post a Comment
Read more

Define Data and Information With Examples

DATA Data is the collection of raw facts and figures. Actually data is unprocessed, that is why data is called collection of raw facts and figures. Define Data and Information with Examples We collect data from different resources. After collection, data is entered into computer for processing. Data may be collection of words, numbers, pictures,  or sounds etc. Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form  contains raw facts (data of student) like name, father’s name, address of student, obtained marks, photo graph etc. 2)    Data of Citizens During census, data of all citizens is collected. The staff will go house to house and collect data about citizens like number of persons living in a home, either they are literate or illiterate, number of children, data of each child, cast, religion, Computerized national Identity Card number, address, how many rooms and...
4 comments
Read more

Explain Main Difference Between System Software and Application Software

Topic: Explain Main Difference Between System Software and Application Software            Differentiate between system software and application software Before , explaining the main differences between application software and system software, let us know the definitions of Application software and System software with examples. What is System Software: System software is a set of programs to control all components of computer and to manage overall operations of computer system. Differences between System software and application software System software is used as a base to install and run all application software. Examples of system software include: Operating Systems, like Microsoft Windows, DOS, Unix and Linux Device Drivers like Device driver software of a Printer (found on CD normally provided with the printer) Utility Programs like AVAST anti virus, Disk Scanners and File Viewers etc. What is Applicat...
10 comments
Read more