The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2013 relate to managing cells and cell ranges in worksheets and workbooks. 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 Order and group cells and ranges|
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. If you apply an ...