How do I not know this ?!
Google Docs Remembers Spreadsheet Formulas So You Don’t Have To
It even recognizes when you want to nest a function within another function. For people who aren’t Excel masters, this should greatly speed up spreadsheet work.