It sounds like your mate has wiped the drivers for your sound chip. (Nice mate!) You need to download drivers from your PC manufacturer's web site.
Can't help anymore as you don't say what PC you have. You don't have a Celeron, that is just the processor chip in it.
T, February 2009