To do Alt + M Q on Mac in Excel, download and install Accelerator Keys, then press Option, followed by M, Q.
Command: More Functions Menu
This is how to do Alt + M Q on Mac in Excel with Accelerator Keys, the native ribbon and alt key shortcut solution for Mac users who get more done with Excel.
Alt + M Q opens the More Functions dropdown menu in Excel’s Formulas tab. This menu provides access to additional function categories including Statistical, Engineering, Cube, Information, Compatibility, and Web functions that aren’t shown in the main ribbon buttons.