Question

Write short note on cell address​

Answer 1

Answer:

A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents the row.

Answer 2

Short note on cell address​:

• In Excel, the cell ADDRESS function is categorised as a Lookup and Reference function.
• It will provide a cell reference by taking the row number and column letter (its "address").
• As a text string, the cell reference will be supplied.
• The function can construct a cell reference within a formula and can return a relative or absolute location.