Chapter 10 – Templates, Styles, Web, and Macros: Worksheet References, File Linking, and Auditing Formulas

Table of Contents

Lesson Plan...... 2

Solution for Ch 10 Homework (Hands-On Exercises in Chapter)... 4

Capstone Exercise for Ch 10 (End of Chapter Capstone Exercise).. 9

Solution for Capstone Exercise...... 10

1

Excel Chapter 10 – Templates, Styles, Web, and Macros:Worksheet References, File Linking, and Auditing Formulas

Materials Needed

Description of Document / Name of Document / Location of Files
Solution to Homework Hands-on Exercises for
Excel Chapter 10 / chap10_ho1_styles_solution.xlsx
chap10_ho1_amortization_solution.xlsx
chap10_ho1_world_template_solution.xltx
chap10_ho1_world_solution.xlsx
chap10_ho2_stock_solution.xlsx
chap10_ho2_stock_solution.htm
chap10_ho3_macros_solution.xlxm / Exploring Excel 2007
Chapter 10 Folder on
Instructor Resource Disk
or

Capstone Exercise for Excel Chapter 10 / ExplOffice2007_ExcelCh10CE.docx
Solution for
Capstone Exercise for Excel Chapter 10 / ExcelCh10CE_solution.xlsx
ExcelCh10CE_solution_formulas.xlsx
ExcelCh10CE_solution.xlsm
ExcelCh10CE_solution.htm
Answer Key for MyITLab Excel Chapter 10 / AnswerKey_MyITLab_Excel_Chap_10

Class Run-Down

  1. Have students turn in homework assignments.
  2. Talk about chapter using discussion questions listed below.
  3. Demonstrate Excel 2007.
  4. Direct students to the MyITLab site to complete the following:
  5. Excel Chapter 10 Pre-Test
  6. Study Plan
  7. Excel Chapter 10 Post-Test
  8. Have students complete Capstone Exercise for Excel Chapter 10.
  9. Give students Homework Handout for next class period.

Learning Objectives

At the end of this lesson students should be able to:

  • Work with existing templates, themes, and styles.
  • Use styles for advanced formatting.
  • Create a template.
  • Create a web page.
  • Create web queries.
  • Work with macros.
  • Create macro buttons.
  • Understand the basics of VBA.

Discussion Questions

  • VBA and macros can help automate many tasks, but some businesses have
    security concerns. How can you assure management that your macros or
    VBA applications are safe?
  • Why would you want to protect a workbook?
  • Why would the ability to turn a spreadsheet into a web page be beneficial to businesses?
  • What tasks could macros be created for to speed up data processing in Excel?

Additional Web Resources

From Microsoft Office Online for Excel 2007:

  • Create a macro
  • Create or remove a hyperlink
  • All about themes, Quick Styles, cell styles, and background styles

Demonstrate how to:

  • Apply styles to workbook data.
  • Use and modify themes in workbooks.
  • Create and modify a style in a workbook.
  • Use an existing template.
  • Protect a workbook.
  • Create and save a template.
  • Test a template.
  • Open the stock portfolio and complete the web query.
  • Compute the gain or loss, copy the formulas, and format the workbook.
  • Insert hyperlinks, an image, and a SmartArt graphic in the workbook.
  • Save as a web page.
  • Create a macro.
  • Test a macro.
  • Use the Visual Basic Editor.
  • Create and use the Erase Macro.
  • Step through macro and print the VBA code.
  • Add a custom button and print the workbook

1

Excel Chapter 10 – Templates, Styles, Web, and Macros:Worksheet References, File Linking, and Auditing Formulas

chap10_ho1_styles_solution.xlsx

chap10_ho1_amortization_solution.xlsx

chap10_ho1_world_.xlts

chap10_ho1_world_solution.xlxt

1

Excel Chapter 10 – Templates, Styles, Web, and Macros:Worksheet References, File Linking, and Auditing Formulas

chap10_ho1_world_solution.xlsx

1

Exploring Office 2007 Excel Chapter 10 Capstone Exercise

Student Name: ______Section: ______
Due Date: ______00 Points PossiblePoints Earned: ______

Objectives

  • Prepare a summary report presenting various totals and other requested information.
  • Create a web page and automate the process of printing with the use of macros.

Preparation & Helpful Information

Read Chapter 10 – “Templates, Styles, Web, and Macros: Worksheet References, File Linking, and Auditing Formulas” located in the Microsoft Office 2007 Professional book.

Check each step before continuing; it is easy to skip one when you hurry.

If you are not familiar with Excel, allow yourself extra time for the exercises.

Read this assignment sheet first before you complete any assignments. Many times there will be additional instructions not included in your book.

Instructions

Designate one disk for your Excel assignments, as these files take up a lot of space.

TASK 1: Read Excel Chapter 10, pages 000-000.

TASK 2: Complete Capstone Exercise: Little League Baseball on page 00.

TASK 3: Print the spreadsheet.

TASK 4: Print the formulas.

When you complete your assignment, do the following:

Turn in your assignment to your instructor.

1

Exploring Office 2007 Excel Chapter 10 Capstone Exercise

ExcelCh10CE_solution.xlsx

1