spreedsheet 2

Week # 7 - Chapter # 10 Assignment

This week we will see: Chapter 10 Level 3: Automating Excel Tasks where you will learn about one another valuable and powerful Excel tool – Macros

Macros are tools to automate Excel processes to help ensure error-free and efficient worksheets.

We will cover Level 3.

Let's get started: ==========================================================================================

Week # 7 - Chapter # 10 Assignment

Chapter # 10 - Level 3: Objectives (Pages 647 – 661)  Plan and record macros  Run and test macros  Customize ribbon tabs  Add macro buttons to a ribbon tab  Add custom buttons to a worksheet  View macro code using the Visual Basic Editor

Level Three: LEARNING

Read the Chapter Introduction and Case Scenario on page 606. Read it very carefully. It is important that you clearly understand what the Chapter material is all about – otherwise you will just be putting numbers in cells. We will focus this week in the Macros

The material covered the Case Scenario in Level 3 (pages 647 - 661) “Automating Excel Tasks”.

You should read learning material on pages 647 to 66 and the youtube.com video tutorial for this level. Use the attached presentation in Level 3 to see the video Level 3: “Automating Excel Tasks (MACROS)” Or use the link: https://www.youtube.com/watch?v=BHzUX9Tlxbs&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8a

uh8d&index=29

Level Three: PRACTICE: In the Week # 7 - Chapter 10 - Exercises.pdf document, make the Exercise Ch10-5: Level 3 – Daily List Post your completed file to Blackboard for review and grading. The file Name should be 10-5-DailyList-Monday-YourName.xlsm POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

Level Three: APPLYING: In the Week # 7 - Chapter 10 - Exercises.pdf document, make the Exercise Ch10-6: Level 3 – Projected Sales and Commissions for CKG Auto Post your completed file to Blackboard for review and grading. The file Name should be 10-6-July-Sales-YourName.xlsx.

POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

==================================================================

Week # 7 - Chapter # 10 Assignment

Create a Word Document 7-Essay-Chapter10-YourName to answer the following questions for Chapter# 10 Level 3. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

1. What is a macro? How could you use one in an Excel workbook?

2. Identify three ways to run a macro in Excel.

3. What is the difference between saving a macro to the current workbook versus a personal macro workbook?

4. What is VBA?

5. What is the first line of VBA code in a macro?

6. What is the major difference between an Excel workbook with an .xlsx filename

extension and an .xlsm extension?

Week # 7 - Chapter # 10 Assignment

Let me know if there is anything you don't understand -- the earlier the better. ALWAYS attach a copy of yours excel file clearly indicating where you have a problem.

The solution files that you need to attach are: 10-5-DailyList-Monday-YourName. (20 points) 10-6-July-Sales-YourName.xlsx (20 points) 7-Essay-Chapter10-YourName.docx (Questions requested) (20 points)