Microsoft Office Tutorials and References
In Depth Information
Chapter Summary
Chapter Summary
In this chapter, you learned how to use names, rather than cell references, to enter formulas, use fi nancial functions,
such as the PMT and PV functions, analyze data by creating a data table and amortization schedule, set print options
and print sections of a worksheet using names and the Set Print Area command, protect a worksheet or workbook,
and hide and unhide rows, columns, sheets, and workbooks. The items listed below include all the new Excel skills
you have learned in this chapter.
1. Add Custom Borders and a Background Color to a
Range (EX 272)
2. Create Names Based on Row Titles (EX 276)
3. Enter the Loan Amount Formula Using Names
(EX 279)
4. Enter the PMT Function (EX 280)
5. Create a Percent Series Using the Fill Handle
(EX 286)
6. Defi ne a Range as a Data Table (EX 288)
7. Add a Pointer to the Data Table (EX 292)
8. Enter the Formulas in the Amortization Schedule
(EX 297)
9. Copy the Formulas to Fill the Amortization
Schedule (EX 301)
10. Set Up a Worksheet to Print (EX 307)
11. Set the Print Area (EX 309)
12. Name and Print Sections of a Worksheet (EX 310)
13. Protect a Worksheet (EX 313)
14. Hide and Unhide a Sheet (EX 316)
15. Hide and Unhide a Workbook (EX 317)
16. Enable Background Formula Checking (EX 319)
If you have a SAM user profi le, you may have access to hands-on instruction, practice, and
assessment. Log in to your SAM account ( to launch any assigned
training activities or exams that relate to the skills covered in this chapter.
Search JabSto ::

Custom Search