Texas State University San Marcos Use of the Show Class Averages Worksheet
Question Description
I’m working on a excel question and need guidance to help me study.
- f the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.
- Save the file as a macro-enabled workbook with this file name:
[your initials]EX-ChallengeYourself-10-3 - Display the Developer tab. (If you already have the Developer tab enabled, skip to step 5.)
- Begin with the ClassAnalysis worksheet active.
- Create a macro to calculate yearly totals and yearly averages for each student.
- Name the new macro: CalculateGrades
- Include the keyboard shortcut: Ctrl+Shift+G
- Include the description: Calculate student totals and averages
- Record the CalculateGrades macro following these steps:
- In G1, create a column heading: Total
- In H1, create a column heading: Average
- Click cell A2.
- Format the data as a table using the Blue, Table Style Medium 6 table style. Be sure to include the table header row.
- In the Total column, use the SUM function to calculate the yearly total for each student.
- In the Average column, use the AVERAGE function to calculate the yearly average for each student.
- Autofit columns G and H.
- Don’t forget to stop recording the macro.
- Edit the CalculateGrades macro to use the Table Style Medium 2 table style instead of Table Style Medium 6. Hint: Edit this line in the VBA code:
ActiveSheet ListObjects("Table1") TableStyle = "TableStyleMedium6" - Add the CalculateGrades macro to the Quick Access Toolbar for just this workbook.
- Create a macro to display the table Total row and display the class average for each assignment. Hint: To display the table Total row, check the Total Row check box on the Table Design tab, Table Style Options group.
Create a macro to display the table Total row and display the class average for each assignment. Hint: To display the table Total row, check the Total Row check box on the Table Tools Design tab, Table Style Options group.
- Name the new macro: ShowClassAverages
- Do not include a keyboard shortcut.
- Include the description: Show Total row with averages
- Display the table Total row.
- Change the text in the first cell of the Total row to: Class Averages
- Select Average in the Total row for columns C:H.
- Stop recording the macro.
- 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 Design tab, Table Style Options group.
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.
- Name the new macro: HideClassAverages
- Do not include a keyboard shortcut.
- Include the description: Hide the Total row
- Don’t forget to stop recording the macro.
- If you have permission, create a new custom Ribbon tab for the macros.
- Name the new custom tab: My Macros
- Name the new custom group: Challenge Macros
- Add the three macros you created during this project.
- Add a form button to the ClassAnalysis worksheet to run the CalculateGrades macro.
- Place the button to cover cells J1:L2.
- Edit the button label text to: Calculate Grades
- Add a form button to the ClassAnalysis worksheet to run the ShowClassAverages macro.
- Place the button to cover cells J4:L5.
- Edit the button label text to: Show Class Averages
- Add a form button to the ClassAnalysis worksheet to run the HideClassAverages macro.
- Place the button to cover cells J7:L8.
- Edit the button label text to: Hide Class Averages
- Test the Show Class Averages and Hide Class Averages buttons.
- 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.
- Go to the Class1B worksheet and copy the data in cells A1:F10.
- Go to the ClassAnalysis worksheet and paste the copied data beginning in cell A1.
- Run the CalculateGrades macro using any method.
- Use the Show Class Averages button to run the ShowClassAverages macro.
- Save the workbook.
- If you are going to submit this project in SIMnet, save a copy of it as a regular Excel workbook (without macros).
- If you added a custom tab to the Ribbon, you may want to remove it before closing the workbook.
- save and Close the workbook
- Once completed please send me the file
"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you "A" results."