|
Exam 77-427 Microsoft Excel 2013 EXPERT 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...
|
|
| |
