Prentice Hall

Information Technology



Exploring Microsoft Office 2007, Volume 1, 2/E
Robert T. Grauer, University of Miami
Maryann Barber
Michelle Hulett
Cyndi Krebs
Maurie Lockley
Judy Scheeren, Westmoreland County Community College
Keith Mulbery, Utah Valley State College

ISBN-10: 0131577298
ISBN-13: 9780131577299

Publisher: Prentice Hall
Copyright: 2008
Format: Paper; 1312 pp
Published: 12/31/2007

Suggested retail price: $112.00
Buy from myPearsonStore

For introductory computer courses in Microsoft 2007 or courses in computer concepts with a lab component for Microsoft Office 2007 applications, using Windows Vista as the operating system.

 

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.

For introductory computer courses in Microsoft 2007 or courses in computer concepts with a lab component for Microsoft Office 2007 applications, using Windows Vista as the operating system.

 

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.

 

Beyond The Point and Click

 

Students go to college now with a different set of skills than they did 5 years ago.  The new edition of Exploring moves students beyond the basics of the software at a faster pace, without sacrificing fundamental skills to ensure that they will be engaged from Chapter 1 throughout the book.

 

Diversity

 

Students have diverse career goals.  To target the variety of majors taking the course, Exploring offers examples relevant to every student.  Several examples in the text include the:

 

·        Health sciences

·        Hospitality

·        Urban planning

·        Business

 

Studying Made Easy

 

Students read, prepare, and study differently than they used to. Rather than reading a book cover to cover, students want to easily identify what they need to know, and then learn it efficiently.  The key features bring students into the content, making the text easy to use.

 

Some features include:

 

  • Objective Mapping
  • Pull Quotes
  • Key Terms

 

OTHER TOPICS OF DISTINCTION

 

Key Features of the Office 2007 Revision

 

  • NEW! “Moving Beyond the Basics” introduces advanced skills earlier because students are learning basic skills faster.

 

  • White Pages/Yellow Pages clearly distinguish theory from skills covered in Hands-On exercises, so students always know what they are supposed to be doing.

 

  • NEW! Objective Mapping enables students to skip the skills, quickly finding concepts that they don’t know by scanning the chapter opener page for the exact location of new concepts.

 

  • NEW! Pull Quotes entice students into the theory by emphasizing the most interesting points.

 

  • NEW! Mini-cases with Rubrics are open ended exercises that guide both instructors and students to a solution with a specific rubric for each case.

 

  • NEW! More End-of-Chapter Exercises offer instructors more options for assessment.  Each chapter has approximately 12-15 exercises ranging from multiple-choice to open-ended projects, including mid-level and capstone exercises covering all skills in each chapter.

 

  • Case Study Related icons are available to help students identify skills specific to each case study.

 

  • NEW! Conceptual Animations connect theory with skills, by illustrating tough to understand concepts with interactive multimedia. 

 

  • NEW! Capstone Production Tests, included in the text and on the IRCD, allows instructors to asses all the skills in the chapter with a single project.

 

Integrated Assessment and Training

 

myitlab for Microsoft 2007, is a solution designed by professors that allows you to easily deliver Office courses with defensible assessment and outcomes-based training.  No longer is the technology mapped to your textbook, this 1:1 content relationship between the software and the text means that online assessment and training will work with your textbook to move students beyond the point and click.

 

  • Advanced Reporting — With myitlab you will get advanced reporting capabilities including a detailed student click stream, providing you with true, defensible grading.
  • Project-based assessment — Test students on Exploring Projects, or break down assignments into individual Office application skills.
  • No installation required! myitlab runs entirely from the Web.

 

Unique Instructor Resources

 

Reference Cards are available to outline KEY objectives in each chapter, helping instructors anticipate where students get stuck and how to get them “un-stuck.”  Helping to bridge the gap between the instructor and student on more difficult topics by offering:

 

  • Concept Summaries — Reference cards that outline chapter objectives and common pitfalls.
  • Case Study Lecture Demonstration Document — Provides instructors with a lecture sample based on the chapter opening case that will guide them to critically use the skills covered in the chapter, with examples of other ways the skills can be applied.

The 2nd edition now includes a chapter of Windows Vista and all screen shots and instructions have been updated to cover Windows Vista.

 

