How to Draw the graph in Ms Excel

First we enter the data now draw graph on the Percentage values

Click on the insert tab as picture show

select percentage column as below picture shown

Click on the column graph 

Click on the 2-D column first graph

Graph will as shown Picture 

Click on the X axis  where 1   2    3     4   5 as figure shown

           Right click on the select area and click on select option as figure shown

                                         Click on the edit button which is point by aero 

            Select English Chemistry Physics Biology Mathes by mouse and click Ok button as below Picture Shown

         Click OK button as shown in the figure below 

Now graph will show with subject name as Picture shown below

           In this Post we learnt about how graph draw on the excel sheet 

How to set If condition in the Ms excel

MS excel provide us different defined functions like Sum If average etc under formula tab in function button

first we fill the up data as we required now here I am using student subject result and calculate different subjects result percentage and after calculating the percentage value apply the If condition on it to decide the result (Pass Or Fail)

1. Click on formula Tab
2. Click on insert function

after clicking on the insert function new window show

click on the IF as picture shown and click on Ok button new window will appears like below window shown

Here is the Logical_test we put value D2>=45 means that percentage value of English subject is greater or equal to 45 it place E2 Pass else Fail. 45 is our defined range which decide the Fail or Pass.

Next field is value if true we put Pass and next field value if false we put Fail 

if logical test goes to true then the value if true place on E2 else value if false on E2 

using the auto fill data click on spot and drag down to 6 row

In this Post we learnt about IF function and how apply on the data 

how to use formula inthe MS excel 2

Now in this post we learnt about how to add cells and subtract cells. lets move on the excel sheet and fill the meaning full data to understand the usage of the addition and subtraction

B2 is the monthly salary and C2 is the tax which is deductive from salary So we put the formula in the cell D2 =B2-C2. After press the Enter button D2 shows the value which is calculated by subtract formula as next picture shown

   click on sopt and drag down as per requirement to calculate total salery.

now we are going to calculate the total monthly salery by sum formula is located cell B13 =sum(B2:B12)

after calculating the total of monthly salery we click on the sopt and drag right two cells

now we have calculate total TAX and Total of total salery by sum formula

In this Post we learnt about sum and subtraction in the MS excel

how to use formula in the Ms excel

Excel provides us to calculate the different functions by use operator we can add cells subtract cells multiply cells and divide cells values. In this post we  divide and multiply cells   

In the figure below shows the annual report of the student 

In the D2 cell we calculate the percentage of the students by putting the formula B2 is the obtain marks and C2 is the Total marks so we use cell reference to calculate the percentage. Excel compiler detect the equal (=) sign to perform the calculation. And multiply by constant 100 value to calculate the percentage. After putting the formula in the cell D2 and then press enter button to get persentage in the D2 cell as next figure below

Click on the spot which is shows by aero and drag down to the last entry all selected cell filled by correspondally percentages

after drag

In this post we learnt about how to multiply and divide the cells to calculate the percentage 

how to fill cell by auto increment

In the excel sheet another function is that auto fill by increment. This function automatically increment in sequence. Select first two or three cell as picture shows. Click on the spot which shown by aero

And drag down side as you required as picture shown

 After release the mouse button cells will auto fill by increment value in sequence

In this post we learnt about how to fill data by increment

How to Auto fill the data in the MS Excel

Ms excel provide the functionality of the auto fill cells. This is quit easy way to fill the different cells in the column as picture shows

Click on the right side down spot and drag to down word as picture shows

Until last Entry as picture shows 

In this Post we learnt about auto fill data in the cell with the help of mouse 

Data entering and cell references and its use the MS EXCEL

Excel book contain on the sheets by default sheet name are Sheet 1, sheet 2 and so on sheets divided in rows and columns. Columns specify by alphabetic (A,B,C,D……) and Rows specify by number (1,2,3,4,5,6,7…...). When we write the data in the excel sheet first we click on the cell or active the cell and then write on it. Column name and row number specify the cell reference.

So every cell on the excel sheet have references like below picture shows  

Bold border cell reference is B2. B specifies the column name and 2 specify Row. References helps us in the mathematically calculation by defined function e.g. if we want to add two cells A1 and B1 put result in the C1 cell and second requirement is when we change the value of A1 or B1 result 

produce correspondally change. Like picture shows

 In this picture we add two cells value with help of cells references or we call the cells by reference in the formula =SUM(A1:B1) cell A1 contain the value 45 and cell B1 contain value 65 cell C1 produce the result after calculation the sum of the cells A1 and B1.

If we change the value of A1 orB1 or both cell C1 cell changes its value correspondally. We don’t need to change in the formula to produce correct or updated result. This feature of reference helps us to write once formula and doesn’t need to change again to produce result. If we use formula without references or call by value =SUM(45+65) then result produce correctly but when we change the value of A1 or B1 or Both then C1 is not calculate the updated result C1 contain the old value so  we should change in the formula value to produce correct result. This is time consumption process and error chances are high when we deals with large data amount so that’s why cell references used for calculation make changing easily to produce correct result.  

In today’s topic we learnt about the cell references and how to use references in the formula and how reference is make easy way for us in excel calculation