{"id":30549,"date":"2024-07-30T07:15:13","date_gmt":"2024-07-30T07:15:13","guid":{"rendered":"https:\/\/www.writemyessays.app\/blog\/questions\/excel-2021-skills-approach-ch-10-challenge-yourself-10-3-course-name-2-day-courtesy-accessbcot113-20112-2024su-section-20112-summer-2024\/"},"modified":"2024-07-30T07:15:13","modified_gmt":"2024-07-30T07:15:13","slug":"excel-2021-skills-approach-ch-10-challenge-yourself-10-3-course-name-2-day-courtesy-accessbcot113-20112-2024su-section-20112-summer-2024","status":"publish","type":"questions","link":"https:\/\/www.writemyessays.app\/blog\/questions\/excel-2021-skills-approach-ch-10-challenge-yourself-10-3-course-name-2-day-courtesy-accessbcot113-20112-2024su-section-20112-summer-2024\/","title":{"rendered":"Excel 2021 Skills Approach – Ch 10 Challenge Yourself 10.3 COURSE NAME 2 Day Courtesy AccessBCOT113-20112-2024SU | Section 20112 Summer 2024"},"content":{"rendered":"

<\/p>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Skills needed to complete this project:<\/h3>\n
    \n
  • Saving a Macro-Enabled Workbook or Template (Skill 10.5)<\/li>\n
  • Adding the Developer Tab to the Ribbon (Skill 10.3)<\/li>\n
  • Recording a Macro (Skill 10.6)<\/li>\n
  • Modifying a Macro Using VBA (Skill 10.7)<\/li>\n
  • Adding a Custom Tab to the Ribbon (Skill 10.9)<\/li>\n
  • Adding a Macro to a Form Button Control (Skill 10.8)<\/li>\n
  • Running a Macro (Skill 10.4)<\/li>\n<\/ul>\n<\/div>\n
    \n

    Steps to complete this project:<\/h3>\n

    Mark the steps as checked when you complete them.<\/p>\n

      \n
    1. \n
    2. \n
    3. \n
    4. \n
    5. \n
    6. Create a macro to calculate yearly totals and yearly averages for each student.\n
        \n
      1. \n
      2. \n
      3. \n
      4. Record the <\/span>CalculateGrades<\/em> <\/span>macro following these steps:\n
          \n
        1. \n
        2. \n
        3. \n
        4. \n
        5. \n
        6. \n
        7. \n
        8. \n
        9. \n
        10. Create a macro to display the table <\/span>Total<\/em> <\/span>row and display the class average for each assignment. <\/span>Hint<\/em>: To display the table <\/span>Total<\/em> <\/span>row, check the <\/span>Total Row<\/span> <\/span>check box on the <\/span>Table Design<\/em> <\/span>tab, <\/span>Table Style Options<\/em> <\/span>group.
          \n
            \n
          1. \n
          2. \n
          3. \n
          4. \n
          5. \n
          6. \n
          7. \n
          8. Create a macro to hide the table <\/span>Total<\/em> <\/span>row. <\/span>Hint<\/em>: This macro has only one action: Uncheck the <\/span>Total Row<\/span> <\/span>check box on the <\/span>Table Design<\/em> <\/span>tab, <\/span>Table Style Options<\/em> <\/span>group.
            \n
              \n
            1. \n
            2. \n
            3. \n
            4. \n
            5. If you have permission, create a new custom Ribbon tab for the macros.\n
                \n
              1. \n
              2. \n
              3. \n
              4. Add a form button to the <\/span>ClassAnalysis<\/span> <\/span>worksheet to run the <\/span>CalculateGrades<\/span> <\/span>macro.\n
                  \n
                1. \n
                2. \n
                3. Add a form button to the <\/span>ClassAnalysis<\/span> <\/span>worksheet to run the <\/span>ShowAverages<\/span> <\/span>macro.\n
                    \n
                  1. \n
                  2. \n
                  3. Add a form button to the <\/span>ClassAnalysis<\/span> <\/span>worksheet to run the <\/span>HideAverages<\/span> <\/span>macro.\n
                      \n
                    1. \n
                    2. \n
                    3. \n
                    4. \n
                    5. \n
                    6. \n
                    7. \n
                    8. \n
                    9. \n
                    10. \n
                    11. \n
                    12. \n
                    13. \n
                    14. \n