In this tutorial we will learn to write basic formulas and introduction to cell referencing

• Relative referencing which is the default referencing
• Absolute referencing
• Mixed Referencing

Important points

4 type of referencing can be  cycle through f4 key -  when we are in edit mode of cell  - (use f2 to enter into edit mode) -    A1 , $a$1 , A$1, $A1 

Shortcut Ctrl + ~  (tilde which is just above 1 in windows)

pl download file