What does a dead pixel look like – and can it be fixed?

Of all the things that could go wrong with a computer monitor or TV, a dead pixel or two is probably the most annoying ...