Creating a Worksheet and Charting Data

One Creating a Worksheet and Charting Data

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


Oceana Palm Grill

© Getty Images, Inc.

Oceana Palm Grill is a chain of 25 upscale, casual, full-service restaurants based in Austin, Texas. The company opened its first restaurant in 1975 and now operates 25 outlets in the Austin and Dallas areas. Plans call for 15 additional restaurants to be opened in North Carolina and Florida by 2010. These ambitious plans will require the company to bring in new investors, develop new menus, and recruit new employees, all while adhering to the company's strict quality guidelines and maintaining its reputation for excellent service.


[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



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