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 A4. The text file is tab-delimited.
Format the values in column H as Currency with zero decimal places.
Click cell G4 and use the AutoFilter arrow to sort by date oldest to newest.
Click cell F4 and 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 A2 to display Contract Amounts for September.
Select cells A1:H2 and press Ctrl 1 to open the Format Cells dialog box. On the Alignment tab, choose Center Across Selection.
Change the font size for cells A1:H2 to 20 pt (Figure 4-102) and close the Queries