Jump to content

Tutorial 3 - Entering Formula & introduction to cell referencing

Sign in to follow this  
Saurabh Jain

726 views

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

 

 

 

 

Sign in to follow this  


0 Comments


Recommended Comments

There are no comments to display.

Guest
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...