Microsoft Office Tutorials and References
In Depth Information
Learn It Online
Learn It Online
Learn It Online is a series of online student exercises that test your knowledge of chapter
content and key terms.
Instructions: To complete the Learn It Online exercises, start your browser, click the Address bar, and
then enter the Web address scsite.com/ex2007/learn . When the Excel 2007 Learn It Online
page is displayed, click the link for the exercise you want to complete and then read the instructions.
Chapter Reinforcement TF, MC, and SA
A series of true/false, multiple choice, and short
answer questions that test your knowledge of the
chapter content.
Who Wants To Be a Computer Genius?
An interactive game that challenges your
knowledge of chapter content in the style of a
television quiz show.
Flash Cards
An interactive learning environment where
you identify chapter key terms associated with
displayed defi nitions.
Wheel of Terms
An interactive game that challenges your
knowledge of chapter key terms in the style of the
television show Wheel of Fortune .
Practice Test
A series of multiple choice questions that test your
knowledge of chapter content and key terms.
Crossword Puzzle Challenge
A crossword puzzle that challenges your
knowledge of key terms presented in the chapter.
Apply Your Knowledge
Reinforce the skills and apply the concepts you learned in this chapter.
Determining the Monthly Loan Payment
Instructions: Start Excel. Open the workbook Apply 4–1 Monthly Loan Payment from the Data Files
for Students. See the inside back cover of this topic for instructions for downloading the Data Files for
Students or see your instructor for information on accessing the fi les required in this topic.
Perform the following tasks.
1. Use the Create from Selection button in the Defi ned Names group on the Formulas tab to create
names for cells in the range C4:C9 using the row titles in the range B4:B9.
2. Enter the formulas shown in Table 4–5.
Table 4–5 Data Table Formulas
Cell
Formula
C8
=Price – Down_Payment
C9
=– PMT(Interest_Rate/12, 12 * Years, Loan_Amount)
F4
=C9
G4
+12 * C7 * C9 + C
H4
=G4 – C4
Continued >
 
 
Search JabSto ::




Custom Search