In this chapter, you will: complete these projects and practice these skills.
[Page 694 (continued)] You can explore options in Excel by recalculating formulas that depend on other formulas. To take advantage of this powerful feature, think of yourself as a designer who determines a patterna pattern that can easily be expanded. Features such as copying, charting, sorting, formatting, subtotaling, and exporting work most efficiently if you arrange your data in a group of adjacent cells. Other simple groups of related titles, values, and formulas can exist on the same worksheet if there is at least one row or column of empty cells between them. For example, in this chapter, you will enter the first value in a column title and then fill in a sequence of titles with a single command. You will write a formula once and then fill it into adjacent cells where all of the formulas will be automatically recalculated every time you change a value in a single cell. You will design groups of data with headings and formulas so that the data can be effectively charted. Worksheets and the charts that are based on them can be used to try out different values, compare options, and then observe the effect on the formulas and charts. |
Project 2A Staff Schedule |
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