GO! with Mac Office 2011

Contents

GO! Walkthrough

 

Common Features

Chapter 1 Using the Common Features of Microsoft Office for Mac 2011

Project 1A PowerPoint File

Objective 1 Use Finder to Locate Files and Folders

 Activity 1.01 Using Finder to Locate Files and Folders

Objective 2 Locate and Open a Microsoft Office for Mac 2011 Application

 Activity 1.02 Locating and Opening a Microsoft Office for Mac 2011 Application

Objective 3 Enter and Edit Text in an Office for Mac 2011 Application

 Activity 1.03 Entering and Editing Text in an Office for Mac 2011 Application

Objective 4 Perform Commands from a Dialog Box

 Activity 1.04 Performing Commands from a Dialog Box

Objective 5 Create a Folder, Save a File, and Close an Application

 Activity 1.05 Creating a Folder, Saving a File, and Closing an Application

Objective 6 Add Document Properties and Print a File

 Activity 1.06 Adding Document Properties and Printing a File


Project 1B Word File

Objective 7 Open an Existing File and Save It with a New Name

 Activity 1.07 Opening an Existing File and Saving It with a New Name

Objective 8 Explore Options for an Application

 Activity 1.08 Viewing Application Preferences

Objective 9 Perform Commands from the Menu, Standard Toolbar, and Ribbon

 Activity 1.09 Performing Commands from the Menu, Standard Toolbar, and Ribbon

 Activity 1.10 Minimizing, Displaying, and Restoring the Ribbon

Objective 10 Apply Formatting in Office Applications

 Activity 1.11 Formatting and Viewing Pages

 Activity 1.12 Formatting Text

 Activity 1.13 Using the Clipboard to Cut, Copy, and Paste

 Activity 1.14 Viewing Print Preview and Printing a Word Document

Objective 11 Use the Microsoft Office for Mac 2011 Help System

 Activity 1.15 Using the Microsoft Office for Mac 2011 Help System in Excel

Objective 12 Compress Files

 Activity 1.16 Compressing Files

Summary, Key Terms, Matching, and Multiple Choice

 

Word

Chapter 1 Creating Documents with Microsoft Word for Mac 2011

Project 1A Flyer

Objective 1 Create a New Document and Insert Text

 Activity 1.01 Starting a New Word Document and Inserting Text

Objective 2 Insert and Format Graphics

 Activity 1.02 Formatting Text Using Text Effects

 Activity 1.03 Inserting and Resizing Pictures

 Activity 1.04 Wrapping Text Around a Picture

 Activity 1.05 Moving a Picture

 Activity 1.06 Applying Picture Styles and Artistic Effects

 Activity 1.07 Adding a Page Border

Objective 3 Insert and Modify Text Boxes and Shapes

 Activity 1.08 Inserting a Shape

 Activity 1.09 Inserting a Text Box

 Activity 1.10 Moving, Resizing, and Formatting Shapes and Text Boxes

Objective 4 Preview and Print a Document

 Activity 1.11 Adding a File Name to the Footer

 Activity 1.12 Previewing and Printing a Document

 

Project 1B Information Handout

Objective 5 Change Document and Paragraph Layout

 Activity 1.13 Setting Margins

 Activity 1.14 Aligning Text

 Activity 1.15 Changing Line Spacing

 Activity 1.16 Indenting Text and Adding Space After Paragraphs

Objective 6 Create and Modify Lists

 Activity 1.17 Creating a Bulleted List

 Activity 1.18 Creating a Numbered List

 Activity 1.19 Customizing Bullets

Objective 7 Set and Modify Tab Stops

 Activity 1.20 Setting Tab Stops

 Activity 1.21 Modifying Tab Stops

Objective 8 Insert a SmartArt Graphic

 Activity 1.22 Inserting a SmartArt Graphic

 Activity 1.23 Modifying a SmartArt Graphic

Summary, Key Terms, Matching, and Multiple Choice

 

Skills Review

Mastering Word

GO! Fix It

GO! Make It

GO! Solve It

Rubric

GO! Think

You and GO!

GO! Group Business Running Case

 

