Learn More about Advance Excel: use Rand Between function and F4 function key to creating Absolute reference.br ......................................................br What is the reference?br Reference is address of cell. By which we can uniquely identify a cell. Actually address and reference two are same but difference is that during formula or function, when we use address then this address is called reference.br How many types of reference and name?br According to reference format: -br There are four (4) types of reference br 1. Relative reference like A1,B6,A9 etc. (Default reference).br 2. Absolute reference like $A$1, $B$6, $A$9 etc. (Fixed reference)br 3. Mixed reference like $A1, A$1 , $B6, B$6 etc. (Relative + Absolute)br 4. Circular Reference (iteration calculation loop) br According to reference style:-br 1. A1 (General By default)br 2. R1C1 (Active from option, R for Row and C for Column)br br What is Relative reference?br When we drag or paste a reference column-wise then the reference will be changed according to the column name and When we drag or paste a reference row-wise then the reference will be changed according to row no. This is the default reference.br What is Absolute reference?br Absolute reference means Fixed reference. When a reference never changes if we drag or paste column or row-wise. This reference is called Absolute reference. br We use the $ sign before row and column. Or we use the F4 function key to fixed an address.br What is a Mixed Address?br When we use both Relative and Absolute reference in a reference. This reference is called Mixed reference. In case of mixed reference we absolute either column or row.br br ....................................................................