NEW! Updated Windows Vista Coverage

 

NEW! Cumulative Capstone Exercises are available for each application to tie application use to real-life professional situations in the arts, hospitality, legal, and health-care industries.

 

NEW! Student Reference Foldout Card for Office 2007 Ribbons includes text explanations and screenshots of Office 2007 Ribbons for Word, Excel, Access, PowerPoint, and Common Office.  It also has one panel showing differences between XP and Vista.

 

Additional Features of the Office 2007 Revision

 

  • NEW! “Moving Beyond the Basics” introduces advanced skills earlier because students are learning basic skills faster.

 

  • White Pages/Yellow Pages clearly distinguish theory from skills covered in Hands-On exercises, so students always know what they are supposed to be doing.

 

  • NEW! Objective Mapping enables students to skip the skills, quickly finding concepts that they don’t know by scanning the chapter opener page for the exact location of new concepts.

 

  • NEW! Pull Quotes entice students into the theory by emphasizing the most interesting points.

 

  • NEW! Mini-cases with Rubrics are open ended exercises that guide both instructors and students to a solution with a specific rubric for each case.

 

  • NEW! More End-of-Chapter Exercises offer instructors more options for assessment.  Each chapter has approximately 12-15 exercises ranging from multiple-choice to open-ended projects, including mid-level and capstone exercises covering all skills in each chapter.

 

  • Case Study Related icons are available to help students identify skills specific to each case study.

 

  • NEW! Conceptual Animations connect theory with skills, by illustrating tough to understand concepts with interactive multimedia. 

CONTENTS

 

PREFACE ............................................................................................XXI

 

OFFICE

Chapter 1 Office Fundamentals ......................................................1

 

WORD

Chapter 1 Microsoft Word................................................................69

Chapter 2 Gaining Proficiency......................................................131

Chapter 3 Enhancing a Document..............................................195

Chapter 4 Share, Compare, and Document ..............................249

 

EXCEL

Chapter 1 Introduction to Excel ....................................................311

Chapter 2 Formulas and Functions ..............................................379

Chapter 3 Charts ............................................................................429

Chapter 4 Working with Large Worksheets and Tables ..............485

 

ACCESS

Chapter 1 Introduction to Access ................................................545

Chapter 2 Relational Databases and Multi-Table Queries ........605

Chapter 3 Customize, Analyze, and Summarize Query Data ......677

Chapter 4 Create, Edit, and Perform Calculations in Reports......729

 

POWERPOINT

Chapter 1 Introduction to PowerPoint..........................................793

Chapter 2 Presentation Development ........................................867

Chapter 3 Presentation Design......................................................929

Chapter 4 PowerPoint Multimedia Tools ....................................1011

 

WINDOWS VISTA

Chapter 1 Getting Started with Windows Vista ........................1077

 

CAPSTONE EXERCISES

Volume 1 Using Office in the Legal Profession, Health Care, the Arts, and Hospitality ..................................1143

 

GLOSSARY.............................................................................................1237

MULTIPLE CHOICE ANSWER KEYS...........................................................1247

INDEX..............................................................................................................1251

Give your students a choice! PearsonChoices products are designed to give your students more value and flexibility by letting them choose from a variety of text and media formats to best match their learning style and their budget.

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, see the Packages tab.

  • 0135075491Custom PHIT Database
    Pearson Custom Publishing
    © 2009 | Prentice Hall | On-line Supplement | Estimated Availability: 09/01/2009
    ISBN-10: 0135075491 | ISBN-13: 9780135075494

    • CourseSmart Textbooks Online is an exciting new choice for students looking to save money. As an alternative to purchasing the print textbook, students can subscribe to the same content online and save up to 50% off the suggested list price of the print text. With a CourseSmart etextbook, students can search the text, make notes online, print out reading assignments that incorporate lecture notes, and bookmark important passages for later review. For more information, or to subscribe to the CourseSmart eTextbook, visit www.coursesmart.com.

     

  • 0135044588Exploring Microsoft Office 2007, Volume 1, CourseSmart eTextbook, 2/E
    Grauer, Barber, Hulett, Krebs, Lockley, Scheeren & Mulbery
    © 2008 | Prentice Hall | Electronic Book; 1312 pages | Instock
    ISBN-10: 0135044588 | ISBN-13: 9780135044582
    URL: http://www.coursesmart.com
    Brief Description | Buy from myPearsonStore