Chapter 2 Using Tables and Templates to Create Resumes and Cover Letters

Project 2A Resume

Objective 1 Create a Table

 Activity 2.01 Creating a Table

Objective 2 Add Text to a Table

 Activity 2.02 Adding Text to a Table

 Activity 2.03 Inserting Existing Text into a Table Cell

 Activity 2.04 Creating Bulleted Lists in a Table

Objective 3 Format a Table

 Activity 2.05 Changing the Width of Table Columns

 Activity 2.06 Adding Rows to a Table

 Activity 2.07 Merging Cells

 Activity 2.08 Formatting Text in Cells

 Activity 2.09 Changing the Table Borders

 

Project 2B Cover Letter and Resume

Objective 4 Create a New Document from an Existing Document

 Activity 2.10 Creating a Letterhead

 Activity 2.11 Creating a Document from an Existing Document

Objective 5 Change and Reorganize Text

 Activity 2.12 Recording AutoCorrect Entries

 Activity 2.13 Creating a Cover Letter

 Activity 2.14 Finding and Replacing Text

 Activity 2.15 Selecting and Moving Text to a New Location

 Activity 2.16 Indenting Text and Adding Space After Paragraphs

Objective 6 Use the Proofing Options

 Activity 2.17 Checking Spelling and Grammar Errors

 Activity 2.18 Using the Thesaurus

Objective 7 Create a Document Using a Template

 Activity 2.19 Locating and Opening a Template

 Activity 2.20 Replacing Template Placeholder Text

 Activity 2.21 Removing Template Controls and Formatting the Resume

 Activity 2.22 Saving a Resume as a Web Page

Summary, Key Terms, Matching, and Multiple Choice

 

Skills Review

Mastering Word

GO! Fix It

GO! Make It

GO! Solve It

Rubric

GO! Think

You and GO!

GO! Group Business Running Case

 

Chapter 3 Creating Research Papers,Newsletters, and Merged Mailing Labels

Project 3A Research Paper

Objective 1 Create a Research Paper

 Activity 3.01 Formatting Text and Page Numbers in a Research Paper

Objective 2 Insert Footnotes in a Research Paper

 Activity 3.02 Inserting Footnotes

 Activity 3.03 Modifying a Footnote Style

Objective 3 Create Citations and a Bibliography in a Research Paper

 Activity 3.04 Adding Citations

 Activity 3.05 Inserting Page Breaks

 Activity 3.06 Creating a Reference Page

 Activity 3.07 Managing File Properties

 

Project 3B Newsletter with Mailing Labels

Objective 4 Format a Multiple-Column Newsletter

 Activity 3.08 Changing One Column of Text to Two Columns

 Activity 3.09 Formatting Multiple Columns

 Activity 3.10 Inserting a Column Break

 Activity 3.11 Inserting a ClipArt Image

 Activity 3.12 Inserting a Screenshot

Objective 5 Use Special Character and Paragraph Formatting

 Activity 3.13 Applying the Small Caps Font Effect

 Activity 3.14 Adding a Border and Shading to a Paragraph

Objective 6 Create Mailing Labels Using Mail Merge

 Activity 3.15 Opening and Using the Mail Merge Manager

 Activity 3.16 Completing the Mail Merge

 Activity 3.17 Previewing, Sorting, and Printing the Mail Merge Document


Summary, Key Terms, Matching, and Multiple Choice

Skills Review

Mastering Word

GO! Fix It

GO! Make It

GO! Solve It

Rubric

GO! Think

You and GO!

GO! Group Business Running Case

 

Excel

Chapter 1 Creating a Worksheet and Charting Data

Project 1A Sales Report with Embedded Column Chart and Sparklines

Objective 1 Create, Save, and Navigate an Excel Workbook

 Activity 1.01 Starting Excel and Naming and Saving a Workbook

 Activity 1.02 Navigating a Worksheet and a Workbook

Objective 2 Enter Data in a Worksheet

 Activity 1.03 Entering Text and Using AutoComplete

 Activity 1.04 Using Auto Fill and Keyboard Shortcuts

 Activity 1.05 Aligning Text and Adjusting the Size of Columns

 Activity 1.06 Entering Numbers

