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
• Finding Minimum and Maximum Values
• Using Formula AutoComplete to Enter Functions
• Updating Named Ranges with the Name Manager
• Editing and Deleting Names with the Name Manager
• Checking Formulas for Errors
Attachment:- assignment.rar