1. It automatically completes abbreviated words
2. It completes text entries that match an existing entry in the same column
3.It completes text and numeric entries that match an existing entry in the same column
4.It completes text entries that match an existing entry in the same worksheet