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

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.