14 September 2013
Cell referencing by name means that you use meaningful names to reference cells in formulas. The resulting formulas are easier to understand and names provide an immediate meaning to the calculation being performed by the formula.
By default, names use absolute referencing. In some usages, absolute referencing may produce unexpected results; however, you can correct such results by using Name Manager to modify the referencing mode.
Full article: Cell referencing by name