Excel 2007 Demo: Using AutoComplete

See more Excel demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx
The Formula AutoComplete feature in Office Excel 2007 helps you avoid gotchas — those little syntax or typing mistakes that can break your formula and display an error in the cell.