Objective 3 Construct and Copy Formulas and Use the SUM Function

 Activity 1.07 Constructing a Formula and Using the SUM Function

 Activity 1.08 Copying a Formula by Using the Fill Handle

Objective 4 Format Cells with Merge and Cell Styles

 Activity 1.09 Using Merge and Applying Cell Styles

 Activity 1.10 Formatting Financial Numbers

Objective 5 Chart Data to Create a Column Chart and Insert Sparklines

 Activity 1.11 Charting Data in a Column Chart

 Activity 1.12 Creating and Formatting Sparklines

Objective 6 Print, Display Formulas, and Close Excel

 Activity 1.13 Creating a Footer, Changing Views, and Using Print Preview

 Activity 1.14 Printing a Worksheet

 Activity 1.15 Displaying, Printing, and Hiding Formulas

 

Project 1B Inventory Valuation

Objective 7 Check Spelling in a Worksheet

 Activity 1.16 Checking Spelling in a Worksheet

Objective 8 Enter Data by Range

 Activity 1.17 Entering Data by Range

Objective 9 Construct Formulas for Mathematical Operations

 Activity 1.18 Using Arithmetic Operators

 Activity 1.19 Copying Formulas Containing Absolute Cell References

Objective 10 Edit Values in a Worksheet

 Activity 1.20 Editing Values in a Worksheet

 Activity 1.21 Formatting Cells with the Percent Style

Objective 11 Format a Worksheet

 Activity 1.22 Inserting and Deleting Rows and Columns

 Activity 1.23 Adjusting Column Widths and Wrapping Text

 

Summary, Key Terms, Matching, and Multiple Choice

Skills Review

Mastering Excel

GO! Fix It

GO! Make It

GO! Solve It

Rubric

GO! Think

You and GO!

GO! Group Business Running Case

 

Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks

Project 2A Inventory Status Report

Objective 1 Use the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions

 Activity 2.01 Using the SUM and AVERAGE Functions

 Activity 2.02 Using the MEDIAN Function

 Activity 2.03 Using the MIN and MAX Functions

Objective 2 Move Data, Resolve Error Messages, and Rotate Text

 Activity 2.04 Moving Data and Resolving a ##### Error Message

 Activity 2.05 Rotating Text

Objective 3 Use COUNTIF and IF Functions and Apply Conditional Formatting

 Activity 2.06 Using the COUNTIF Function

 Activity 2.07 Using the IF Function

 Activity 2.08 Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars

 Activity 2.09 Using Find and Replace

Objective 4 Use Date and Time Functions and Freeze Panes

 Activity 2.10 Using the NOW Function to Display a System Date

 Activity 2.11 Freezing and Unfreezing Panes

Objective 5 Create, Sort, and Filter an Excel Table

 Activity 2.12 Creating an Excel Table

 Activity 2.13 Sorting and Filtering an Excel Table

 Activity 2.14 Converting a Table to a Range of Data

Objective 6 Format and Print a Large Worksheet

 Activity 2.15 Printing Titles and Scaling to Fit

 

Project 2B Weekly Sales Summary

Objective 7 Navigate a Workbook and Rename Worksheets

 Activity 2.16 Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of Worksheets

Objective 8 Enter Dates, Clear Contents, and Clear Formats

 Activity 2.17 Entering and Formatting Dates

 Activity 2.18 Clearing Cell Contents and Formats

Objective 9 Copy and Paste Cells

 Activity 2.19 Copying and Pasting Cells

Objective 10 Edit and Format Multiple Worksheets at the Same Time

 Activity 2.20 Grouping Worksheets for Editing

 Activity 2.21 Formatting and Constructing Formulas on Grouped Worksheets

Objective 11 Create a Summary Sheet with Column Sparklines

 Activity 2.22 Constructing Formulas that Refer to Cells in Another Worksheet

 Activity 2.23 Changing Values in a Detail Worksheet to Update a Summary Worksheet

 Activity 2.24 Inserting Sparklines

