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