Exploring Microsoft Office 2010, Volume 1

Dr. Robert T. Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he has been honored with the Outstanding Teacher Award in the School of Business.¿ He is the vision behind the Exploring Series, which is about to sell its 3 millionth copy. ¿ Dr. Grauer has written more than 50 books on programming and information systems.¿ His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. ¿ Dr. Grauer also has been a consultant to several major corporations including IBM and American Express.¿ He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn. ¿¿ Mary Anne Poatsy, MBA, CFP, is an adjunct faculty member at Montgomery County Community College, teaching various computer application and concepts courses in face-to-face and online environments. Mary Anne holds a B.A. in Psychology and Elementary Education from Mount Holyoke College and an MBA in Finance from Northwestern University’s Kellogg Graduate School of Management. Mary Anne has more than nine years of educational experience, ranging from elementary and secondary education to Montgomery County Community College, Muhlenberg College, and Bucks County Community College, as well as training in the professional environment. Prior to teaching, Mary Anne was a vice president at Shearson Lehman Hutton in the Municipal Bond Investment Banking department. ¿ She is a co-author on Technology in Action as well as Better Business. ¿ Lynn Hogan has taught computer literacy and microcomputer applications classes at Calhoun Community College for 25 years.¿ For the past 18 years, she has served as chair of the Department of Computer Information Systems.¿ She received Calhoun’s outstanding instructor award in 2006, and currently teaches computer literacy for senior adults and web design courses.¿ Having developed the first online computer course at Calhoun, she continues to work with the distance education program.¿ She received an M.B.A. from the University of North Alabama and a Ph.D. from the University of Alabama. ¿ She resides in Alabama with her husband and two daughters.¿ Much of her free time is spent traveling to cutting horse shows and dressage shows, watching her daughters compete.¿ In addition to working with horses, she enjoys cooking, reading, and family travel ¿ Michelle Hulett received a B.S. degree in CIS from the University of Arkansas and a M.B.A. from Missouri State University.¿ She has worked for various organizations as a programmer, network administrator, computer literacy coordinator, and educator.¿ She currently teaches computer literacy and Web design classes at Missouri State University. ¿ When not teaching or writing, she enjoys flower gardening, traveling (Alaska and Hawaii are favorites), hiking, canoeing, and camping with her husband, John, and dog, Dakota. ¿ Cynthia Krebs is a professor in the Digital Media Department at Utah Valley State College, where she has taught since 1988.¿ In addition to teaching classes in basic computer proficiency using Microsoft Office, she teaches classes in business presentations, business graphics, and an introduction to multimedia.¿ She has received the Teacher-of-the-Year Award in the School of Business twice during her tenure at UVSC. ¿ She has written chapters for many texts, co-authored a text on advanced word processing, and has presented locally and nationally.¿ A graduate of Utah State University, Cynthia lives in Springville, Utah. ¿ She has four children and one granddaughter.¿ When she isn’t teaching or writing, she enjoys spending time with her children and spoiling her granddaughter. ¿ Kendall E. Martin, Ph.D.,¿ has been teaching since 1988 at a number of institutions, including Villanova University, DeSales University, Arcadia University, Ursinus College, County College of Morris, and Montgomery County Community College, at both the undergraduate and master’s degree level. Kendall’s education includes a B.S. in Electrical Engineering from the University of Rochester and an M.S. and Ph.D. in Engineering from the University of Pennsylvania. She has industrial experience in research and development environments (AT&T Bell Laboratories) as well as experience from several start-up technology firms. At Ursinus College, Kendall developed a successful faculty training program for distance education instructors, and she makes conference presentations during the year. She is a co-author on Technology in Action as well as Better Business. ¿ Keith A. Mast develops a wide range of Access applications that solve challenging business problems and improve efficiency. His solutions help businesses and organizations in manufacturing, pharmaceutical, financial services, and agriculture, among other industries. Clients include Visible Filing Concepts, Inc.; Moyer’s Chicks, Inc.; Marcho Farms, Inc.; TCM America, Inc.; LANsultants, Inc.; Spector, Roseman, Kodroff, & Willis, PC; Heinz, Inc.; DuPont; and Sony Entertainment. He is an adjunct faculty member at Montgomery County Community College, Blue Bell, Pennsylvania, continuing his long-standing love of teaching and exemplified by his prior experience as a high school teacher, business school instructor, and Access seminar leader.¿ Keith promotes the ethical standards of the consulting profession both in how Mast Consulting, LLC deals with its clients and as an active volunteer leader of the Independent Computer Consultants Association of the Delaware Valley. ¿ Keith resides in Norristown, PA, a suburb of Philadelphia. In his free time, he enjoys biking, running, kayaking, ballroom dancing, and being in nature. For more information, visit him on Facebook, LinkedIn, or at www.keithmast.com. ¿ Dr. Keith Mulbery is an Associate Professor in the Information Systems and Technology Department at Utah Valley State College, where he teaches computer applications, programming, and MIS classes.¿ He has written more than 15 software textbooks and business communication test banks.¿ In January 2001, he received the Utah Valley State College Board of Trustees Award of Excellence for authoring MOUS Essentials Word 2000.¿ In addition to his series editor and authoring experience, he also served as a developmental editor on two word processing textbooks. ¿ He received his B.S. and M.Ed. (majoring 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 in 2006.¿ His dissertation topic was computer-assisted instructions using TAIT to supplement traditional instruction in basic computer proficiency courses.

Contents Windows 7 Chapter One ¤ Getting Started with Windows 7  Case Study: Cedar Cove Elementary School  Objectives  Windows 7 Fundamentals  Understanding the Desktop  Managing Windows  HANDS-ON EXERCI SE 1: Windows 7 Fundamentals  Windows Programs and Security Features  Identifying Windows Accessories  Working with Security Settings and Software  HANDS-ON EXERCI SE 2: Windows Programs and Security Features  WINDOWS SEARCH AND HELP Performing a Search  Getting Help  HANDS-ON EXERCI SE 3: Windows Search and Help  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  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 Excercise 1: Files and Folders  Microsoft Office Software  Identifying Common Interface Components  Getting Office Help  Hands-On Excercise 2: Microsoft Office Software  Backstage View Tasks  Opening a File  Printing a File  Closing a File and Application  Hands-On Excercise 3: Backstage View Tasks  Home Tab Tasks  Selecting and Editing Text  Using the Clipboard Group Tasks  Using the Editing Group Tasks  Hands-On Excercise 4: Home Tab Tasks  Insert Tab Tasks  Inserting Objects  Review Tab Tasks  Reviewing a File  Page Layout Tab Tasks  Changing Page Settings  Hands-On Excercise 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 Word 2010 Chapter One ¤ Introduction to Word  Case Study: First River Outfitter  Objectives  Introduction To Word Processing  Understanding How Word Processors Work  Customizing Word  Hands-On Excercise 1: Introduction to Word Processing  Document Organization  Using Features That Improve Readability  Checking Spelling and Grammar  Displaying a Document in Different Views  Hands-On Excercise 2: Document Organization  Finalize A Document  Preparing a Document for Distribution  Modifying Document Properties  Hands-On Excercise 3: Finalize a Document  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  Chapter Two ¤ Document Presentation  Case Study: Simserv-Pitka Enterprises  Objectives  Text Formatting Features  Applying Font Attributes Through the Font Dialog Box  Controlling Word Wrap  HAN DS-ON EXERCI SE 1: Text Formatting Features  Paragraph Formatting Features  Setting Off Paragraphs with Tabs, Borders, Lists, and Columns  Applying Paragraph Formats  HAN DS-ON EXERCI SE 2: Paragraph Formatting Features  Styles  Understanding Styles  Creating and Modifying Styles  HAN DS-ON EXERCI SE 3: Styles  Graphical Objects  Formatting a Graphical Object  Inserting Symbols into a Document  Hands-On Excercise 4: Graphical Objects  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  Chapter Three ¤ Collaboration and Research  Case Study: Marketing Plan For Take Note Paperie  Objectives  Document Revisions  Inserting Comments in a Document  Tracking Changes in a Document  Hands-On Excercise 1: Document Revisions  Research Paper Basics  Acknowledging a Source  Creating and Modifying Footnotes and Endnotes  Hands-On Excercise 2: Research Paper Basics  Research Paper Enhancements  Inserting a Table of Contents and Index  Adding Other Reference Tables  Creating Cross-References  HAN DS-ON EXERCI SE 3: Research Paper Enhancements  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  Chapter Four ¤ Document Productivity  Case Study: Community Disaster Relief Center  Objectives  TABLES Inserting a Table  Formatting a Table  Hands-On Exercise 1: Tables  Advanced Table Features  Sorting and Applying Formulas to Table Data  Converting Text to a Table  HANDS-ON EXERCISE 2: Advanced Table Features  Mail Merge  Selecting a Main Document  Selecting or Creating Recipients  COLABORATION CAPSTONE Word  Inserting Merge Fields  Merging a Main Document and a Data Source  HANDS-ON EXERCISE 3: Mail Merge  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  COLLABORATION CAPSTONE ¤ Word  Chapter 1 Collaboration Exercise Chapter 2 Collaboration Exercise Chapter 3 Collaboration Exercise Chapter 4 Collaboration Exercise 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 Excercise 1: Introduction to Spreadsheets  Mathematics and Formulas  Using Symbols and the Order of Precedence  Using Auto Fill  Displaying Cell Formulas  Hands-On Excercise 2: Mathematics and Formulas  Workbook And Worksheet Management  Managing Worksheets  Managing Columns and Rows  Selecting, Moving, Copying, and Pasting  Hands-On Excercise 3: Workbook and Worksheet Management  Formatting  Applying Alignment and Font Options  Applying Number Formats  Hands-On Excercise 4: Formatting  Page Setup And Printing  Selecting Page Setup Options  Printing a Worksheet  Hands-On Excercise 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  HAN DS-ON EXERCI SE 1: Formula Basics  Function Basics  Inserting a Function  Totaling Values with the SUM Function  Inserting Basic Statistical Functions  Using Date Functions  Hands-On Excercise 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 Excercise 3: Logical, Lookup, and Financial Functions  Range Names  Creating and Maintaining Range Names  Using Range Names in Formulas  Hands-On Excercise 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 Excercise 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 Excercise 2: Chart Design  Chart Layout  Selecting and Formatting Chart Elements  Customizing Chart Labels  Formatting the Axes and Gridlines  Adding a Trendline  Hands-On Excercise 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  HAN DS-ON EXERCI SE 1: Large Datasets  Excel Tables  Understanding Table Design  Creating a Table  Applying a Table Style  Hands-On Excercise 2: Excel Tables  Table Manipulation and Aggregation  Sorting Data  Filtering Data  Using Structured References and a Total Row  Collaboration Capstone  Excel  Hands-On Excercise 3: Table Manipulation and Aggregation  Conditional Formatting  Applying Conditional Formatting  Creating a New Rule  Sorting and Filtering Using Conditional Formatting  Hands-On Excercise 4: Conditional Formatting  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  COLLABORATION CAPSTONE ¤ Excel  Chapter 1 Collaboration Exercise Chapter 2 Collaboration Exercise Chapter 3 Collaboration Exercise Chapter 4 Collaboration Exercise Microsoft Office Access 2010 Chapter One ¤ Introduction to Access  Case Study: Managing A Business in the Global Economy  Objectives  Databases Are Everywhere!  Navigating Among the Objects in an Access Database  Understanding the Difference Between Working inStorage and Memory  Practicing Good Database File Management  Backing Up, Compacting, and Repairing Access Files  Hands-On Excercise 1: Databases Are Everywhere!  Filters, Sorts, and Acess Versus Excel  Creating Filters  Sorting Table Data on One or More Fields  Knowing When to Use Access or Excel to Manage Data  Hands-On Excercise 2: Filters, Sorts, and Access Versus Excel  Relational Database  Using the Relationships Windows  Understanding Relational Power  Hands-On Excercise 3: Relational Database  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  Chapter Two ¤ Relational Databases and Queries  Case Study: Bank Auditor Uncovers Midhandled Funds  Objectives  Table Design, Properties, Views, and Wizards  Designing Data  Creating Tables  Hands-On Excercise 1: Table Design, Properties, Views, and Wizards  Multiple Table Databases  Understanding Table Relationships  Sharing Data with Excel  Establishing Table Relationships  Hands-On Excercise 2: Multiple Table Databases  Single-Table Queries  Creating a Single-Table Query  Specifying Criteria for Different Data Types  Copying and Running a Query  Using the Query Wizard  Hands-On Excercise 3: Single-Table Queries  Multi-Table Queries  Creating a Multi-Table Query  Modifying a Multi-Table Query  Hands-On Excercise 4: Multi-Table Queries  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  Chapter Three ¤ Customize, Analyze, and Summarize Query Data  Case Study: Housing Slump Means Opportunity for College Students  Objectives  Calculations, Expressions, and Functions  Understanding the Order of Operations  Creating a Calculated Field in a Query  Hands-On Excercise 1: Calculations, Expressions, and Functions  Expression Builder, Functions, and Date Arithmetic Creating Expressions with the Expression Builder  Using Built-In Functions in Access  Performing Date Arithmetic  Hands-On Exercise 2: Expression Builder, Functions, and Date Arithmetic Aggregate Functions Adding Aggregate Functions to Datasheets and Queries Hands-On Exercise 2: Aggregate Functions Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  Chapter Four ¤ Creating and Using Professional Forms and Reports  Case Study: Coffee Shop Starts new Business  Objectives  Form Basics  Creating Forms Using the Form Tools  Modifying a Form  Sorting Records in a Form  Hands-On Excercise 1: Form Basics  Form Sections, Views, and Controls  Identifying Form Sections  Revising Forms Using Form Views  Identifying Control Types in Forms  Hands-On Excercise 2: Form Sections, Views, and Controls  Report Basics  Creating Reports Using Report Tools  Modifying a Report  Sorting Records in a Report  Collaboration Capstone  Access  Hands-On Excercise 3: Report Basics  Report Sections, Views, and Controls  Identifying Report Sections  Revising Reports Using Report Views  Identifying Control Types in Reports  Hands-On Excercise 4: Report Sections, Views, and Controls  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  COLLABORATION CAPSTONE ¤ Access  Chapter 1 Collaboration Exercise Chapter 2 Collaboration Exercise Chapter 3 Collaboration Exercise Chapter 4 Collaboration Exercise Microsoft Office Powerpoint 2010 Chapter One ¤ Introduction to PowerPoint  Case Study: Be A Trainer  Objectives  Introduction to Powerpoint  Using PowerPoint Views  Saving as a Slide Show  Hands-On Excercise 1: Introduction to PowerPoint  Presentation Creation  Planning a Presentation  Assessing Presentation Content  Using Slide Layouts  Applying Themes  Reviewing the Presentation  Hands-On Excercise 2: Presentation Creation  Presentation Development  Inserting Media Objects  Adding a Table  Using Animations and Transitions  Inserting a Header or Footer  Hands-On Excercise 3: Presentation Development  Navigation and Printing  Running and Navigating a Slide Slow  Printing in PowerPoint  Hands-On Excercise 4: Navigation and Printing  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  Chapter Two ¤ Presentation Development  Case Study: The Wellness Education Center  Objectives  Templates  Creating a Presentation Using a Template  Modifying a Template  Hands-On Excercise 1: Templates  Outlines  Creating a Presentation in Outline View  Modifying an Outline Structure  Printing an Outline  Hands-On Excercise 2: Outlines  Data Imports  Importing an Outline  Adding Existing Content to a Presentation  Hands-On Excercise 3: Data Imports  Design  Using Sections  Examining Slide Show Design Principles  Modifying a Theme  Hands-On Excercise 4: Design  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  Chapter Three ¤ Presentation Design  Case Study: Illustrations and Infographics Mini-Camp  Objectives  Shapes  Creating Shapes  Applying Quick Styles and Customizing Shapes  Hands-On Excercise 1: Shapes  Smartart and Wordart  Creating SmartArt  Modifying SmartArt  Creating WordArt  Modifying WordArt  Hands-On Excercise 2: SmartArt and WordArt  Object Manipulation  Modifying Objects  Arranging Objects  Hands-On Excercise 3: Object Manipulation  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  Chapter Four ¤ PowerPoint Rich Media Tools  Case Study: Wedding Albums  Objectives  Pictures  Inserting a Picture  Transforming a Picture  Using the Internet as a Resource  Hands-On Excercise 1: Pictures  Video  Adding Video  Using Video Tools  Hands-On Excercise 2: Video  Audio  Adding Audio  Changing Audio Settings  Hands-On Excercise 3: Audio  Photo Albums  Creating a Photo Album  Setting Photo Album Options  Hands-On Excercise 4: Photo Albums  Chapter Objectives Review  Key Terms  Multiple Choice  Practice Exercises  Mid-Level Exercises  Capstone Exercise  Beyond The Classroom  COLLABORATION CAPSTONE ¤ PowerPoint  Chapter 1 Collaboration Exercise Chapter 2 Collaboration Exercise Chapter 3 Collaboration Exercise Chapter 4 Collaboration Exercise CAPSTONE EXERCISES VOLUME 1 ¤ Using Office in Paralegal, Zoo, and Medical Professions  Paralegal  Word  Excel  Access  PowerPoint  Integrated  Zoo  Word  Excel  Access  PowerPoint  Integrated  Medical  Word  Excel  Access  PowerPoint  Integrated  Glossary  Index