MOS Study Guide for Microsoft Excel Exam MO-200

Objective group 2

Manage data cells and ranges

The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2019 relate to managing cells and cell content in worksheets. Specifically, the following objectives are associated with this set of skills:

• 2.1 Manipulate data in worksheets

• 2.2 Format cells and ranges

• 2.3 Define and reference named ranges

• 2.4 Summarize data visually

Excel stores data in individual cells of the worksheets within a workbook. You can process or reference the data in each cell in many ways, either individually or in logical groups. A set of contiguous data cells is a data range. A data range can be as small as a short list of dates or as large as a multicolumn table that includes thousands ...