Microsoft Office Tutorials and References
In Depth Information
CHAPTER FOUR Financial Functions, Data Tables, and Amortization Schedules
4 Financial Functions, Data Tables,
and Amortization Schedules
Objectives
You will have mastered the material in this chapter when you can:
Control the color and thickness of
outlines and borders
Assign a name to a cell and refer
to the cell in a formula using the
assigned name
Determine the monthly payment of a
loan using the fi nancial function PMT
Use the fi nancial 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
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 workbooks
 
Search JabSto ::




Custom Search