Fast Wrap-Up

• Excel is a full-featured spreadsheet program that you can use to do simple or complex numeric operations.

• A workbook is a collection of worksheets in Excel. A worksheet is the page on which you perform mathematical operations. A cell is the intersection of a column and row, and stores one data value.

• You add data to the worksheet ”including number, text, date, and time values ”by clicking a cell and typing the information.

• You can use Excel s AutoFill feature to fill data cells quickly.

• Tablet PC support in Excel 2003 enables you to edit, annotate, and sketch worksheet changes on the fly.

• A range is a selected group of cells in a worksheet. You can name ranges that you work with regularly to find and reference them more easily.

• Excel includes a number of preset functions you can include in formulas to execute common operations. Excel provides a number of features to help you find the right function and ensure that your formulas are correct.

• Excel includes the Shared Workspace task pane to enable you to work collaboratively on projects with team members near and far. The feature uses SharePoint Team Services to create a shared Web site that houses important collaborative documents.

• XML support in Excel enables you to create, import, work with, and export XML data files and spreadsheets. You use a visual mapping tool to simply drag- and-drop XML tags to data items on the worksheet.

• Excel allows you to save your worksheets in a number of different file formats, including Web pages, XML Spreadsheets, text files, and files supported by other popular spreadsheet and database programs.

Chapter 8: Editing, Formatting, and Printing Spreadsheets

Overview

10-Second Summary

• Learn editing techniques for data, text, and formulas

• Copy, move, and paste cells and ranges

• Change data formats

• Choose text font, style, and size

• Add borders and shading

Entering and saving worksheet data is only a fraction of what you can do with Microsoft Office Excel 2003. Next steps involve making sure your worksheet is as accurate as it can be and making it look professional by choosing fonts, colors, pictures, and more. When you ve got the worksheet the way you want it, you can preview it to make sure the page breaks occur in the right places, and choose your favorite options before you print.

Aha! ”The Fastest Ways to Format

Microsoft Online includes a gallery of common worksheet templates you can use to build worksheets you are creating. If you want to apply formats to an existing worksheet section, you can use AutoFormat, available in the Format menu. See the section, Fast Formatting, later in this chapter for details.