In this chapter, you will: complete the following projects and practice these skills.
[Page 586 (continued)] With Microsoft Office Excel 2003, you can create and analyze data organized into columns and rows. After the data is in place, you can perform calculations, analyze the data to make logical decisions, and create a visual representation of the data in the form of charts. In addition to its worksheet capability, Excel can manage your data, sort your data, and search for specific pieces of information. In this chapter, you will create an Excel workbook. You will practice the basics of worksheet design; create a footer; enter and edit data in a worksheet; and save, preview, and print your work. You will construct formulas to calculate numbers, automatically complete text, use Excel's spelling checker tool, and access Excel's Help feature. You will use a workbook that has several worksheets and construct an interactive summary worksheet. |
Project 1A Tableware |
Windows XP
Outlook 2003
Internet Explorer
Computer Concepts
Word 2003
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Excel 2003
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Access 2003
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Powerpoint 2003
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Integrated Projects
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents