1. Import: csv (comma separated value file) (known as standardised format for all computers, can be read by all computers) (when opening in an exam, save as excel workbook)
2. Absolute and relative references (Absolute means it will absolutely always refer to that cell) (relative means it change if a formula is copied and pasted dependant on where it has been pasted) (use '$' sign to make a reference absolute)
3. Named cells, named ranges (A named cell is an automatic absolute reference) (Named ranges is naming a cell) (This makes reading formulae easier)
4. Sum, average, maximum, minimum, integer, rounding, counting, if, lookup
5. Perform searches using AND, OR, NOT, LIKE (cuts down searches like search engine "Google")
6. Perform search using wildcard (wildcard is a *) (It broadens searches)