Excel 2007 Chapter 4:
Financial Functions, Data Tables,
and Amortization Schedules

All assignments on this page are due on 28 Mar, and may not be accepted for full credit past 19 Apr.



Chapter 4 Lessons

Enroll in Advanced eBook

Download student files

eBook Lesson 4:
Financial Functions, Data Tables, and Amortization Schedules


Files to turn in:

LN Brayden Mortgage Loan Payment Calculator.xlsx
+ 6 printouts

 


Rubric

 


20 points

 

 

Chapter 4
Review & Practice:

 

eBook Review Activities:

Apply Your Knowledge



Extend Your Knowledge


Make It Right


In the Lab
Lab 4-2

Cases & Places
#2

Files to turn in:

LN Apply 4-1 Monthly Loan Payment Complete.xlsx
+ 4 printouts (reg, hide, 2 pmt checks)

LN Extend 4-1 401(k) Planning Sheet Complete.xlsx
+ 2 printouts (reg, formulas)

LN Make It Right 4-1 Financial Calculator Complete.xlsx

LN Lab 4-2 The Bean Bag Game Company Quarterly Income.xlsx
+ 4 printouts (reg, formulas, 2 analysis)

LN Saving for College Planning Worksheet.xlsx

 

Rubric



Rubric



Rubric

 



Rubric



10 points


10 points



10 points


30 points



40 points


Chapter 4 Assessments

Complete as Homework!


Vocab Quiz 4 (Quia)

Review Worksheet 4 (Quia)


9 points

31 points

 

Chapter 4:
Reflection Question

Complete as Homework!

Copy and paste the questions below into a new email message.

Add the subject line Excel RQ 4

Answer each question fully as directed in the RQ guidelines & Rubric page

Send the email to kerri.pangman@eu.dodea.edu

Discuss the pros and cons of worksheet/workbook protection.

 

 

 

 

15 points