How the roughness of sandpaper affect its ability to smooth various surfaces?

The rougher the sandpaper, the more it takes off the material being sanded. The finer the grade (smoother) the smoother the finish will be. Rougher grades are used at the beginning to remove tool marks and shape the material, and you gradually work up to the finer grades for finish work.

The very finest grades are used to polish the finish.