Excel Ch 2.D Car Calculator Project Description: As a financial consultant, you work with a family that plans to purchase a $35,000 car. You want to create a worksheet containing variable data (the price of the car, down payment, date of the first payment, and borrower’s credit rating) and constants (sales tax rate, years, and number of payments in one year). Borrowers pay 0.5% sales tax on the purchase price of the vehicle and their credit rating determines the required down payment percentage and APR. Your worksheet needs to perform various calculations. Step Instructions Points 1 Open the downloaded file exploring_e02_grader_h3.xlsx SAVE AS: Lastname.Firstname-ExcelCh2-CarCalculator.xlsx 0 2 In cell A1, Type Auto Loan Calculator and Then merge and center the title on the first row in the range A1:F1. Apply bold, 18 pt font size, and Gold, Accent 4, Darker 25% font color. 5 3 In cell C6, Insert a Function to display the current date. 5 4 Select the range A3:C3 and Use the Format Painter to copy the formatting to the ranges A9:C9, E3:F3, E9:F9, A14:C14 (double-click
You've reached the end of your free preview.
Want to read all 3 pages?
- Spring '08