Ms. Office Excel 2013 - About Cell and Range

Microsoft Office Excel 2013 - About Cell and Range

Understanding to know about cell and range on Microsoft Office Excel 2013 is most important. Need not bid to do when We want to work with Excel. You do not understand about what is Cell and Range when working with Microsoft Office Excel these is impossible to more work with Excel. and we have know about work with excel, everyone work with more cell, range,VBA and more function. One more time I remember you are, "take a look your time to understanding what is cell and range on Excel".

Cell in a spreadsheet is meaning intersection of row and column. example A12, it meant intersection of column "A" and row "12". Range  in a spreadsheet is meaning grouping of cell. example range of "A1:B3", it meant group of A1,A2,A3,B1,B2,B3.

1. Relative cell is meaning when you copy formula from C1 =A1+B1  to C2,that is adjust downward one by row and becomes C2=A2+B2.

2. Semi absolute cell is meaning one mark "$" both of row or colums. example

• Absolute of column : $A12
• Absolute of row : A$12

3. Absolute cell is meaning the row and column is locked and when you copy the formula it still same with source formula early. example of absolute cell is $A$12.
4. A cell reference is meaning the identifies the location a cell or group of cells in the worksheet.

Conclusion: cell and range as defenition to begin spreadsheet that most important to understanding spreadsheet work. Without that, working in spreadsheet is blind when create one formula in the worksheet.

AHS