Go to:  Level 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Level 10: Practice

Calculate a Car Payment, part one Start Microsoft Excel and create the labels Enter the Labels In Cell A1 type: Present Value In Cell B1 type: Interest In Cell C1 type: Months In Cell D1 type: Payment Select Column A and format the labels big, bold, and centered Add the data   A B C D 1 Present Value $20,000     2 Interest 6.5%     3 Months 48     4 Payment       Select Cell B1 and format for Currency Select Cell B2 and format for Percent Note: the numbers are aligned with two decimal places Use the toolbar to increase and decrease the decimal places more on the next page