Microsoft Office Tutorials and References
In Depth Information
Creating a Microsoft Excel 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 its column and row inter-
section. 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 each other) 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.
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 Actions feature works with other Microsoft Of-
fice 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. Additional research and language
tools area available to build up the content of your workbooks.
If you accidentally make a change to a cell, you can use the Undo feature to remove,
or “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 con-
Making Label Entries
There are three basic types of cell entries: labels, values, and formulas. A label is text in a
cell that identifies the data on the worksheet so readers can interpret the information. Ex-
cel does not use labels in its calculations. For example, the label price is used as a column
header to identify the price of each item in the column. A value is a number you enter in a
cell. Excel knows to include values in its calculations. To quickly and easily enter values,
you can format a cell, a range of cells, or a column with a specific number-related format.
Then, as you type, the cells are automatically formatted.
To perform a calculation in a worksheet, you enter a formula in a cell. A formula is
a calculation that contains cell references, values, and arithmetic operators. The result of
a formula appears in the worksheet cell where you entered the formula. The contents of
the cell appears on the formula bar. Entering cell references rather than actual values in a
formula has distinct advantages. When you change the data in the worksheet or copy the