In cell A12 enter 2 as the second payment number and in cell B11 enter 1012017

# In cell a12 enter 2 as the second payment number and

• Homework Help
• 3
• 0% (3) 0 out of 3 people found this document helpful

This preview shows page 2 - 3 out of 3 pages.

12. In cell A12, enter 2 as the second payment number and in cell B11, enter 10/1/2017 as the second payment date. In cell C12, insert a relative reference to the ending balance in cell G11. Select the range A11:B12, and then use the fill handle to complete the columns through row 70. Select the range C12:G12, and then use the fill handle to complete the amortization table. 5.000 11 In cell G5 reference the payoff date of the loan. Be sure to use a relative reference to the cell containing the date. 5.000 12 Use the SUM function in cell G7 to calculate the total amount paid over the course of the loan, replacing the existing value. Use the SUM function in cell G8 to calculate the total interest paid over the course of the loan. Both functions should return negative values. 5.000 13 Format all cells containing dollar amounts to currency, if necessary. Format all cells containing dates to display the date in the mm/dd/yyyy format and center the dates in the cells. 5.000 14 Create a copy of the Faculty Data worksheet to the right of the last sheet tab. Rename the new worksheet as Faculty Data Exam . 5.000 15 On the Faculty Data Exam worksheet, sort the table data by Department, then by Rank, both in ascending order. Insert a comment in cell J3 with the text Matching Rate Should Be Raised! 5.000 16 Use Find & Replace to replace all instances of Full with Full Professor in the Rank column. AutoFit the width of column D. 5.000 17 Use the Quick Analysis tool to insert Data Bars in the Salary column. Change color of the data bars to Green (under Solid Fill).