Designing Effective Worksheets

Two Designing Effective Worksheets

In this chapter, you will: complete these projects and practice these skills.


The City of Desert Park

© Getty Images, Inc.

Desert Park, Arizona, is a thriving city with a population of just under 1 million in an ideal location serving major markets in the western United States and Mexico. Desert Park's temperate year-round climate attracts both visitors and businesses, and it is one of the most popular vacation destinations in the world. The city expects and has plenty of space for long-term growth, and most of the undeveloped land already has a modern infrastructure and assured water supply in place.


[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



Go! With Microsoft Office 2003 Brief
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

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