In this project you will complete a vehicle shopping workbook to compare the purchase of several vehicles.
computer science
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
