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

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

HTML Table Tag Basics

Tables Tables are very important to show data in the form of rows and columns. Tables make data more readable and easy to understand. A table consists of rows, columns and cells. HTML Tags To Make A Table As we know that there are basically three elements in a table, that is, rows, columns and cells. So, there are the following basic tags to create a table in an HTML web page: <TABLE> tag <TR> tag <TD> tag <TH> tag   <TABLE> Tag <Table> tag is used to specify the start of a table. It also specifies some attributes of the table like ALIGN and BORDER attributes etc. Example 1: <Table>                    => Table without a border. Example 2: <Table border="1">     => Table with a border of width 1. Example 3: <Table align="left" border="2">  => A left aligned Table with a border of width 2. ...
Post a Comment
Read more

Explain The Concept of A Computer System

A system is a set of inter related components that work together to fulfill a purpose. For example a Road Transportation System will consist of the parts - roads, vehicles- trucks, buses, vans, cars etc, passengers, the staff for ticketing and maintenance of vehicles and roads etc. And the transportation system will fulfill the purpose of carrying of passengers and luggage from place to place. Similarly, a computer system consists of many components that work together to fulfill the purpose of data processing. A Computer system consists of the following four parts: 1.    Hardware 2.    Software 3.    Data 4.    User 1.    Hardware The mechanical devices that makeup the computer are called HARDWARE , for example, Keyboard, hard disk, monitor, processor and mother board etc. Hardware are physical devices . They can be touched. Hardware device are interconnected and perform input, processing and output o...
Post a Comment
Read more