Excel 2010 In Pictures

2 Enter the following data:

A B C D E F G
1 Buying Cars
2
3 Dream Car Cooper Hummer Total Diff Avg Max
4 Price 17000 56000
5 Payments 60 48
6 Interest Rate .07 .08
7 Finance Chg
8 Amt Financed
9 Est Monthly Pmt

TIP: Click and drag on the column divider to make more room for the words in column A.

3 In cell D4, calculate the total price of both cars together.

4 In cell D5, calculate the total number of payments made on both cars.