Microsoft Excel Tutorial part 2

Microsoft Excel Tutorial

                                 (Complete Video Lecture)

In this lecture, we will learn how to sum different values by just adding values in columns and then we will use the formula of sum ().

Now we will find the Total numbers of each student. There are two ways to sum the numbers one is simply adding and the other is with the help of a formula.

First, we will add the respective cell values the first cell is  C4 second is D4 up to G4. As below

         =C4+D4+E4+F4+G4  

we will write this in the formula bar as shown below

Then press enter and drag below to copy the formula to the remaining cells.

Now suppose we have hundreds of cells to add, this method will not appropriate. Then we will use Sum() functions (Formula).that is very simple just write the function and give the range of cells to add

As given below

The formula is  

                  =Sum (first cell: last cell)

That is

                    =Sum (C4: G4)

Now just drag it to apply to other cells. It will add values from column C4 to G4.