Its less a question of best, and more a question of best value.
The Celeron is the least expensive, and the slowest. The math processor isn't there. But for most office work -email, smaller spreadsheets, surfing, its just fine thank you very much.
A Pentium D has two cores, a Core 2 Duo runs 2 cores efficiently and cooly. Both are suitable for more intensive applications.
Depending on your application, you might be better off buying the cheaper processor and taking the money you save and buying more RAM.
If you want to run Vista at some point, I would go for a faster processor, it is easier to add RAM than swap processors.
James