Some Reminders About Spreadsheets

Quick Strange Spread Sheet Rules

1. Select a Range using the Shift/Click Technique (Click in start cell; Hold SHIFT key down; click in end cell)
2. Fill Either Down or Right (CONTROL D or CONTROL R) YOU figure out which is R and which is D
3. The function you use to combine text (Insert Function) is Text/Concatenate
4. Sort arranges things
5. Filter turns on arrows which allow you to select a subset of data
6. IF the cell reference STAYS the same, it is an ABSOLUTE REFERENCE and must have a $ before the letter and a $ sign before the number, e.g. $A$24