O'Reilly logo

MOS 2013 Study Guide for Microsoft® Excel® by Joan Lambert

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Manage Tables

The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2013 relate to creating tables. Specifically, the following objectives are associated with this set of skills:

3.1 Create tables
3.2 Modify tables
3.3 Filter and sort tables

Data stored in an Excel worksheet is organized in rows and columns of cells. Data in a contiguous range of cells is referred to as a data range. Similarly, an Excel table is a series of contiguous cells that have been formatted as a named Excel object that has functionality beyond that of a simple data range.

Some table functionality, such as the ability to sort and filter on columns, is also available for data ranges. Useful table functionality that is not ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required