MOS 2016 Study Guide for Microsoft Excel

Objective group 2. Manage data cells and ranges

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

2.1 Insert data in cells and ranges

2.2 Format cells and ranges

2.3 Summarize and organize data

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. An organized set of contiguous data is a data range. A data range can be as small as a list of dates, or as large as a multicolumn table that has thousands of rows of data.

You might populate ...