If the formula contains one or more dollar signs ($), it is an absolute cell reference or a partial absolute cell reference. One can identify an absolute cell reference by looking at the formula of the cell. Why would anyone need to use an absolute cell reference?.Examples of an absolute cell reference.