Griffin | Computer Apps II
 
Resume Table of Contents  

Computer Apps II
Excel - Project 4

Project 4
Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks

 
1. Excel Project 1 Assignment
Duration: 2 Periods
  Read the Case Perspective, Objectives, Intro, and Project Preview. p. 241- 294
 

Chapter 4 Power Point

Objectives:

  • Control the color and thickness of outlines and borders
  • Assign a name to a cell and refer to the cell in a formula by using the assigned name
  • Determine the monthly payment of a loan using the financial function PMT
  • Use the financial functions PV (present value) and FV (future value)
  • Create a data table to analyze data in a worksheet
  • Add a pointer to a data table
  • Create an amortization schedule
  • Analyze worksheet data by changing values
  • Add a hyperlink to a worksheet element
  • Use names and the Set Print Area command to print sections of a worksheet
  • Set print options
  • Protect and unprotect cells in a worksheet
  • Use the formula checking features of Excel
  • Hide and unhide cell gridlines, rows, columns, sheets, and workbook
2.

Complete Project 4. Type your name and date in the left header. Print the worksheet and web page and hand into the instructor.

Project 4 e-MoneyLendersWorksheet
Project 4 e-MoneyLendersWebsite

Grading:
1. Project 4 e-MoneyLendersWorksheet  ___ 5 points
2. Project 4 e-MoneyLendersWebsite  ___ 5 points
Total  
 ___ 10 points
p. 245 - 293
3. Excel AYK 1 Assignment
Duration: 1 Period
p. 267 - 268
 

Complete the Apply Your Knowledge 1 Assignment. Type your name and date in the left header. Print and hand into the instructor.

  1. Print the formula version from Step #8. (Lanscape)
  2. Print the value version from Step #8. (Lanscape)
  3. Print a worksheet using the condo values from Step #11. (Lanscape)
  4. Print a worksheet using the motorcycle values from Step #11. (Lanscape)
  5. Hand in the 4 documents above to the instructor.
  6. Show the listed print ranges from Step #6 to the Instructor. (See page 284 for more information.)

Apply 4-1 MonthlyLoan

Grading:
1. Apply 4-1 MonthlyLoan  
Total  
 ___ 10 points
 
4.

Excel ITL 1 Assignment
Duration: 1 Period

p. 268 - 269
 

Complete the In The Lab 1 Assignment. Type your name and date in the left header. Print the 4 documents listed and hand into the instructor.

  1. Print the Part 1 - worksheet version from Step #10.
  2. Print the Part 1 - formulas version from Step #10.

  3. Print the Part 2 - worksheet version from Step #9.
  4. Print the Part 2 - formulas version from Step #9.

Lab 4-1 401(k) - Part 1
Lab 4-1 401(k) - Part 2

Grading:
1. Lab 4-1 401(k) - Part 1 (2 docs)  ___ 5 points
2. Lab 4-1 401(k) - Part 2 (2 docs)  ___ 5 points
Total  
 ___ 10 points
5.

Excel ITL 2 Assignment
Duration: 1 Period

p. 268 - 269
 

Complete the In The Lab 2 Assignment. Type your name and date in the left header. Print and hand into the instructor.

  1. Print the worksheet version from Step #12.
  2. Print the formulas version from Step #12.
  3. Print the worksheet for each data set (data 1, data 2, data 3).
  4. Print the worksheet with rows 7 - 21 hidden from step #14.

Lab 4-2 BE Analysis

Grading:
1. Lab 4-2 BE Analysis  ___ 10 points
Total  
 ___ 10 points
6.

Excel ITL 3 Assignment
Duration: 1 Period

p. 268 - 269
 

Complete the In The Lab 3 Assignment. Type your name and date in the left header. Print and hand into the instructor.

Lab 4-3 Amortization

Grading:
1. Lab 4-3 Amortization  ___ 10 points
Total  
 ___ 10 points
7.

Excel Cases and Places Assignment
Duration: 2 Periods

 
 

 

Grading:
1.    ___ 10 points
Total  
 ___ 20 points
 
8. CH4 Quiz Optional – Complete the Online Practice Test  

top