In Activities 2.1 through 2.6, you will create, format, and print a large worksheet for Juanita Morales, who manages the evening shift at the concession stand at Riverside Park, the park in the downtown area of the city of Desert Park. The worksheet shows each shift and the staff member assigned to that shift. Your resulting worksheet will look similar to Figure 2.1.
Figure 2.1.
For Project 2A, you will need the following file: |
New blank workbook |
You will save your workbook as
2A_Staff_Schedule_Firstname_Lastname
Objective 1 Use AutoFill to Fill a Pattern of Column and Row Titles |
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