What is Cell Address or Cell Reference
The address or name of a cell or a range of cells is known as Cell reference. It helps the software to identify the cell from where the data/value is to be used in the formula. We can reference the cell of other worksheets and also of other programs.
- Referencing the cell of other worksheets is known as External referencing.
- Referencing the cell of other programs is known as Remote referencing.
There are three types of cell references in Excel:
- Relative reference.
- Absolute reference.
- Mixed reference.
Introduction to MS Excel
MS-EXCEL is a part of Microsoft Office suite software. It is an electronic spreadsheet with numerous rows and columns, used for organizing data, graphically representing data(s), and performing different calculations. It consists of 1048576 rows and 16384 columns, a row and column together make a cell. Each cell has an address defined by column name and row number example A1, D2, etc. This is also known as a cell reference.