Objective 12 Format and Print Multiple Worksheets in a Workbook

 Activity 2.25 Moving and Formatting Worksheets in a Workbook

 Activity 2.26 Printing All the Worksheets in a Workbook

 

Summary, Key Terms, Matching, and Multiple Choice

Skills Review

Mastering Excel

GO! Fix It

GO! Make It

GO! Solve It

Rubric

GO! Think

You and GO!

GO! Group Business Running Case

 

Chapter 3 Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools

Project 3A Budget Pie Chart

Objective 1 Chart Data with a Pie Chart

 Activity 3.01 Creating a Pie Chart and a Chart Sheet

Objective 2 Format a Pie Chart

 Activity 3.02 Applying Percentages to Labels in a Pie Chart

 Activity 3.03 Formatting a Pie Chart with 3-D

 Activity 3.04 Rotating a Pie Chart

 Activity 3.05 Exploding and Coloring a Pie Slice

 Activity 3.06 Formatting the Chart Area

 Activity 3.07 Inserting WordArt in a Chart

Objective 3 Edit a Workbook and Update a Chart

 Activity 3.08 Editing a Workbook and Updating a Chart

 Activity 3.09 Inserting WordArt in a Worksheet

Objective 4 Use Goal Seek to Perform What-If Analysis

 Activity 3.10 Using Goal Seek to Perform What-If Analysis

 Activity 3.11 Preparing and Printing a Workbook with a Chart Sheet

 

Project 3B Growth Projection with Line Chart

Objective 5 Design a Worksheet for What-If Analysis

 Activity 3.12 Using Parentheses in a Formula to Calculate a Percentage Rate of Increase

 Activity 3.13 Using Format Painter and Formatting as You Type

 Activity 3.14 Calculating a Value After an Increase

Objective 6 Answer What-If Questions by Changing Values in a Worksheet

 Activity 3.15 Answering What-If Questions and Using Paste Special

Objective 7 Chart Data with a Line Chart

 Activity 3.16 Inserting Multiple Rows and Creating a Line Chart

 Activity 3.17 Formatting Axes in a Line Chart

 Activity 3.18 Formatting the Chart and Plot Areas

 Activity 3.19 Preparing and Printing Your Worksheet

Summary, Key Terms, Matching, and Multiple Choice

 

Skills Review

Mastering Excel

GO! Fix It 426

GO! Make It 427

GO! Solve It 428

Rubric 430

GO! Think 431

You and GO! 433

GO! Group Business Running Case 433

 

PowerPoint

Chapter 1 Getting Started with Microsoft Office PowerPoint

Project 1A Company Overview

Objective 1 Create a New Presentation

 Activity 1.01 Identifying Parts of the PowerPoint Window

 Activity 1.02 Entering Presentation Text and Saving a Presentation

 Activity 1.03 Applying a Presentation Theme

Objective 2 Edit a Presentation in Normal View

 Activity 1.04 Inserting a New Slide

 Activity 1.05 Increasing and Decreasing List Levels

 Activity 1.06 Adding Speaker’s Notes to a Presentation

 Activity 1.07 Displaying and Editing Slides in the Slide Pane

Objective 3 Add Pictures to a Presentation

 Activity 1.08 Inserting a Picture from a File

 Activity 1.09 Applying a Style to a Picture

 Activity 1.10 Applying and Removing Picture Artistic Filters

Objective 4 View and Print a Presentation

 Activity 1.11 Viewing a Slide Show

 Activity 1.12 Inserting Headers and Footers

 Activity 1.13 Printing a Presentation

 

Project 1B New Product Announcement

Objective 5 Edit an Existing Presentation

 Activity 1.14 Displaying and Editing the Presentation Outline

 Activity 1.15 Inserting Slides from an Existing Presentation

 Activity 1.16 Finding and Replacing Text

Objective 6 Format a Presentation

 Activity 1.17 Changing Fonts, Font Sizes, Font Styles, and Font Colors

 Activity 1.18 Aligning Text and Changing Line Spacing

 Activity 1.19 Modifying Slide Layout

Objective 7 Use Slide Sorter View

 Activity 1.20 Deleting Slides in Slide Sorter View

 Activity 1.21 Moving Slides in Slide Sorter View

