Project 5/7: Government Surplus

You are an assistant to an administrator responsible for liquidating government surplus. Each year, your office holds several auctions of confiscated unclaimed stolen property. You've been tasked with preparing a workbook for these auctions.

On the Sold worksheet, insert a new column before column A.

1. On the Sold worksheet, select column A by clicking the A at the top of the column.

2. Right-click on the column and select Insert.

Split the view of the Sold worksheet so only rows 1 through 6 appear in the top pane and the remaining rows appear in the bottom pane.

1. On the Sold worksheet, select row 7.
   (Hint: When splitting views, select the row below the last row you want to appear in the top pane.)

2. On the View tab, in the Window group, click Split.

Configure the Vehicles worksheet so rows 1 through 3 remain visible as you scroll vertically.

1. On the Vehicles worksheet, select row four (Hint: When freezing frames vertically, select the row below the last row you want to remain visible.)

2. On the View tab, in the Window group, click the Freeze Panes down arrow and select Freeze Panes.

On the Sold worksheet, format the table so that every other row is shaded similar to the table on the Vehicles worksheet. Use a technique that automatically updates the formatting if you insert a new row.

1. On the Sold worksheet, click anywhere within the table to select it.

2. On the Table Tools Design contextual tab, in the Table Styles Options group, click the Banded Rows box to enable it.

On the Vehicles worksheet, insert a function into cell B4 of the Code column that extracts the two leftmost letters of the vehicle style displayed in cell D4.

1. On the Vehicles worksheet, select cell B4.
   (Hint: Always put your formula in the cell where you want the result displayed.)

2. In the Formula Bar, type =LEFT, then press the tab key on your keyboard.

3. To the left of the Formula Bar, click fx to open the Function Arguments wizard.

4. In the Function Arguments wizard, configure the following:

• Text: D4

• Num_chars: 2

5. Click OK.

(Hint: The result should be Se.)