in the home tab
formulas
The Preview Transitions button is located in the Preview group on the Home tab?
For Excel 2007 it is on the Insert tab of the menu ribbon.
Yes
Analysis group on the data tab
Themes are located under the Design Tab. The Verve Theme is not available in PowerPoint for Mac.
Math
The "Insert" tab.
It is on the Page Layout tab.
The sort button is on the Home tab. I am not aware of a group button in Excel.
(View tab | Zoom group)