Exploring Microsoft Excel 2003 Comprehensive
For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
Results 1-3 of 16
Excel has more than 100 different functions in various categories. Financial
functions, such as the PMT function we are about to study, are especially
important in business. The PMT function requires three arguments (the interest
rate per ...
Consider the PMT function as it appears in cell B6: =PMT(A6/12,30*12,-$C$1) L
The amount of the loan, -$C$1, is an absolute reference that remains constant
Number of periods (30 years* 12 months/year) L The interest rate, A6/12, is a ...
Step 3: Formula bar displays function entered in cell B6 Click in B6 and enter
PMT function ScreenTip displays arguments for function Determine the 30-year
Payments □ Click in cell B6 and enter the formula =PMT(A6/ 12,30* 12 ,-$C$l) as
What people are saying - Write a review
What Is a Spreadsheet?
The File Menu
A Better Grade Book
16 other sections not shown