Sunday, February 20, 2011

Spreadsheets (Excel)

1: Import CSV- comma separated value, standardized format read by all computers

2: Absolute and relative references- refers to the cell A1, A1+ B1 = 2,

Relative means the formula changes depending where you copy and paste the formula.

Absolute means it will not move and will only refer to the cell that wherever you copy and paste the formula.

3:Named Cells- Is an absolute reference

4:Sum, average, maximum, minimum, integer, rounding, counting if, lookup

5:Perform searches/filtering- cutting down the information like a google search.

6:Perform searches using wildcards, wildcards means an * Asterix, wildcards broaden searches

7:Sort data

No comments:

Post a Comment