Spreadsheet 5 . Spring 2019 . Copy ( (-Excel View Help MP Tell me what you want to do Ih Copy Condeional Fomlas Cell insert Delete Format Formating- Tbleyesr ClearFiher Select Task 1: Complete the Present Value of $1 Table below so that the values are the same as those shown in the table to the right. Use cell references, formulas, and functions to generate amounts. Do the 7% column first; then copy those formulas to the other columns Use the ROUND function so that calculated answers appear to five decimal places. Use a formatting features so numbers are shown with a leading zero before the decimal place. Table: Present Value of $1 Periods 7% 8% 9% 10% 1093458 092593 0 91743 0.90909 0873440 85734 084168 082645 3 081630 079383 77218 0.75131 4 076290 073503 070843 068301 5 0 71299 0 68058 0 64993 062092 Periods (n) 7% 9% 10%