Description

In this project you will complete a vehicle shopping workbook to compare the purchase of several vehicles. After completing the project, you can make a copy of the file and use it to compare vehicle purchases you are considering for yourself. Be sure to save your work often! Skills needed to complete this project: 

• Naming Ranges of Cells 

• Calculating Averages 

• Finding Data Using the VLOOKUP Function 

• Working with Named Ranges 

• Using the Function Arguments Dialog to Enter Functions 

• Using the Logical Function IF 

• Calculating Loan Payments Using the PMT Function 

• Creating Formulas Referencing Data from Other Worksheets 

• Displaying and Printing Formulas 

• Finding Errors Using Trace Precedents and Trace Dependents