67%(3)2 out of 3 people found this document helpful
This preview shows page 1 - 2 out of 2 pages.
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 5Updated: 02/01/20181Current_Instruction.docx
Office 2016 – myitlab:grader – InstructionsExcel ProjectStepInstructionsPointsPossiblefill handle to complete the amortization table.11In cell G5, reference the payoff date of the loan. Be sure to use a relative reference to the cell containingthe date.512Use the SUM function in cell G7 to calculate the total amount paid over the course of the loan. 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.513Format all cells containing dollar amounts to currency, if necessary. Format all cells containing dates to display the date using the default Date format and center the dates in the cells.514Create a copy of the Faculty Data worksheet to the right of the last sheet tab. Rename the new worksheet as Faculty Data Exam.515On 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!516Use Find & Replace to replace all instances of Full with Full Professor in the Rank column. AutoFit the width of column D.517Use the Quick Analysis tool to insert Data Bars in the Salary column. Change color of the data bars to Green (under Solid Fill). Note, Mac users, use Conditional Formatting on the Home tab to complete thisstep.