n. Utilize freeze panes function in Excel to ensure the cells that contain headers (row2), loan numbers, and dates (column A and B} are always showinglfixed, regardless of scrolling up, down, right or left in the workbook. 7. Qiegngg: (5 points)_ a. Type \"Loans not in CAP" in cell A1, and \"Loans with attribute variances" in cell A20. Name D2 as \"8:31" and E2 as \"CAP" b. Insert formula{s) in D3 and E3 and below to represents all the SQ1 loan numbers that do not exist in CAP. c. Name cell D21 as \"Loan it", and E21 as \"Attribute Name " Do a similar process as last step for loans with different key attributes in Cell D21 and G21. You can use referencing for cells under column D. You may populate data under column E with formula. Your work should look like the followings. The numbers or attributes appeared on screenshot are hypothetical and only for presentation purposes. If a loan is not in CAP (missing in CAP), then it should not show up under the "Loans with attribute variances\" table. Loans not in CAP 391 CAP Loan #123 Not ExistedfMissing Loan # Loan #456 Not ExistedtMissing Loan # Loans with attribute variances 30.1 % Loan #?39 Principal Loan #000 Maturity Date 3: Principal d. Generate a pivot table in Difference worksheet cell (33 that shows the Loan Purpose (SQ1 worksheet column AE) with the percentage of each category compared to the Grand total. Categories with 0.00% must be not showindfetiminated