Excel(Spreadsheets)

1. import: .csv (comma separated value file) known as standardised format for all computers, can be read by all computers. save as excel workbook.
2. Absolute and relative references, Absolute cell references refer to a block in excel, eg. A1 is top left hand corner cell, absolutely always refers to that cell where ever you copy paste that formula. Relative references is when it changes if you copy and paste the formula. The formula changes to where you copy and paste it.
3. Named cells, named ranges, Named cell is another way of doing an absolute references, eg. B1 is renamed top marks. Named ranges is naming a range of cells, eg. the ranges of a classes marks is named marks. Named ranges are an automatic relative references. They make reading formulas easier to read.
4. sum, average, maximum, minimum, integer, rounding, counting,if, look up.
5. perform searches using AND, OR, NOT, LIKE, <, >, =,>=, <= (cuts down information like a google search)
6. Perform Searches using wildcards. A wildcard is a star(*). eg. *th comes up with any word that ends with th, eg smith. Broadens searches.