Referencing is linking to cells or ranges for further use in calculations. There are three types of references:
•Relative: This type of references changes when copying or auto-filling. By default, all references in the editor are relative.
•Absolute: This type of references does not change when copying or auto-filling. Therefore, they should be used for formulas that have constant values, such as interest rates.
•Mixed: This type of references allows you to combine both absolute and relative references. For example, in the В$5, D$12 reference the row number remains the same, but the column name may change.