How to Relink Missing or Offline Files in Lightroom

I don’t know a single Lightroom user (me included) who hasn’t noticed alarming exclamation point or question mark icons sullying their Lightroom Library. It can be downright scary...