Excel

When opening a .csv in an exam, save it as a non-.csv file as soon as possible. Save it as a Excel Workbook. SAVE AS EXCEL
SAVE AS EXCEL

1. Import .csv (comma separating value) standardized format for all computers
2. Absolute and relative cell references (A1 refers to that cell) formula changes to where you've copied from.
3. Names cells, named ranges.Changes the name of a cell/s to insure an absolute reference. Makes reading formulas easy.
4. Sum, average, maximum, minimum, integer, rounding, counting, if, lookup.
5. Perform searches (filter) using AND, OR, NOT, LIKE, >, <, =, <=, >= (cuts down the stuff you see).
6. Perform searches using wildcards (this is where you use a *). If you said *th, you'd get anything ending in 'th e.g: beTH. th* would give anything starting with 'th'. They broaden searches.
7. Sort data

All formulas have thier own name, start with =, and have brackets.
When naming a cell, press enter otherwise it won't work.

SAVE AS EXCEL