Exploring Microsoft Office XP Professional, Vol. 1

, by Grauer, Robert T.; Barber, Maryann T.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780130342652 | 0130342653
Cover: Paperback
Copyright: 1/1/2002

Buy New

Currently Available, Usually Ships in 24-48 Hours

$76.02

The most complete coverage of the Office XP curriculum available, so you can go beyond the basics, and get certified! When learning how to use Office XP just isn't enough... Exploring Office XP by Grauer and Barber teaches you "when" and "why" to perform tasks in XP! Grauer and Barber's text is a superior Office XP reference tool for you to use in class, on personal projects, or on the job! Hands-on exercises in each chapter! Step-by-step, in chapter reviews of the topics covered! New integrated exercises! Practice using multiple applications together! In-text boxes! Get tips on pitfalls and shortcuts to make using Office XP easier! www.prenhall.com/grauer Your on-line resource to Explore Microsoft® Office XP Use the interactive study guide Use the student data files Use the on-line exercises

Preface

Essentials of Microsoft® Windows®

Objectives

(1)

Overview

(1)

The Desktop

(3)

The Common User Interface

(5)

Moving and Sizing a Window

(1)

Pull-Down Menus

(1)

Dialog Boxes

(2)

The Mouse

(1)

The Mouse versus the Keyboard

(1)

The Help Command

(1)

Formatting a Floppy Disk

(2)

Hands-On Exercise 1: Welcome to Windows 2000

(7)

Files and Folders

(2)

My Computer

(1)

The Exploring Windows Practice Files

(2)

Hands-On Exercise 2: The Practice Files Via the Web

(9)

Windows Explorer

(3)

Expanding and Collapsing a Drive or Folder

(1)

Hands-On Exercise 3: The Practice Files Via a Local Area Network

(5)

The Basics of File Management

(2)

Moving and Copying a File 41 Deleting a File

(1)

Renaming a File 42 Backup 42 Write Protection

(1)

Our Next Exercise

(1)

Hands-On Exercise 4: File Management

(8)

Summary

(1)

Key Terms

(1)

Multiple Choice

(2)

Practice with Windows

(8)

On Your Own

Microsoft® Word 2002

Microsoft Word 2002: What Will Word Processing Do for Me?

(48)

Objectives

(1)

Overview

(1)

The Basics of Word Processing

(3)

The Insertion Point

(1)

Word Wrap

(1)

Toggle Switches

(1)

Insert versus Overtype

(1)

Deleting Text

(1)

Introduction to Microsoft Word

(3)

The File Menu

(1)

Learning by Doing

(1)

Hands-On Exercise 1: My First Document

(7)

Troubleshooting

(2)

Hands-On Exercise 2: Modifying an Existing Document

(5)

The Spell Check

(3)

AutoCorrect and AutoText

(1)

Thesaurus

(1)

Grammar Check

(2)

Save Command

(2)

Backup Options

(2)

Hands-on Exercise 3: The Spell Check, Thesaurus, and Grammar Check

(7)

Summary

(1)

Key Terms

(1)

Multiple Choice

(2)

Practice with Word

(5)

On Your Own

(2)

Gaining Proficiency: Editing and Formatting

(54)

Objectives

(1)

Overview

(1)

Select-Then-Do

(1)

Moving and Copying Text

(1)

Find, Replace, and Go To Commands

(2)

Scrolling

(2)

View Menu

(1)

Hands-on Exercise 1: Editing a Document

(8)

Typography

(3)

Type Size

(1)

Format Font Command

(2)

Page Setup Command

(2)

Page Breaks

(1)

An Exercise in Design

(1)

Hands-on Exercise 2: Character Formatting

(7)

Paragraph Formatting

(4)

Alignment

(1)

Indents

(3)

Tabs

(1)

Hyphenation

(1)

Line Spacing

(1)

Formatting Paragraph Command

(3)

Borders and Shading

(1)

Column Formatting

(1)

Hands-on Exercise 3: Paragraph Formatting

(7)

Summary

(1)

Key Terms

(1)

Multiple Choice

(2)

Practice with Word

(6)

On Your Own

101

(2)

Enhancing a Document: The Web and Other Resources

103

(50)

Objectives

103

(1)

Overview

103

(1)

Enhancing a Document

104

