Google spreadsheets can predict patterns and complete them for you.
For example; if I type into one column the following words:
1.Type words 2. Select cells 3. Hold alt key & drag handle down to auto complete the pattern.
Google can lookup information on the web and bring into your spreadsheet.
In the example below I used the auto fill to enter my states into the column A. Then I entered the following formulas: =GoogleLookup("entity", "attribute")
Repeat steps for autofill (ctrl + click & drag)
The end result is a spreadsheet full of data that would've taken me an hour or so to lookup and transfer into my spreadsheet.
Give it a try and pass on any other tricks that you find in Google docs.