Converting a List to a Table - Exercise

Contact Us or call 1-877-932-8228
Converting a List to a Table - Exercise

Converting a List to a Table

Duration: 5 to 10 minutes.

In this exercise, you will practice converting a list to a table.

  1. Open List to Table.xlsx from your Excel2013.2/Exercises folder.
  2. In Sheet1, convert the list of houses to a table.
  3. In Sheet2, convert the data into a table. Be sure to include all data in the worksheet in the table.

Solution:

  1. In Sheet1, convert the list of houses to a table.
    1. Select any cell within the list.
    2. On the INSERT tab, in the Tables group, click the Table command:Table Command
    3. In the Create Table dialog box:
      1. Verify that Excel has correctly guessed the correct data range ($A$1:$F$133).
      2. Check My table has headers if it isn't already checked.
      3. Click OK.
  2. In Sheet2, convert the data into a table. Be sure to include all data in the worksheet in the table.
    1. Delete the blank row (row 5).
    2. Select any cell within the list.
    3. On the INSERT tab, in the Tables group, click the Table command:Table Command
    4. In the Create Table dialog box:
      1. Verify that Excel has correctly guessed the correct data range ($A$1:$C$8).
      2. Check My table has headers if it isn't already checked.
      3. Click OK.
Next