Project 2B. Inventory Value

In Activities 2.7 through 2.16, you will create a workbook for Bill Peterson, the manager of Desert Park's municipal golf course. The golf course carries a small inventory of golf products and snacks in its pro shop. Mr. Peterson wants to calculate the retail value of the inventory of golf products and, using a pie chart, display how each item's retail value contributes to the total retail value. Your completed worksheet and chart will look similar to Figure 2.20.

Figure 2.20.

For Project 2B, you will need the following file:

New blank workbook

You will save your workbook as

2B_Inventory_Value_Firstname_Lastname


Objective 5 Design a Worksheet

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