How to solve

a$.$ Open $e04p1$ StudyAbroad and save it as $e04p1$ StudyAbroad$\_$LastFirst.

b$.$ Select the range A$5$:G$209.$ Click the Insert tab, click Table in the Tables group. Be sure to

select My table has headers and click OK in the Create Table dialog box.

c$.$ Type Students in the Table Name box in the Properties group.

d$.$ Click cell A$6.$ Click the View tab, click Freeze Panes in the Window group, and then

select Freeze Panes.

e$.$ Click the Data tab and click Remove Duplicates in the Data Tools group. Click OK and

click OK again.

f$.$ Click cell H$5,$ type Deposit, and then press Enter. Click cell I$5,$ type Balance$\_$Due, and

then press Enter.

g$.$ Click cell H$6,$ type Tuition