Function Wizard & Cell Reference

THE FUNCTION WIZARD
There are two ways to insert a function in excel spreadsheet:
1-By typing directly into the cell or in fourmula bar.
2-By using the INSERT FUNCTION option.
There are many ways to accessing the INSERT FUNCTION dialog box: 1-Go to formulas menu and click on INSERT FUNCTION option. 2-Just click on INSERT FUNCTION(fx) icon on formula bar. 3-Press SHIFT+F3
CELL REFERENCES
This is one of the most important thing everyone should know about this.  Three type of cell references are:
1-Relative
In relative reference, column and row numbers change as it copied to other cell respectively.
2-Absolute
In absolute reference, column and row numbers doesn't change wherever it copied in the spreadsheet.
3-Mixed
Mixed reference is the combination of Relative and Absolute
Reference	Cell		Range
Relative	A4		A4:B5
Absolute	$A$4		$A$4:$B$5
Mixed	$A4 or A$4		$A4:B$5
$(Dollar) symbol denotes that the particular cell or range is freezed so no matter where it is copied the values will remain same.
Two ways to freeze cell or range:
1-By directly typing the $ (Dollar) symbol.
2-By press F4
First time when anyone press F4 it freeze both the column and row, second time only row and third time only column. Please leave you comments and suggestion in comment box.