1. Determine which vehicles are affordable.

In cell C26, enter a formula using the IF function to display "yes" if the total monthly cost (cell C24) is less than or equal to the total monthly amount available for vehicle expenses (Data sheet, cell A4). Display "no" if the total monthly cost is not less than or equal to the total monthly amount available.

2. Complete the Analysis section using formulas with statistical functions. Use named ranges instead of cell references in the formulas.

• Price
• MPG City
• MPG Highway
• Average MPG
• Maintenance/Year
• Registration Fee
• Insurance/Year
• Amount to Borrow
• APR
• Years
• Loan Payment
• Gas
• Maintenance/Month
• Insurance/Month
• Total Monthly