Ms Excel Tutorials #1

Ms Excel

I Am going to start a set of tutorials in Excel 2010

Excel is a spreadsheet program it is a electronic grid with rows and columns

There are cells in excel

Every cell has a unique cell address made up of colum letters and row numbers

Example

{A1}

Today we will learn about statistical funtions

There are five statistical funtions

"=Average( )","=Sum( )","=Max( ),"=Min ( )","=Count( )"

I will cover 3 statistical funtions in today's tutorial



1) "=Sum( )" it is used to add numbers in a range of cells




Example


     student marks

{A1} 54

{A2} 87

{A3} 90

{A4} 56


{A5} =Sum(A1:A4)      

// This will add all the numbers inside cells from {A1} to {A4} and give you the total    
                                     // 54+87+90+56 =287



You can type the cell addresses manually or you can click the cell {A1} and drag to {A5} 0r
you can click on the "fx" icon and search for "Sum" then type the cell addresses.


Let us move onto "=Average( )"


2) "=Average( )" It is used to find the average of cells



Example


      Student marks                        

{A1}  37
{A2}  80
{A3}  79
{A4}  90

{A5}  =Average(A1:A4) 

    //This will add all the numbers in side cells from {A1} to {A4}      and divide the number by the number of cells which are filled with a number

                          //37+80+79+90/4 =71.5




You can type the cell addresses manually or you can click the cell {A1} and drag to {A5} 0r
you can click on the "fx" icon and search for "Average" then type the cell addresses.


Let us move to "=Max()"

3) "=Max()" It is used to find the highest number in a range


Example



      Student marks                        

{A1}  75
{A2}  61
{A3}  87
{A4}  56

{A5}  =Max(A1:A4)   //This will find the highest number in the  

                                        range.

                                    //The highest number = 87



Video  tutorial