MOS Study Guide for Microsoft Excel Exam MO-200

Objective group 3

Manage tables and table data

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

• 3.1 Create and format tables

• 3.2 Modify tables

• 3.3 Filter and sort table data

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 the automatic application of formatting, the automatic copying of formulas, and the ability to perform the following actions:

• Quickly insert ...