I feel like this is a pretty important thing for the technically minded to get their heads around.

Doesn't the fact that you can't imagine a single reason why youd want multiple fonts on a spreadsheet alarm you?