Being tagged in a photo means that your name will appear when somebody views that photo. Photos that you are tagged in will also appear in your Photos section and your friends news feed.