Objective group 3. Create tables

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

3.1 Create and manage tables

3.2 Manage table styles and options

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. An Excel table is a named 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 available for data ranges includes ...

Get MOS 2016 Study Guide for Microsoft Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.