EXCEL PROJECT 6

Creating Templates and Working
With Multiple Worksheets and Workbooks

Essential Questions

How do you create and use a template? How are custom format codes used? How do you define, apply, and remove a style? How is a worksheet added to a workbook? How can you create a formula that uses 3-D references? How is a 3-D Cylinder chart drawn? How do you create a title using WordArt?

How are comments added to cells? How are headers and footers added to a worksheet? How is a page break inserted? How and why are the Find and Replace commands used within a worksheet? How is a workspace file created? How is data consolidated by linking workbooks?

TERMS FOR EXCEL PROJECT 6

1. template 2. dummy data 3. format code 4.3-D range 5. text box 6. comments

7.comment indicator 8. find command 9. string 10. match case 11. dependent workbook 12. source workbook

ASSIGNMENTS

Creating Templates pp. 6.06-6.22 1) Review common functions already used in past projects. 2) Introduce new financial functions and concepts. 3) Class follows demo creating a template for a Statement of Financial Condition. 4) Complete Lab 1 pp. 6.71-6.72 5) Work on vocabulary definitions as presented in class. October 27-30 Creating a Workbook from a Template pp.6.23-6.35 1) Class follows demo using a template to create multiple worksheets within a workbook. 2) Begin Lab 2 part 1 numbers 1-4, p. 6.72-6.73 3) Continue with vocabulary October 31-Nov. 4 Drawing and Formatting a 3-d Cylinder Chart pp. 6.35-6.45 1) Class follows demo using the chart wizard to draw and format a 3-d cylinder chart adding a WordArt title. 2) Continue with Lab 2 part 1 number 5, p. 6.73 3) Continue with vocabulary November 5-6

Adding Comments to a Workbook pp. 6.46-6.48 1) Class follows demo of adding comments to a worksheet 2) Continue working with Lab 2 part 1 number 6, p. 6.73 3) Complete vocabulary (print) November 7 Adding Headers and Printing Workbooks pp. 6.48-6.57 1) Class follows demo of adding headers and setting margins while exploring various print scenarios. 2) Complete Lab 2 part 2 , p. 6.73 November 10 -11 Using the Find and Replace Commands pp. 6.58-6.61 1) Class follows demo using the find and replace commands 2) Complete Lab 2 part 3 , p. 6.74 November 12 Additional exercises 1) Complete Learn It Online activities for review 2) Complete Practice Test located in the Handout Folder Tentative Test Date for Project 6 is Friday November 14