Reference no: EM132901403

Create a macro to hide the table Total row. Hint: This macro has only one action: Uncheck the Total Row check box on the Table Tools Design tab, Table Style Options group. a. Name the new macro: HideTotalRow b. Do not include a keyboard shortcut. c. Include the description: Hide the Total row 11. If you have permission, create a new custom Ribbon tab for the macros. a. Name the new custom tab: My Macros b. Name the new custom group: Challenge Macros c. Add the three macros you created during this project. 12. Add a form button to the ClassAnalysis worksheet to run the CalculateGrades macro. a. Place the button to cover cells J1:L2. b. Edit the button label text to: Calculate Grades 13. Add a form button to the ClassAnalysis worksheet to run the ShowTotalRow macro. a. Place the button to cover cells J4:L5. b. Edit the button label text to: Show Assignment Averages 14. Add a form button to the ClassAnalysis worksheet to run the HideTotalRow macro. a. Place the button to cover cells J7:L8. b. Edit the button label text to: Hide Assignment Averages 15. Test the Show Assignment Averages and Hide Assignment Averages buttons. 16. Clear all content and formatting from rows 1:10. Caution: If you delete the rows, you will delete the buttons as well. Instead, use the Clear All command from the Home tab, Editing group