Cell address refers to the unique identifier of a specific cell within a spreadsheet. In spreadsheet applications like Microsoft Excel or Google Sheets, cells are organized in a grid-like structure formed by intersecting rows and columns. Each cell is identified by a combination of a column letter and a row number.
Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
A cell reference, also known as a cell address, is a scalar value that is used to identify a specific cell in a worksheet. Each cell reference begins with a letter and ends with a number.