Domain 3, Lesson 1 Create & Format Table

1 Create A Table
Using the locations and data, create a table with headers consisting of the data in row 2.

1. Select cells A2 through E11
2. Click the Insert tab
3. In the Tables group, click Table
4. Ensure the My table has headers check box is selected
5. Click the OK button

2 Apply A Table Style
Apply the Blue, Table Style Medium 20 style to the table on the current worksheet.

1. Click anywhere within the table
2. Click the Design tab under Table Tools
3. In the Table Styles group, click the Table Styles drop-down arrow
4. In the Medium section, click the Blue, Table Style Medium 20 style

3 Convert A Table To A Cell Range
Convert the table on this worksheet to a range of cells.

1. Click anywhere within the table
2. Click the Design tab under Table Tools
3. In the Tools group, click Convert to Range

Domain 3, Lesson 2 Modify, Filter & Sort Table Data

4 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

5 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

6 Total Rows In Table
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

7 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

8 Sort Records In 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