Daggah, usually the "sweet spot" refers to the aperture (or small range of apertures) where the lens sharpness is at the maximum. For primes, that is relatively easy to figure out, as you do a series of exposures varying the aperture through its range. Focusing for these kinds of test is always manual, and usually using some kind of focusing assist (such as the 10x magnify on live view). IS/VR is switched off, as is AF. Then it is possible to examine the images at each aperture and see where in the aperture range the sharpest images lie.
With zooms, this is more complicated, and the same sequence of tests (minimum through maximum aperture) are done at several focal lengths. The sweet spot that Sparky refers to IS dependent on the focal length, and it does happen that the aperture at which you get maximum sharpness varies as you go through the focal length range.
AF, and the issues of front/back focusing is something else, and the focusing can be adjusted by the user or some camera models, but require a trip to the service center for others. I have a Canon T1i which had some back-focusing issues, and after I sent the service center the images documenting this, they asked me to sent the camera in for adjusting. Now the auto-focus is much closer to where it needs to be, but is not perfect. S'ok. I know what I can shoot with AF and where I need to go to manual focus with the focus assist.