Question

Indicate the importance of cell reference

Answer 1

Absolute cell reference can be used when a particular cell reference needs to be constant. Cell references are often used in formulas, charts, functions and other commands. In some scenarios, it becomes important to keep a cell reference constant when it is copied to a different cell.

Answer 2

☛ 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.