EXCEL PROJECT 4

Financial Functions, Data Tables,
Amortization Schedules, and Hyperlinks

Essential Questions

How do you control the color and thickness of outlines and borders? How can you assign a name to a cell and refer to the cell in a formula by using the assigned name? How can you determine the monthly payment of a loan using the financial function PMT? How is an amortiztion schedule prepared? How can you determine a present value of a loan using the PV function?

How can you analyze worksheet data by changing values? How is a hyperlink added to a worksheet? How is the Set Print Area command used to print sections of a worksheet? What are the print options available in Excel? How are print options set? How can you protect a worksheet and its contents from being changed by someone else?

TERMS FOR EXCEL PROJECT 4

1. Name command 2. underscore character 3. global 4.label 5. PMT 6. data table

7.amortization schedule 8. PV 9. annuity 10. hyperlink 11. unprotected cells 12. protected cells

ASSIGNMENTS

Introduction to Financial Functions pp.4.04-4.06 1) Review common functions already used in past projects. 2) Introduce new finacial functions and their uses. 3) Class follows demo creating a loan payment calculator. 4) Begin Lab 1 part 1 numbers 1- 5, pp. 4.57-4.58 5) Work on vocabulary definitions as presented in class. September 24-26 Using a Data Table to Analyze Worksheet Data pp.418-4.27 1) Class follows demo of the creation of a one-input data table containing a pointer. 2) Continue Lab 1 part 1 numbers 6-14, p. 4.58 3) Continue with vocabulary September 29 - October 1 Creating an Amortization Schedule pp. 4.28-4.38 1) Class follows demo using formulas and functions to create an Amortization Schedule. 2) Students begin Lab 2 pp. 4.59-4.61 3) Continue with vocabulary October 2-7

Adding a Hyperlink to the Worksheet pp. 4.39-4.44 1) Class follows demo of adding an embedded graphic and hyperlink to a worksheet. 2) Continue working with Lab 2 3) Complete vocabulary (print) October 8-9 Protecting and Printing Sections of a Worksheet pp. 4.44-4.54 1) Class follows demo of setting print areas as well as protecting whole or parts of a worksheet.. 2) Complete Lab 2 and Lab 3 pp. 4.59-4.63 October 10-15 Additional exercises 1) Complete Learn It Online activities for review 2) Complete Practice Test located in the Handout Folder Tentative Test Date for Project 4 is Thursday October 16