Import data from a text file.

a$.$

Select the Contracts sheet tab and select cell A$4.$

b$.$

Use the From Text $($Legacy$)$ command to preview the EllerText$-04.$txt file downloaded from the

Resources link in the Import Data window.

c$.$

Click Next in the Text Import Wizard to move on to step $2.$

d$.$

Click Next in the Text Import Wizard after verifying Tab is selected under Delimiters.

e$.$

Click Finish to close the Text Import Wizard and import the data.

f$.$

Load the data to cell A$4$ in the existing worksheet.

g$.$

Click column C$,$ the Address column, to select it$.$ Delete the column to remove it$.$

h$.$

The Phone Number column should be selected. If it is not, select column C$,$ and delete the column to

remove the Phone Number data.

i$.$

Use command to select columns D$,$ E$,$ and G and Delete them to remove the ZIP, ID$,$ and First Contact

data from the worksheet.

j$.$

Select cells A$4$:E$31$ and click the Format as Table button $[$Home tab, Styles group$],$ use Green, Table

Style Medium $7$ style. NOTE: If you receive a message saying the selection overlaps one or more

external data ranges, click Yes in the message box to convert the selection to a table and remove all

external connections.

Place a formula in a table.

a$.$

Select cell F$4,$ type Fees as the header, and press Enter.

b$.$

Select cell F$5$ and build a formula to multiply the value in cell E$5$ by $225.$

c$.$

Format the values in column F as Currency with zero decimal places.

d$.$

Click cell A$5.$

Sort the data by Fees and then by City, both in ascending order.

Change the font size for cells A$1$:A$2$ to $20$ pt $.$ and set the font style to bold.

Select cells A$1$:F$2$ and center them across the selection.

Copy the Billable Hours sheet to the end and name the copy Data.