Display the Formula Builder after adding a function name. If you still cant see the formula for cells try unprotecting the sheet or the whole workbook. Control Shift U.
On the Excel menu click Preferences.
Keys as standard function keys unchecked. Excel for Mac Formulae Functions Quick Reference. Click the cell where you want the result of the function to appear then type the equal sign. The following example uses Excels built-in SUM function.