Sound cards, much like video cards, translate information from the computer into something which a human can understand. In the case of a sound card it translates that information into sound, playing music or other audio while you use your computer. Most computer users only need a standard audio card which today are built onto modern motherboards.
Those who have a need for high end sound quality, recording, or specialized audio output can purchase a better add on card.