This title is a member of the Exploring Series, which also contains the titles below . You can also visit the Exploring Series page.

  • 013232847XExploring MS Office PowerPoint 2007, Comprehensive
    Grauer & Krebs
    © 2008 | Prentice Hall | Paper; 656 pages | Instock
    ISBN-10: 013232847X | ISBN-13: 9780132328470
    Buy from myPearsonStore

    • For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

     

    This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

  • 0131791206Exploring Microsoft Access 2003, Comprehensive and Student Resource CD Package
    Grauer & Barber
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0131791206 | ISBN-13: 9780131791206
    Brief Description | Buy from myPearsonStore

    • For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

     

    This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

  • 0131791222Exploring Microsoft Access 2003, Vol. 1 and Student Resource CD Package
    Grauer & Barber
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0131791222 | ISBN-13: 9780131791220
    Brief Description | Buy from myPearsonStore

    • For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

     

    This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

  • 0131791184Exploring Microsoft Access 2003, Vol. 2 and Student Resource CD Package
    Grauer & Barber
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0131791184 | ISBN-13: 9780131791183
    Brief Description | Buy from myPearsonStore

    • For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.

                          
    Master the How and Why of Office 2003!  Students master the "How and Why" of performing tasks in Office and gain a greater understanding of how to use the individual applications together to solve business problems.

     

  • 0132303949Exploring Microsoft Excel 2003, Vol. 2 and Student Resource CD Package
    Grauer & Barber
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Estimated Availability: 08/04/2008
    ISBN-10: 0132303949 | ISBN-13: 9780132303941
    Brief Description

  • 0132240041Exploring Microsoft Office 2007 Brief
    Grauer, Hulett, Krebs, Mulbery, Lockley & Scheeren
    © 2008 | Prentice Hall | Paper; 656 pages | Estimated Availability: 07/01/2008
    ISBN-10: 0132240041 | ISBN-13: 9780132240048


  • 013235053XExploring Microsoft Office 2007 Getting Started with the Online Experience
    Grauer & McCloud
    © 2008 | Prentice Hall | Spiral Bound; 96 pages | Instock
    ISBN-10: 013235053X | ISBN-13: 9780132350532
    Buy from myPearsonStore

    •  

    The goal of the Exploring series has been to move students beyond the point and click and help the student understand why and when they would perform a skill.   The system structure considers the following three points.

     

    Students go to college now with a different set of skills than they did 5 years ago.  With this in mind, the new edition of Exploring moves students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know.  This ensures that students will be engaged from Chapter 1 throughout the book.

     

    Students have diverse career goals. The examples in the text (and the accompanying Instructor Resources) include the health sciences, hospitality, urban planning, business and more so Exploring will be relevant to every student in the course.

     

    Students read, prepare and study differently than they used to. Rather than reading a book cover to cover students want to easily identify what they need to know, and then learn it efficiently.  The key features bring students into the content and make the text easy to use.

     

    Students will be more engaged, achieve a higher level understanding in Office, and will successfully complete this course.

  • 0131575643Exploring Microsoft Office 2007 Volume 1
    Grauer, Scheeren, Lockley, Hulett & Krebs
    © 2008 | Prentice Hall | Paper; 1196 pages | Estimated Availability: 07/01/2008
    ISBN-10: 0131575643 | ISBN-13: 9780131575646
    Brief Description

    • The goal of the Exploring series has been to move students beyond the point and click and help the student understand why and when they would perform a skill.   The system structure considers the following three points.

     

    Students go to college now with a different set of skills than they did 5 years ago.  With this in mind, the new edition of Exploring moves students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know.  This ensures that students will be engaged from Chapter 1 throughout the book.

     

    Students have diverse career goals. The examples in the text (and the accompanying Instructor Resources) include the health sciences, hospitality, urban planning, business and more so Exploring will be relevant to every student in the course.

     

    Students read, prepare and study differently than they used to. Rather than reading a book cover to cover students want to easily identify what they need to know, and then learn it efficiently.  The key features bring students into the content and make the text easy to use.

     

    Students will be more engaged, achieve a higher level understanding in Office, and will successfully complete this course.

  • 0136130372Exploring Microsoft Office 2007 Volume 2
    Grauer, Hulett, Krebs, Lockley & Scheeren
    © 2008 | Prentice Hall | Paper; 1296 pages | Instock
    ISBN-10: 0136130372 | ISBN-13: 9780136130376
    Brief Description | Buy from myPearsonStore

    • For introductory computer courses in Microsoft 2007 or courses in computer concepts with a lab component for Microsoft Office 2007 applications, using Windows Vista as the operating system.

     

    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.

  • 0131577298Exploring Microsoft Office 2007, Volume 1, 2/E
    Grauer, Barber, Hulett, Krebs, Lockley, Scheeren & Mulbery
    © 2008 | Prentice Hall | Paper; 1312 pages | Instock
    ISBN-10: 0131577298 | ISBN-13: 9780131577299
    Brief Description | Buy from myPearsonStore

  • 0131567888Exploring Microsoft Office Access 2007, Comprehensive
    Grauer & Lockley
    © 2008 | Prentice Hall | Paper; 736 pages | Instock
    ISBN-10: 0131567888 | ISBN-13: 9780131567887
    Buy from myPearsonStore

  • 0132252120Exploring Microsoft Office Access 2007, Volume 1
    Grauer & Lockley
    © 2008 | Prentice Hall | Paper; 368 pages | Instock
    ISBN-10: 0132252120 | ISBN-13: 9780132252126
    Buy from myPearsonStore

  • 0132328526Exploring Microsoft Office Word 2007, Comprehensive
    Grauer & Hulett
    © 2008 | Prentice Hall | Paper; 560 pages | Instock
    ISBN-10: 0132328526 | ISBN-13: 9780132328524
    Buy from myPearsonStore

  • 0131572733Exploring Microsoft Office Word 2007, Volume 1
    Grauer & Hulett
    © 2008 | Prentice Hall | Paper; 424 pages | Estimated Availability: 07/01/2008
    ISBN-10: 0131572733 | ISBN-13: 9780131572737


    • For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

     

    This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

  • 0132303957Exploring Microsoft PowerPoint 2003 Comprehensive and Student Resource CD Package
    Grauer & Barber
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Out of Stock
    ISBN-10: 0132303957 | ISBN-13: 9780132303958
    Brief Description

    • For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

     

    This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

  • 0132303965Exploring Microsoft PowerPoint 2003, Vol. 1 and Student Resource CD Package
    Grauer & Barber
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0132303965 | ISBN-13: 9780132303965
    Brief Description | Buy from myPearsonStore

    • For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

     

    This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

  • 0132303973Exploring Microsoft PowerPoint 2003, Vol. 2 and Student Resource CD Package
    Grauer & Barber
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
    ISBN-10: 0132303973 | ISBN-13: 9780132303972
    Brief Description | Buy from myPearsonStore

    • For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.

     

    Master the Skills of Office 2003! With the hands-on approach and conceptual framework students will master the skills and apply them in their personal and professional lives.

  • 0132303981Exploring Microsoft Word 2003 Comprehensive and Student Resource CD Package
    Grauer & Barber
    © 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Estimated Availability: 08/29/2008
    ISBN-10: 0132303981 | ISBN-13: 9780132303989
    Brief Description

    • For introductory courses in Microsoft Office SharePoint Designer.

     

    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.

     

  • 0132350513Exploring with Microsoft SharePoint Designer 2007, Brief
    Grauer & Marghitu
    © 2008 | Prentice Hall | Spiral Bound; 448 pages | Instock
    ISBN-10: 0132350513 | ISBN-13: 9780132350518
    Brief Description | Buy from myPearsonStore

  • 0132328569IRCD Exploring Microsoft Word 2007
    Grauer
    © 2008 | Prentice Hall | CD-ROM Only | Instock
    ISBN-10: 0132328569 | ISBN-13: 9780132328562


    • The TestGen application for this title is available for download via the web. To install or upgrade the TestGen application, go to http://www.pearsoned.com/testgen. Note that you will not be able to open and use the test bank files below unless you have installed the TestGen application in your system.
  • 0132328577TestGen Exploring Microsoft Word 2007
    Grauer
    © 2008 | Prentice Hall | On-line Supplement | Instock
    ISBN-10: 0132328577 | ISBN-13: 9780132328579
    Brief Description

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.