Project 7 Interest Table: Create a spreadsheet to calculate how much a deposit of $1,000 would be worth if left in a bank for ten years at 6.5 percent annual interest. Show principal and interest for each year as follows: Annual Interest Rate: .065 YEAR PRINCIPAL INTEREST 1 $1,000.00 (a) 2 (b) At the bottom of the PRINCIPAL column, create a line sparkline to show its growth. NOTE: Note that the interest in cell (a) is the principal to its left times the absolute reference to the cell that contains .065. The new principal in cell (b) is the old principal plus the interest in the row above it. Copy these formulas in the remaining cells as needed. Save the workbook as SHEET7 and print it. Project 8 Advertising Report: Create an Advertising versus Sales report, as shown