When I moved from Excel for Windows to Excel 2008 for Mac, I found that F4 didn't switch between relative and absolute references while editing a formula in that version. This was an Excel 2008 observation: Microsoft's current Mac shortcut list includes Cmd+T or F4 for switching formula reference styles. For current keyboard checks, see what F4 does in Excel for Mac. Thankfully Excel 2011 has a Switch Reference toolbar icon on the Formulas Ribbon, as shown below.

Keyboard Shortcut in Excel for Mac
In trying to find a shortcut, I opened up Excel 2008 for Mac, went to the Help search bar, typed in "Excel Keyboard Shortcuts," and was able to find out that Cmd+T toggles the formula reference style between absolute, relative, and mixed.
So I go back to Excel 2011 for Mac and, lo and behold, ⌘+T works there as well.
Gotta love that keyboard shortcut list in Help. It's my new best friend in Excel for Mac. :)