Introduction

Creating a Microsoft Office Excel 2003 workbook is as easy as entering data in the cells of an Excel worksheet. Each cell has a cell address which is made up of it's column and row intersection. Cells on a worksheet contain either labels or values, a formula or remain blank. Cell entries can be modified using the keyboard or mouse. You can select cells in ranges that are contiguous (selected cells are adjacent to eachother) or noncontiguous (selected cells are in different parts of the worksheet). Selected cells are used in formulas, to copy and paste data, to AutoFill, to apply date and time and other formatting functions.

If you accidentially make a change to a cell, you can use the Undo feature to "undo" your last change. Excel remembers your recent changes to the worksheet, and gives you the opportunity to undo them. If you decide to Redo the Undo, you can erase the previous change. This is useful when moving, copying, inserting and deleting cell contents.

In addition, Excel offers a Find and Replace feature that allows you to look for labels and values and make changes as necessary. When you need to spell check your worksheet, Excel can check and suggest spelling corrections. You can even customize the spelling dictionary by adding company specific words into AutoCorrect so that the spell checker doesn't think it's a misspelled word.

The Smart Tags feature works with other Microsoft Office 2003 programs to enhance your worksheets. Contact information can be pulled from your address book in Outlook, to your worksheet in Excel. Stock symbols can trigger a Smart Tag choice to import data on a publicly traded company.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net