Cell reference is used to prevent writing the data several times for calculation purposes. When you build a formula for a specific function, you must tell Excel where the data is stored. Cell reference is the name given to this site. As a result, whenever a new value is entered into the cell, the cell calculates using the reference cell formula.