77-420 Manage 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 multi column table that has thousands of rows of data. If you apply an Excel table format to a data range, it then becomes a table, which has additional functionality beyond that of a data range. We discuss tables in Chapter 3, “Manage tables.” The functionality in this chapter explicitly pertains to data ranges that are not formatted as Excel tables.
You might populate a worksheet from scratch or by creating, reusing, or calculating data from other sources. You can perform various operations on data when pasting it into a worksheet, either to maintain the original state of the data or to change it. When creating data from scratch, you can quickly enter large amounts of data that follows a pattern by filling a numeric or alphanumeric data series. You can fill any of the default series that come with Excel or create a custom data series.
This chapter guides you in studying ways of working with the content, appearance, and functionality of cells and data ranges.
Lesson Topics & Quizzes
|77-420-2.1 Insert data in cells and ranges|
|77-420-2.1 Practice skills|
|77-420-2.2 Format cells and ranges|
|77-420-2.2 Practice skills|
|77-420-2.3 Order and group cells and ranges|
|77-420-2.3 Practice skills|