(4)

The Media Gallery

105

(1)

The Insert Symbol Command

106

(1)

Microsoft WordArt

107

(1)

The Drawing Toolbar

108

(1)

Hands-on Exercise 1: Clip Art and Wordart

109

(7)

Microsoft Word and the Internet

116

(2)

117

(1)

Hands-on Exercise 2: Microsoft Word and the Web

118

(9)

Wizards and Templates

127

(3)

Mail Merge

130

(3)

Hands-on Exercise 3: Mail Merge

133

(9)

Summary

142

(1)

Key Terms

142

(1)

Multiple Choice

143

(2)

Practice with Word

145

(7)

On Your Own

152

(1)

Advanced Features: Outlines, Tables, Styles, and Selections

153

(1)

Objectives

153

(1)

Overview

153

(1)

Bullets and List

154

(1)

Creating an Outline

154

(2)

Hands-on Exercise 1: Bullets, Lists, and Outlines

156

(6)

Tables

162

(2)

Hands-on Exercise 2: Tables

164

(7)

Styles

171

(2)

The Outline View

173

(2)

The AutoFormat Command

174

(1)

Hands-on Exercise 3: Styles

175

(8)

Working in Long Documents

183

(4)

Page Numbers

183

(1)

Headers and Footers

183

(1)

Sections

184

(1)

Table of Contents

184

(1)

Creating an Index

185

(1)

The Go to Command

185

(2)

Hands-on Exercise 4: Working in Long Documents

187

(11)

Summary

198

(1)

Key Terms

198

(1)

Multiple Choice

199

(2)

Practice with Word

201

(6)

On Your Own

207

Microsoft® Excel 2002

Introduction to Microsoft Excel: What Is a Spreadsheet?

(64)

Objectives

(1)

Overview

(1)

Introduction to Spreadsheets

(4)

The Professor's Grade Book

(1)

Row and Column Headings

(1)

Formulas and Constants

(1)

Introduction to Microsoft Excel

(3)

Toolbars

(2)

The File Menu

(2)

Hands-on Exercise 1: Introduction to Microsoft Excel

(8)

Modifying the Worksheet

(2)

The Page Setup Command

(1)

Hands-on Exercise 2: Modifying the Worksheet

(9)

A Better Grade Book

(1)

Cell Range

(1)

Copy Command

(2)

Move Operation

(1)

Learning by Doing

(1)

Hands-on Exercise 3: Creating a Workbook

(6)

Formatting

(1)

Format Cells Command

(4)

Alignment

(1)

Fonts

(2)

Borders, Patterns, and Shading

(1)

Hands-on Exercise 4: Formatting a Worksheet

(6)

Summary

(1)

Key Terms

(1)

Multiple Choice

(2)

Practice with Excel

(7)

On Your Own

(2)

Gaining Proficiency: The Web and Business Applications

(44)

Objectives

(1)

Overview

(1)

Employee Payroll

(3)

Pointing

(1)

The Fill Handle

(1)

Comments

(1)

Hands-on Exercise 1: Payroll

(7)

Excel and the Internet

(2)

Hands-on Exercise 2: Creating a Web Page

(9)

Web Queries

(2)

Hands-on Exercise 3: Web Queries

(6)

Summary

(1)

Key Terms

(1)

Multiple Choice

(2)

Practice with Excel

(10)

On Your Own

108

(1)

Spreadsheets in Decision Making: What If?

109

(58)

Objectives

109

(1)

Overview

109

(1)

Analysis of a Car Loan

110

(5)

PMT Function

112

(1)

FV Function

112

(1)

Inserting a Function

113

(1)

The Goal Seek Command

114

(1)

Hands-on Exercise 1: Basic Financial Functions

115

(6)

Home Mortgages

121

(3)

Relative versus Absolute Address

122

(1)

Mixed References

123

(1)

Hands-on Exercise 2: Advanced Financial Functions

124

(10)

The Grade Book Revisited

134

(5)

Statistical Functions

135

(1)

Arithmetic Expressions versus Functions

136

(1)

IF Function

137

(1)

VLOOKUP Function

138

(1)

Working with Large Spreadsheets

139

(4)

Freezing Panes

139

(1)

Hiding Rows and Columns

139

(1)

Printing a Large Worksheet

139

(3)

