What sort of a user would go for a Pentium, and what sort of a user would go for a Celeron?

In other words, "If I use so and so applications, I should get a Pentium, but if I use these apps and not those, then I should got a Celeron."

Any elaborations?