Working with Styles - Exercise

Contact Us or call 1-877-932-8228
Working with Styles - Exercise

Working with Styles

Duration: 5 to 15 minutes.

In this exercise, you will convert data to a table, change the format of the table, and format cells.

  1. Open Styles.xlsx from your Webucator/Excel2013.2/Exercises folder.
  2. Convert the data in cells A3:E8 to a table using one of the Light styles.
  3. Change the format of the table to one of the Dark styles.
  4. Apply a cell style to cells A1:C1.

Solution:

  1. Convert the data in cells A3:E8 to a table, using one of the Light styles.
    1. Select a cell in the range A3:E8:
    2. On the HOME tab, in the Styles group, click the Format as Table command:
    3. Select one of the Light style options from the drop-down list:
    4. In the Format as Table dialog box, verify which cells contain the data for the table and click OK:
  2. Change the format of the table to one of the Dark styles.
    1. Select a cell in the range A3:E8:
    2. Click the More arrow in the Table Styles group:
    3. Select one of the Dark style options from the list:
  3. Apply a cell style to cells A1:C1.
    1. Select cells A1:C1.
    2. On the HOME tab, in the Styles group, click the Cell Styles command:
    3. Choose a style from the styles available by clicking on it:
Next