Give the meaning of 'Cell reference'. Differentiate between 'Relative Cell reference' and 'Absolute cell reference.'

Cell reference • A cell reference identifies the location of a cell or group of cells in the spread sheet and is also referred as a cell address. Cell references are used in formulas, functions, charts, other Excel Commands and also refer to a group or range of cells. Relative cell Reference Absolute cell Reference By default cell reference is relative which Absolute cell reference consists of the means that as a formula or function is column letter and row number copied and pasted to other cells the cell surrounding by dollar ($) signs. It is references in the formula or function used when we want a cell reference to change to reflect the new location. stay fixed on specific cell, which means that when a formula or function do not change.