What is 10/100 Network Adapter?

It may seem like a silly question but what exactly is this part for?
Is it only for dial up internet connection with modem or Broadband or can it help facilitate local networking of 2 or more machines.
I always get confused on this one so any info much appreciated.