Manage Table Styles and Options

Practice Labs Module
Time
51 minutes
Difficulty
Intermediate

The "Manage Table Styles and Options" module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises: Manage Table Styles and Options, Filter and Sort a Table.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

The Manage Table Styles and Options module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises:

  • Manage Table Styles and Options
  • Filter and Sort a Table

Lab time: It will take approximately 45 minutes to complete this lab.

Exercise 1 - Managing Table Styles and Options

A style is a combination of formats that you apply in a single step. For example, you might have a style that sets the font and size, number format, shading, and borders for a cell. Excel has many built-in-styles, and you can also define your own. Themes define a set of colors, fonts, and effects that go together to make your workbooks look good. You can choose existing themes or customize them.

Exercise 2 - Filter and Sort a Table

When you create a table, the headings in the header row all have small filter arrows next to them.

You can click these arrows to access a whole range of AutoFilter features that enable you to filter the table to show only those rows that meet a criterion.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.