Microsoft Excel | Cell Reference & its Types
Cell reference is mainly the address of a cell. But, cell reference types are of three different categories.
Relative, absolute and mixed.
Every type has different objective and different ways to use.
Relative reference don't require dollar($) symbol, but absolute and mixed references use this sign.