Mark the steps as checked when you complete them.

Open the EllerSoftware$-04.$xlsx start file. Click the Enable Editing button. The file will be renamed

automatically to include your name. Change the project file name if directed to do so by your instructor, and save

it$.$

Import the EllerSoftwareText$-04.$txt file downloaded from the Resources link and load it to begin in cell A$4.$

The text file is tab$-$delimited.

NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to

open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon,

Show. Close the Excel Preferences dialog box.

$3.$

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

Click cell G$4$ and show AutoFilter arrows.

Use the AutoFilter arrow to sorthy date with the earliest date first. Then use the AutoFilter arrow to sort by

product$/$service name in ascending order.

Filter the Date column to show only contracts for September using the All Dates in the Period option.

Edit the label in cell A$2$ to display Contract Amounts for September.

Select cells A$1$:H$2$ and press command $+1$ to open the Format Cells dialog box. On the Alignment tab, in the

Horizontal Alignment drop$-$down, choose Center Across Selection.

Change the font size for cells A$1$:H$2$ to $20$ pt $($Figure $4-102).$