It depends on the task and the person. Familiar instrumental music or ambient sound can help some people focus on routine work; lyrics and novel music tend to distract during demanding, language-based tasks.
Test what works for you, and switch to quiet for your most demanding cognitive work.