The GEOMEAN and HARMEAN are advanced statistical functions that typically require a deeper understanding of mathematics. This is probably why they aren't taught as often as the AVERAGE function.
The 3 functional leader tasks Six years ago, I wrote (with colleague Jennifer Riel) a Harvard Business Review article on functional strategy. But the questions about functional strategy keep coming ...