Discovered quirks

Every case below is a real, executed formula whose result did not match documented/expected behavior. This is the flagship content of Can I Spreadsheet?: cross-engine divergence that only shows up when you actually run the formula.

86 quirks found across 41 functions.