The archery skill affects the maximum distance you can shoot and the damage you do when you hit someone with a ranged weapon. For the similair skill, but then for Melee weapons, see the Combat skill. You get 1XP for shooting an arrow, and if you hit someone then you get bonus XP. The further you are away, the more XP you get.