For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications.
The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill. The Exploring series for Office 2010 also enables students to extend the learning beyond the classroom.
Students go to college now with a different set of skills than they did five years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know. A lot of learning takes place outside of the classroom, and the Exploring series provides learning tools that students can access anytime, anywhere.
The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill.
Table of Contents:
GLOSSARY
OFFICE FUNDAMENTALS AND FILE MANAGEMENT
CHAPTER ONE ¿ Office Fundamentals and File Management
CASE STUDY: RAILS AND TRAILS
OBJECTIVES
FILES AND FOLDERS
Using Windows Explorer
Working with Folders and Files
Selecting, Copying, and Moving Multiple Files and Folders
HANDS-ON EXERCISE 1: Files and Folders
MICROSOFT OFFICE SOFTWARE
Identifying Common Interface Components
Getting Office Help
HANDS-ON EXERCISE 2: Microsoft Office Software
BACKSTAGE VIEW TASKS
Opening a File
Printing a File
Closing a File and Application
HANDS-ON EXERCISE 3: Backstage View Tasks
HOME TAB TASKS
Selecting and Editing Text
Using the Clipboard Group Tasks
Using the Editing Group Tasks
HANDS-ON EXERCISE 4: Home Tab Tasks
INSERT TAB TASKS
Inserting Objects
REVIEW TAB TASKS
Reviewing a File
PAGE LAYOUT TAB TASKS
Changing Page Settings
HANDS-ON EXERCISE 5: Tasks on the Insert Tab, Page Layout Tab, and Review Tab
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
MICROSOFT OFFICE EXCEL 2010
CHAPTER ONE ¿ Introduction to Excel
CASE STUDY: OK OFFICE SYSTEMS
OBJECTIVES
INTRODUCTION TO SPREADSHEETS
Planning for Effective Workbook and Worksheet Design
Exploring the Excel Window
Entering and Editing Cell Data
HANDS-ON EXERCISE 1: Introduction to Spreadsheets
MATHEMATICS AND FORMULAS
Using Symbols and the Order of Precedence
Using Auto Fill
Displaying Cell Formulas
HANDS-ON EXERCISE 2: Mathematics and Formulas
WORKBOOK AND WORKSHEET MANAGEMENT
Managing Worksheets
Managing Columns and Rows
Selecting, Moving, Copying, and Pasting
HANDS-ON EXERCISE 3: Workbook and Worksheet Management
FORMATTING
Applying Alignment and Font Options
Applying Number Formats
HANDS-ON EXERCISE 4: Formatting
PAGE SETUP AND PRINTING
Selecting Page Setup Options
Printing a Worksheet
HANDS-ON EXERCISE 5: Page Setup and Printing
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
CHAPTER TWO ¿ Formulas and Functions
CASE STUDY: DENVER MORTGAGE COMPANY
OBJECTIVES
FORMULA BASICS
Using Semi-Selection to Create a Formula
Using Relative, Absolute, and Mixed Cell References in Formulas
Avoiding Circular References
HANDS-ON EXERCISE 1: Formula Basics
FUNCTION BASICS
Inserting a Function
Totaling Values with the SUM Function
Inserting Basic Statistical Functions
Using Date Functions
HANDS-ON EXERCISE 2: Function Basics
LOGICAL, LOOKUP, AND FINANCIAL FUNCTIONS
Determining Results with the IF Function
Using Lookup Functions
Calculating Payments with the PMT Function
HANDS-ON EXERCISE 3: Logical, Lookup, and Financial Functions
RANGE NAMES
Creating and Maintaining Range Names
Using Range Names in Formulas
HANDS-ON EXERCISE 4: Range Names
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
CHAPTER THREE ¿ Charts
CASE STUDY: HORT UNIVERSITY MAJORS
OBJECTIVES
CHART BASICS
Deciding Which Chart Type to Create
Creating a Chart
HANDS-ON EXERCISE 1: Chart Basics
CHART DESIGN
Changing the Chart Type
Changing the Data Source and Structure
Applying a Chart Layout and a Chart Style
Moving a Chart
Printing Charts
Inserting and Customizing a Sparkline
HANDS-ON EXERCISE 2: Chart Design
CHART LAYOUT
Selecting and Formatting Chart Elements
Customizing Chart Labels
Formatting the Axes and Gridlines
Adding a Trendline
HANDS-ON EXERCISE 3: Chart Layout
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
CHAPTER FOUR ¿ Datasets and Tables
CASE STUDY: THE SPA EXPERTS
OBJECTIVES
LARGE DATASETS
Freezing Rows and Columns
Printing Large Datasets
HANDS-ON EXERCISE 1: Large Datasets
EXCEL TABLES
Understanding Table Design
Creating a Table
Applying a Table Style
HANDS-ON EXERCISE 2: Excel Tables
TABLE MANIPULATION AND AGGREGATION
Sorting Data
Filtering Data
Using Structured References and a Total Row
HANDS-ON EXERCISE 3: Table Manipulation and Aggregation
CONDITIONAL FORMATTING
Applying Conditional Formatting
Creating a New Rule
Sorting and Filtering Using Conditional Formatting
HANDS-ON EXERCISE 3: Conditional Formatting
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
CHAPTER FIVE ¿ Subtotals, PivotTables, and PivotCharts
CASE STUDY: IVORY HALLS PUBLISHING COMPANY
OBJECTIVES
OUTLINES AND SUBTOTALS
Grouping and Ungrouping Data
Subtotaling Data
HANDS-ON EXERCISE 1: Outlines and Subtotals
PIVOTTABLE BASICS
Creating a PivotTable
Changing the Values Field
Modifying a PivotTable
HANDS-ON EXERCISE 2: PivotTable Basics
PIVOTTABLE OPTIONS
Sorting, Filtering, and Slicing a PivotTable
Creating a Calculated Field
HANDS-ON EXERCISE 3: PivotTable Options
PIVOTTABLE DESIGN AND PIVOTCHARTS
Formatting a PivotTable
Creating a PivotChart
HANDS-ON EXERCISE 4: PivotTable Design and PivotCharts
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
CHAPTER SIX ¿ What-If Analysis
CASE STUDY: PERSONAL FINANCE: BUYING A CAR
OBJECTIVES
ONE- AND TWO-VARIABLE DATA TABLES
Creating a One-Variable Data Table
Creating a Two-Variable Data Table
HANDS-ON EXERCISE 1: One- and Two-Variable Data Tables
GOAL SEEK AND SCENARIO MANAGER
Identifying an Input Value with Goal Seek
Using Scenario Manager
Generating Scenario Summary Reports
HANDS-ON EXERCISE 2: Goal Seek and Scenario Manager
SOLVER
Loading the Solver Add-In
Optimizing Results with Solver
HANDS-ON EXERCISE 3: Solver
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
CHAPTER SEVEN ¿ Specialized Functions
CASE STUDY: STANWORTH, INC.
OBJECTIVES
MATH AND STATISTICAL FUNCTIONS
Using Conditional Math and Statistical Functions
Calculating Relative Standing with Statistical Functions
HANDS-ON EXERCISE 1: Math and Statistical Functions
LOGICAL AND LOOKUP FUNCTIONS
Creating a Nested Logical Function
Using MATCH and INDEX Lookup Functions
HANDS-ON EXERCISE 2: Logical and Lookup Functions
DATABASE FILTERING AND FUNCTIONS
Using Advanced Filtering
Manipulating Data with Database Functions
HANDS-ON EXERCISE 3: Database Filtering and Functions
FINANCIAL FUNCTIONS
Creating a Loan Amortization Table
Performing Other Financial Calculations
HANDS-ON EXERCISE 4: Financial Functions
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
CHAPTER EIGHT ¿ Multiple-Sheet Workbook Management
CASE STUDY: HEARTLAND DEPARTMENT STORE
OBJECTIVES
MULTIPLE WORKSHEETS
Working with Grouped Worksheets
Managing Windows and Workspaces
Inserting Hyperlinks
HANDS-ON EXERCISE 1: Multiple Worksheets
3-D FORMULAS AND LINKED WORKBOOKS
Inserting a 3-D Formula
Linking Workbooks
HANDS-ON EXERCISE 2: 3-D Formulas and Linked Workbooks
FORMULA AUDITS AND DATA VALIDATION
Auditing Formulas
Setting Up a Watch Window
Validating Data
HANDS-ON EXERCISE 3: Formula Audits and Data Validation
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
CHAPTER NINE ¿ Imports, Web Queries, and XML
CASE STUDY: STOCK ANALYSIS
OBJECTIVES
EXTERNAL DATA
Importing Data from External Sources
Creating a Web Query
Managing Connections
HANDS-ON EXERCISE 1: External Data
TEXT MANIPULATION
Converting Text to Columns
Manipulating Text with Functions
HANDS-ON EXERCISE 2: Text Manipulation
XML
Understanding XML Syntax
Importing XML Data into Excel
HANDS-ON EXERCISE 3: XML
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
CHAPTER TEN ¿ Collaboration and Workbook Distribution
CASE STUDY: CULINARY ARTS SCHOLARSHIP DINNER
OBJECTIVES
CUSTOMIZATION AND PERSONALIZATION
Customizing Excel
Changing Properties
HANDS-ON EXERCISE 1: Customization and Personalization
COLLABORATION
Sharing and Merging Workbooks
Inserting Comments
Tracking Changes
HANDS-ON EXERCISE 2: Collaboration
WORKBOOK INFORMATION
Checking for Issues
Protecting a Workbook
HANDS-ON EXERCISE 3: Workbook Information
WORKBOOK DISTRIBUTION
Saving a Workbook in Different Formats
Sending a Workbook to Others
HANDS-ON EXERCISE 3: Workbook Distribution
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
CHAPTER ELEVEN ¿ Templates, Styles, and Macros
CASE STUDY: PERSONAL FINANCIAL CONSULTANT
OBJECTIVES
TEMPLATES, THEMES, AND STYLES
Selecting a Template
Applying Themes and Backgrounds
Applying Cell Styles
HANDS-ON EXERCISE 1: Templates, Themes, and Styles
CUSTOM TEMPLATES AND WORKBOOK PROTECTION
Creating and Using a Template
Protecting a Cell, a Worksheet, and a Workbook
HANDS-ON EXERCISE 2: Custom Templates and Workbook Protection
MACROS
Creating a Macro
Creating Macro Buttons
Setting Macro Security
HANDS-ON EXERCISE 3: Macros
CHAPTER OBJECTIVES REVIEW
KEY TERMS
MULTIPLE CHOICE
PRACTICE EXERCISES
MID-LEVEL EXERCISES
CAPSTONE EXERCISE
BEYOND THE CLASSROOM
INDEX
About the Author :
Dr. Robert T. Grauer, Creator of the Exploring Series
Bob Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he is a multiple winner of the Outstanding Teaching Award in the School of Business, most recently in 2009. He has written numerous COBOL texts and is the vision behind the Exploring Office series, with more than three million books in print. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. Bob Grauer has consulted for several major corporations including IBM and American Express. He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.
Dr. Keith Mulbery, Consulting Series Editor and Excel Author
Dr. Keith Mulbery is the Department Chair and an Associate Professor in the Information Systems and
Technology Department at Utah Valley University (UVU), where he teaches computer applications, C#
programming, systems analysis and design, and MIS classes. Keith also served as Interim Associate Dean,
School of Computing, in the College of Technology and Computing at UVU.
Keith received the Utah Valley State College Board of Trustees Award of Excellence in 2001, School of
Technology and Computing Scholar Award in 2007, and School of Technology and Computing Teaching
Award in 2008. He has authored more than 15 textbooks, served as Series Editor for the Exploring Office
2007 series, and served as developmental editor on two textbooks.
Keith received his B.S. and M.Ed. in Business Education from Southwestern Oklahoma State University
and earned his Ph.D. in Education with an emphasis in Business Information Systems at Utah State
University. His dissertation topic was computer-assisted instruction using Prentice Hall’s Train and Assess IT program to supplement traditional instruction in basic computer proficiency courses.
Mary Anne Poatsy, Series Editor
Mary Anne is a senior faculty member at Montgomery County Community College, teaching various
computer application and concepts courses in face-to-face and online environments. She holds a B.A.
in psychology and education from Mount Holyoke College and an M.B.A. in finance from Northwestern
University’s Kellogg Graduate School of Management.
Mary Anne has more than 12 years of educational experience. She is currently adjunct faculty at
Gwynedd-Mercy College and Montgomery County Community College. She has also taught at Bucks
County Community College and Muhlenberg College, as well as conducted professional training. Before
teaching, she was vice president at Shearson Lehman in the Municipal Bond Investment Banking
Department.
Dr. Lynn Hogan, Office Fundamentals and File Management and
Windows 7 Author
Lynn Hogan has taught in the Computer Information Systems area at Calhoun Community College for
29 years. She is the author of Practical Computing and has contributed chapters for several computer
applications textbooks. Primarily teaching in the areas of computer literacy and computer applications,
she was named Calhoun’s outstanding instructor in 2006. She received an M.B.A. from the University of
North Alabama and a Ph.D. from the University of Alabama. Lynn resides in Alabama with her husband
and two daughters.
