Lesson for : MOS Excel 2013 # 77-420 – MOS Championship Lesson Status : Not Finished

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.

Category :

Reviews :  

Instructor : Team FAME Team FAME