Objective 8 Apply Slide Transitions

 Activity 1.22 Applying Slide Transitions to a Presentation

 

Summary, Key Terms, Matching, and Multiple Choice

Skills Review

Mastering PowerPoint GO! Fix It

GO! Make It

GO! Solve It

Rubric

GO! Think

You and GO!

GO! Group Business Running Case

 

Chapter 2 Formatting PowerPoint Presentations

Project 2A Employee Training Presentation

Objective 1 Format Numbered and Bulleted Lists

 Activity 2.01 Selecting Placeholder Text

 Activity 2.02 Changing a Bulleted List to a Numbered List

 Activity 2.03 Modifying a Bulleted List Style

 Activity 2.04 Removing a Bullet Symbol from a Bullet Point

Objective 2 Insert Clip Art

Activity 2.05 Inserting Clip Art

 Activity 2.06 Sizing and Aligning Images

 Activity 2.07 Changing the Shape of a Picture

Objective 3 Insert Text Boxes and Shapes

 Activity 2.08 Inserting a Text Box

 Activity 2.09 Inserting, Sizing, and Positioning Shapes

 Activity 2.10 Adding Text to Shapes

Objective 4 Format Objects

 Activity 2.11 Applying Shape Fills, Outlines, and Styles

 Activity 2.12 Applying Shape and Picture Effects

 Activity 2.13 Duplicating Objects

 Activity 2.14 Aligning and Distributing Objects

 

Project 2B Event Announcement

Objective 5 Remove Picture Backgrounds and Insert WordArt

 Activity 2.15 Removing the Background from a Picture and Applying Soft Edge Option

 Activity 2.16 Applying WordArt Styles to Existing Text

 Activity 2.17 Inserting a WordArt Object

Objective 6 Create and Format a SmartArt Graphic

 Activity 2.18 Creating a SmartArt Graphic from Bulleted Points

 Activity 2.19 Adding Shapes in a SmartArt Graphic

 Activity 2.20 Creating a SmartArt Graphic Using a Content Layout

 Activity 2.21 Changing the SmartArt Layout

 Activity 2.22 Changing the Color and Style of a SmartArt Graphic

 Activity 2.23 Changing the Shape of a SmartArt Graphic

 Activity 2.24 Converting a SmartArt to Text

 

Summary, Key Terms, Matching, and Multiple Choice

Skills Review

Mastering PowerPoint

GO! Fix It

GO! Make It GO! Solve It

Rubric

GO! Think

You and GO!

GO! Group Business Running Case

 

Chapter 3 Enhancing a Presentation with Animation, Movies, Tables, and Charts

Project 3A Informational Presentation

Objective 1 Customize Slide Backgrounds and Themes

 Activity 3.01 Changing the Theme Colors and Theme Fonts

 Activity 3.02 Applying a Background Style

 Activity 3.03 Hiding Background Graphics

 Activity 3.04 Formatting a Slide Background with a Picture

 Activity 3.05 Applying a Background Fill Color and Resetting a Slide Background

Objective 2 Animate a Slide Show

 Activity 3.06 Applying Animation Entrance Effects and Effect Options

 Activity 3.07 Setting Animation Timing Options

 Activity 3.08 Applying More Animation and Removing Animation

Objective 3 Insert a Movie

 Activity 3.09 Inserting a Movie

 Activity 3.10 Formatting a Movie

 

Project 3B Summary and Analysis Presentation

Objective 4 Create and Modify Tables

 Activity 3.11 Creating a Table

 Activity 3.12 Modifying the Layout of a Table

 Activity 3.13 Modifying a Table Design

Objective 5 Create and Modify Charts

 Activity 3.14 Creating a Column Chart and Applying a Chart Style

 Activity 3.15 Creating a Line Chart and Deleting Chart Data

 Activity 3.16 Animating a Chart

 

Summary, Key Terms, Matching, and Multiple Choice

Skills Review

Mastering PowerPoint

GO! Fix It

GO! Make It

GO! Solve It

Rubric

GO! Think

You and GO!

GO! Collaborate

 

Glossary

Index