AutoFilter Command

142

(1)

Hands-on Exercise 3: The Expanded Grade Book

143

(10)

Summary

153

(1)

Key Terms

153

(1)

Multiple Choice

154

(2)

Practice with Excel

156

(9)

On Your Own

165

(2)

Graphs and Charts: Delivering a Message

167

(1)

Objectives

167

(1)

Overview

167

(1)

Chart Types

168

(6)

Pie Charts

169

(2)

Column and Bar Charts

171

(3)

Creating a Chart

174

(5)

The Chart Wizard

176

(2)

Modifying a Chart

178

(1)

Hands-on Exercise 1: The Chart Wizard

179

(9)

Multiple Data Series

188

(3)

Hands-on Exercise 2: Multiple Data Series

191

(6)

Object Linking and Embedding

197

(1)

Hands-on Exercise 3: Object Linking and Embedding

198

(7)

Summary

205

(1)

Key Terms

205

(1)

Multiple Choice

206

(2)

Practice with Excel

208

(8)

On Your Own

216

Microsoft® Access 2002

Introduction to Microsoft Access: What is a Database?

(48)

Objectives

(1)

Overview

(1)

Case Study: The College Bookstore

(1)

Introduction to Microsoft Access

(4)

The Database Window

(1)

Tables

(1)

Forms, Queries, and Reports

(2)

Hands-on Exercise 1: Introduction to Access

(12)

Filters and Sorting

(2)

Pivot Tables and Pivot Charts

(2)

Hands-on Exercise 2: Filters, Sorting, Pivot Tables, and Pivot Charts

(7)

Looking Ahead: a Relational Database

(2)

Hands-on Exercise 3: A Look Ahead

(7)

Summary

(1)

Key Terms

(1)

Multiple Choice

(2)

Practice with Access

(6)

On Your Own

(1)

Tables and Forms: Designs, Properties, Views, and Wizards

(52)

Objectives

(1)

Overview

(1)

Case Study: A Student Database

(3)

Include Necessary Data

(1)

Store Data in Its Smallest Parts

(1)

Avoid Calculated Fields

(1)

Creating a Table

(3)

Primary Key

(1)

Views

(1)

Properties

(1)

Hands-on Exercise 1: Creating a Table

(9)

Forms

(5)

Properties

(2)

AutoForms and the Form Wizard

(1)

Modifying a Form

(2)

Hands-on Exercise 2: Creating a Form

(8)

A More Sophisticated Form

(1)

Hands-on Exercise 3: A More Sophisticated From

(9)

Summary

(1)

Key Terms

(1)

Multiple Choice

(2)

Practice with Access

(8)

On Your Own

(2)

Information from the Database: Reports and Queries

101

(56)

Objectives

101

(1)

Overview

101

(1)

Reports

102

(5)

Anatomy of a Report

104

(1)

The Report Wizard

104

(1)

Apply What You Know

104

(3)

Hands-on Exercise 1: The Report Wizard

107

(8)

Introduction to Queries

115

(5)

Query Window

116

(2)

Selection Criteria

118

(2)

Hands-on Exercise 2: Creating a Selection Query

120

(6)

Grouping Records

126

(2)

Hands-on Exercise 3: Grouping Records

128

(10)

Crosstab Queries

138

(1)

Actions Queries

138

(1)

Hands-on Exercise 4: Crosstab and Action Queries

139

(8)

Summary

147

(1)

Key Terms

147

(1)

Multiple Choice

148

(2)

Practice with Access

150

(6)

On Your Own

156

(1)

Proficiency: Relational Databases, External Data, Charts, and the Switchboard

157

(1)

Objectives

157

(1)

Overview

157

(1)

The Investment Database

158

(3)

Multiple-Table Queries

159

(1)

Maintaining the Database

160

(1)

The Import Spreadsheet Wizard

161

(1)

Hands-on Exercise 1: Importing and Exporting Access Objects

162

(9)

Total Queries

171

(3)

Microsoft Graph

171

(3)

Hands-on Exercise 2: Total Queries and Charts

174

(7)

The User Interface

181

(3)

The Switchboard Manager

183

(1)

Other Access Utilities

183

(1)

Hands-on Exercise 3: The Switchboard Manager

184

(7)

Summary

191

(1)

Key Terms

