Excel 2003 In Pictures
Basic Calculations
Formatting Worksheets
Manipulating Data
Advanced Calculations
Making Data Visible
In cell
B8
, calculate the amount financed.
TIP:
Add the price and the finance charge.
In cell
B9
, calculate the estimated monthly payment for the Cooper Mini.
TIP:
Divide the amount financed by the number of payments.
In cell
F4
, calculate the average price of both cars.
In cell
G7
, calculate the maximum finance charge.
Calculate the finance charge, amount financed, and estimated monthly payment on the Hummer.
When you're done, the worksheet should look like this:
Save the workbook as
Cars
in the
Practice Excel Files
folder.
Close the workbook.
<< BACK
NEXT >>