57%(23)13 out of 23 people found this document helpful
This preview shows page 2 out of 2 pages.
Select the range D11:G11, and then use the fill handle to copy the functions to row 12. In cell A12, enter2 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.00011In cell G5 reference the payoff date of the loan. Be sure to use a relative reference to the cell containing the date.5.00012Use the SUM function in cell G7 to calculate the total amount paid over the course of the loan, replacingthe existing value. Use the SUM function in cell G8 to calculate the total interest paid over the course ofthe loan. Both functions should return negative values.5.00013Format 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.00014Create a copy of the Faculty Data worksheet to the right of the last sheet tab. Rename the new worksheet as Faculty Data Exam.5.00015On 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.00016Use Find & Replace to replace all instances of Full with Full Professor in the Rank column. AutoFit the width of column D.5.00017Use the Quick Analysis tool to insert Data Bars in the Salary column. Change color of the data bars to Green (under Solid Fill).