191

(1)

Multiple Choice

192

(2)

Practice with Access

194

(6)

On Your Own

200

Microsoft® PowerPoint® 2002

Introduction to PowerPoint: Presentations Made Easy

(64)

Objectives

(1)

Overview

(1)

A PowerPoint Presentation

(2)

Introduction to PowerPoint

(5)

PowerPoint Views

(2)

The File Menu

(2)

Hands-on Exercise 1: Introduction to PowerPoint

(9)

Creating a Presentation

(3)

Slide Layouts

(1)

Templates

(1)

Hands-on Exercise 2: Creating a Presentation

(8)

Creating a Slide Show

(2)

Delivering the Presentation

(2)

Hands-on Exercise 3: Animating the Presentation

(6)

Enhancing a Presentation

(3)

Office Art

(1)

Microsoft WordArt

(1)

Hands-on Exercise 4: Enhancing a Presentation

(11)

Summary

(1)

Key Terms

(1)

Multiple Choice

(2)

Practice with PowerPoint

(9)

On Your Own

(1)

Gaining Proficiency: Slide Show Tools, the Web, and Slide Masters

(1)

Objectives

(1)

Overview

(1)

Slide Show Tools

(2)

Reviewing a Presentation

(1)

Hands-on Exercise 1: Slide Show Tools

(10)

PowerPoint and the Internet

(1)

(2)

Hands-on Exercise 2: The Internet as a Resource

(8)

Presentations on the Web

(1)

Uploading a Presentation

(1)

The AutoContent Wizard

(3)

Hands-on Exercise 3: Presentations on the Web

(7)

Fine-Tuning a Presentation

101

(1)

The Color Scheme

101

(1)

Background Shading

102

(1)

PowerPoint Masters

103

(1)

Hands-on Exercise 4: Fine-Tuning a Presentation

104

(6)

Summary

110

(1)

Key Terms

110

(1)

Multiple Choice

111

(2)

Exploring PowerPoint

113

(7)

On Your Own

120

The Internet and World Wide Web: Welcome to Cyberspace

Objectives

Overview

(1)

The Internet

(1)

The World Wide Web

(4)

The Uniform Resource Locator (URL)

(1)

Connecting to the Internet

(1)

Learning by Doing

(1)

Hands-on Exercise 1: Introduction to the World Wide Web

(7)

Search Engines

(3)

Logical (Boolean) Operators

(1)

Explore the URL

(1)

Hands-on Exercise 2: Searching the Web

(7)

The Commercialization of Cyberspace

(1)

Security

(1)

Privacy

(2)

Returning to a Previous Site

(1)

Our Next Exercise

(1)

Hands-on Exercise 3: Shopping in Cyberspace

(8)

Introduction to HTML

(2)

Microsoft Word

(1)

Hands-on Exercise 4: Introduction to HTML

(8)

Summary

(1)

Key Terms

(1)

Multiple Choice

(2)

Practice with the Internet

(8)

On Your Own

Getting Started: Essential Computing Concepts

Objectives

(1)

Overview

(1)

What Is a Computer?

(2)

From Micro to Mainframe

(1)

Bits and Bytes

(1)

Inside the PC

(2)

The Microprocessor

(1)

Memory

(1)

Auxiliary Storage

(2)

Input Devices

(2)

The Monitor

(2)

The Printer

(2)

A PC Buying Guide

(2)

The Rise of the Personal Computer

(1)

Software

(3)

Antivirus Software

(1)

Backup

(1)

Application Software

(1)

Microsoft Office

(3)

Local Area Networks

(2)

The Internet and World Wide Web

(2)

The Commercialization of Cyberspace

(1)

Connecting to the Internet

(1)

File Compression

(2)

TCP/IP---How the Internet Works

(2)

Introduction to E-mail

(1)

An Internet Address

(2)

Anatomy of an E-mail Message

(1)

The Address Book

(1)

Summary

(1)

Key Terms

(1)

Multiple Choice

(2)

On Your Own

Glossary

Index

Please wait while the item is added to your bag...

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Exploring Microsoft Office XP Professional, Vol. 1

Summary

Table of Contents

Supplemental Materials

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Exploring Microsoft Office XP Professional, Vol. 1

Summary

Table of Contents

Supplemental Materials

Digital License