Foam cells are lipid-laden macrophages that appear in various pathological conditions, most notably in atherosclerosis. They are named for their foamy appearance due to the presence of numerous lipid droplets within the cytoplasm. These cells play a significant role in the formation of atherosclerotic plaques.