1 Add Rows and Columns to a Table

In the table on the current worksheet, add a column with the name, Item Type, in between the Item and Clearwater columns. Then, add a row with an item name of Dumbbells in between the rows for Climbers and Treadmills.

1. Right-click any cell between B3 and B11
2. Point to Insert
3. Click Table Columns to the Left
4. Click in cell B2
5. Type: Item Type
6. Right-click any cell between A8 and F8
7. Point to Insert
8. Click Table Rows Above
9. Click in cell A8
10. Type: Dumbbells
11. Press the Enter key or click away from cell A8

​2 Table Style Options

Apply the First Column and Banded Columns table style options to the table on the current worksheet. Turn the Banded Rows option off.

1. Click anywhere within the table
2. Click the Design tab under Table Tools
3. In the Table Style Options group, select the First Column check box
4. In the Table Style Options group, select the Banded Columns check box
5. In the Table Style Options group, clear the Banded Rows check box

3 Total Rows in Tables

Using the Totals feature for tables, generate totals for columns C through F within the table on the current worksheet.

1. Click anywhere within the table
2. Click the Design tab under Table Tools
3. In the Table Style Options group, select the Total Row check box
4. Click cell C13
5. Click the drop-down arrow within the cell
6. Click Sum
7. Click cell D13
8. Click the drop-down arrow within the cell
9. Click Sum
10. Click cell E13
11. Click the drop-down arrow within the cell
12. Click Sum

4 Filter Records

In the table on the current worksheet, filter the records to display records with an item type of Machine.

1. Click the Filter drop-down arrow in cell B2
2. Clear the Select All check box
3. Select the Machine check box
4. Click the OK button

5 Sort Records in a Table

Sort the table on the current worksheet by Item Type and then by Item. Use ascending order for both sorts.

1. Right-click anywhere within the table
2. Point to Sort
3. Click Custom Sort
4. Click the Sort by drop-down arrow
5. Click Item Type
6. Click the Add Level button
7. Click the Then by drop-down arrow
8. Click Item
9. Click the OK button