Select the range A1:A6 on the Christensen worksheet, merge the cells, and apply Middle Align vertical alignment. 2 3 Change the width of column K to 17.00, select the range K1:K3, and apply Thick Outside Borders. 2 4 Click cell C9, and freeze panes so that rows 1 through 7 and columns A and B are frozen. 1 5 Select the range E9:E54 and apply the Mar-12 date format. 2 6 Find all occurrences of Retired and replace them with Sold Out. 2 7 Click cell H9 on the Christensen worksheet, and insert a formula that calculates the percentage Raymond paid of the issue price by dividing the amount Paid by the Issue Price. Copy the formula from cell H9 to the range H10:H54.