MOS 2010 Study Guide for Microsoft® Word, Excel®, PowerPoint®, and Outlook®

Chapter 2. Creating Cell Data

The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2010 relate to inserting structured data in worksheet cells. Specifically, the following objectives are associated with this set of skills:

2.1 2.1 Construct Cell Data

2.2 2.2 Apply Auto Fill

2.3 2.3 Apply and Manipulate Hyperlinks

You might populate a worksheet from scratch or paste existing data from another source file. 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 a large amount of data that follows a pattern by filling a numeric or alphanumeric data series. You can fill ...