Differences Between LED, CFL, and Halogen Lights: Which One to Choose?

Which one is the best for office work? Which one is the best for general home use? Should you replace all of the lights in your home with a single type of bulb?