Popular Posts

Sunday, February 20, 2011

1.CSV file= Comma Seperated Values(Standardized Format)
2.Absolute and relative references(relative cell references means formula changes to where you copy and paste it)Changes the numbers relative from where you moved from eg.A1+B1|B1+C1.
Absolute means it will always refer to that cell even if you copy and paste the formula from somewhere else.
$=Absolute Cell References, /=Divide, *=Times
3.-Named Cells means to change names to make cells easier, is an automatic absolute reference.
   -Named Range is an automatic relative reference, all class marks named ''marks''
  -It makes reading formulas easier, if you are naming the information rather saying B1,D1 etc
4.Sun,Average,Maximum,Minimum,Integer,Rounding,Counting,IF,Lookup
5.(Filtering)Perfrom searches using AND,OR,NOT,LIKE,>,<,=,>=,<=
6.Perform searches using wildcards(broaden searches)
7.Sort data
8.Adjust row height,column width,cell sizes
9.Colour/shading Cells
10.Set titles,use headers and footers
11.Format numeric data

No comments:

Post a Comment