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

CRT Monitors and Flat-panel LCD Monitors Differences

Difference between CRT monitors and Flat Panel (LCD) Monitors Differences between CRT Monitors and Flat-panel (LCD) Monitors CRT Monitors Flat-panel (LCD)Monitors 1 CRT monitors are low-priced and more economical than flat-panel (LCD) monitors. Flat-panel monitors are more costly than CRT monitors. 2 Commonly, CRT monitors are used with personal computers. In the beginning LCD monitors were used in lap top or note book computers, PDAs and smart phones. But now they available for PCs, too.  3 CRT monitors use Cathode Ray Tube (picture tube) Technology to show text and graphics on screen. Flat-panel monitors use LCD - Liquid Crystal Display technology or Gas Plasma technology. 4 CRT monitors need more power. LCD monitors uses less energy than CRT monitors. 5 CRT monitors take more space on desk. LCD monitors take less space on desk top. 6 ...
Post a Comment
Read more

Discuss Differences Between RAM and ROM

We have already discussed the topics: 1. What is RAM, Explain Different Types of RAM 2. What is ROM Explain Different Types of ROM Here we discuss differences between RAM and ROM 13 Differences Between RAM and ROM Thirteen Differences Between RAM and ROM Sr # RAM ROM 1 RAM stands for Random Access Memory ROM stands for Read Only Memory. 2 RAM is a temporary memory. ROM is a permanent memory. 3 RAM is a volatile memory. ROM is a non volatile memory. 4 When computer is turned off, all data and programs are erased from RAM.  When computer is turned off, all data and programs are retained in ROM. 5 RAM is a Read / Write memory. Data can be read and written to RAM. ROM is a read only memory. Data from ROM only can be read and not written. 6 Data and programs in RAM can be changed. The contents of ROM cannot be changed. 7 Dat...
Post a Comment
Read more