|
Microsoft
Excel has a robust library of Financial Functions.
Let's say that our little company, Charlotte's Website, needs a car. How
would you calculate the car payments?
Here are the
steps.
1. Before You Begin: Enter the Labels Open a new,
blank spreadsheet. Select Cell A1
and type: Present Value Select Cell A2
and type: Number of Payments Select Cell A3
and type: Interest Rate Select Cell A4
and type: Payment If these are
labels, and they are, they should be selected and formatted BOLD. Keep going...
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.4. Apply functions in formulas:
FINANCIAL Functions
|
|
| |
