It affects how the camera will expose the image, or more precisely, what areas of the image the processor will take into consideration when deciding on its aperture / shutter values.
Spot metering means that its using only a small spot of the frame to determinate exposure
Centered weight average is a bigger area and it takes the average of what it sees in this area.
Terms are different for Nikon.
More info is probably available in your manual