Select the range A11B12 and then use the fill handle to complete the columns

# Select the range a11b12 and then use the fill handle

• 2
• 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 5 Updated: 02/01/2018 1 Current_Instruction.docx
Office 2016 – myitlab:grader – Instructions Excel Project Step Instructions Points Possible fill handle to complete the amortization table. 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 12 Use 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. 5 13 Format 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. 5 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 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 16 Use Find & Replace to replace all instances of Full with Full Professor in the Rank column. AutoFit the width of column D. 5 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). Note, Mac users, use Conditional Formatting on the Home tab to complete this step.