2.2 Creating a Table Using a Range of Data – Practice Exercise 9 – Intermediate Excel 2016

Practice Exercise 9: Create a table using a range of data
Open the Excel workbook, FIRST_RANGE_TO_TABLE_EXERCISE.xlsx in data folder.
STEP 1: Select the Workbook tab CREATE TABLE (FIGURE 1).

                                                                                    FIGURE 1
STEP 2: ​The first step in creating a table is selecting the Table option. Go up to the Ribbon and select the Insert tab. In the Tables section, select Table with mouse (FIGURE 2).
                                                                                    FIGURE 2
STEP 3: ​The Create Table dialog box appears with the range of the data it thinks you want to create a table from. The range should be, $A$1:$C$13 (FIGURE 3). If it’s anything else, select that range with the mouse by clicking and dragging the mouse to highlight the cells.
If it’s not checked, check the box, “My table has headers”. Click the OK button.
                                                                                         FIGURE 3
STEP 4: Your table is created and it’s highlighted so you can apply a style. Observe the contextual tab, “Table Tools”. From the Table Style palette, select – Table Style Medium 2.
Notice that the Header Row, Banded Rows, and Filter Button boxes have been checked. Leave them as is.
The result is the table in FIGURE 4.​
                                                               FIGURE 4
         
Tip: For future work use – if you don’t want the downward pointing filter buttons on each header field, banded rows, or header row, uncheck the appropriate box on the DESIGN tab of Table Tools in the “Table Style Options” section of the Ribbon. (FIGURE 5).
FIGURE 5
STEP 5: ​Your table is now finalized (FIGURE 6).
 
If you decide you want to convert the table back to a range of cells:

  1. Click on any cell in the table.
  2. Right-button mouse click and select Table from shortcut menu.

3. Select Convert to Range from the secondary menu choices (FIGURE 7).

FIGURE 6
    FIGURE 7
This is the end of this section. To continue, go to Module 2 Section 2.3  Customizing a Table Using the Total Row Feature; Practice Exercise 10