It's a popping sound, hard to explain if you've never heard it....well if you've ever cracked your fingers, it kind sounds like that, cept its only one click every rotation, not multiple.
If you go take a drive right now and compare the noise when you're going straight, compared to turning sharply, it should be louder when you turn because more stress is on the cv joint.