MOUS Essentials: Excel 2000 with CD / Edition 1

Other Format (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Other Format)
  • All (17) from $1.99   
  • New (2) from $14.89   
  • Used (15) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$14.89
Seller since 2009

Feedback rating:

(127)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
PAPERBACK New 0130191043 CD INCLUDED-NEW NEVER USED-EXPERIENCE AMAZING CUSTOMER SERVICE-WE SHIP DAILY.

Ships from: Chickamauga, GA

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$45.00
Seller since 2014

Feedback rating:

(146)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by

Overview

Prentice Hall's MOUS Essentials were created specifically to meet the required guidelines established by Microsoft for the Microsoft Office User Specialist Exam.

The authors follow the proven approach of Prentice Hall's Essentials series with an emphasis on step-by-step tutorials with large screen shots, outstanding student pedagogy and plenty of exercises. This text also includes a number of elements designed to help students study for the MOUS exams. As an additional test preparation tool, the series also includes live computer-based training and assessment with the MOUS Kelly PinPoint CD-ROM.

Key Features

  • ALL MOUS Essentials books are certified to the Expert Level by Microsoft as approved test preparation guides for the MOUS exam.
  • A unique appendix entitled Preparing for MOUS Certification provides information on how to register, what is covered in the tests, how the tests work and levels of certification.
  • Each Project opens with Required Activities for both levels of the exam objectives. These activities are indicated throughout the Projects by icons distinguishing core vs. expert objectives.
  • Exam Notes and Inside Stuff sidebars provide students with extra tips and tricks on preparing for and taking the MOUS exams.
  • MOUS PinPoint software provides computer-based training and assessment tools for students to complete the projects and practice for the MOUS exams. MOUS PinPoint includes Project Review Tests along with "Show Me" training for each Microsoft MOUS Exam Skill Set covered within the Project. In addition, each MOUS PinPoint has a capstone final exam that mirrors the actual MOUS exams.
Read More Show Less

Product Details

  • ISBN-13: 9780130191045
  • Publisher: Prentice Hall
  • Publication date: 4/13/2000
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 464
  • Product dimensions: 8.50 (w) x 10.84 (h) x 0.76 (d)

Meet the Author

MARIANNE FOX is an Indiana CPA with BS and MBA degrees in Accounting from Indiana University. For more than20 years, she has enjoyed teaching full-time—initially in Indiana University's School of Business; since 1988 in the College of Business Administration at Butler University. As the co-owner of an Indian-based consulting firm, Marianne has extensive experience consulting and training in the corporate and continuing education environments. Since 1984, she has co-authored more than 35 computer-related books and made presentations on accounting, computer applications, and instructional development topics at a variety of seminars and conferences.

LAWRENCE C. METZELAAR earned a BS in Business Administration and Computer Science from the University of Maryland and an Ed.M and CAGS in Human Problem Solving from Boston University. Larry has more than 35 years experience with military and corporate mainframe and microcomputer systems. He has taught computer science and information systems at the University of Hawaii, Control Data Institute, Indiana University, Purdue University, and is currently on the faculty at Butler University. As the co-owner of an Indiana-based consulting firm, he has extensive experience consulting and training in the corporate environment. Since 1984, he has co-authored more than 35 computer-related books and made presentations on computer applications and instructional development topics at a variety of seminars and conferences.

Read More Show Less

Read an Excerpt

PREFACE Introduction

Essentials courseware from Prentice Hall is anchored in the practical and professional needs of all types of students. Each title in the series reflects a "learning-by-doing" approach that encourages you to grasp application-related concepts as you expand your skills through hands-on tutorials.

The MOUS Essentials series has an added focus—preparing you for certification as a Microsoft Office User Specialist. The Specialist designation distinguishes you from your peers as knowledgeable in using Office products, which can also make you more competitive in the job market.

The Specialist program is available for many Office 2000 applications at both Core and Expert User levels. You can learn more about the Specialist program in Appendix B, "Preparing for MOUS Certification," and at the www.mous.net Web site. How To Use this Book

You have selected a book providing a comprehensive approach to learning Excel, with emphasis on skill sets designated by Microsoft as Care or Expert for purposes of certification as a Microsoft Office User Specialist. Please take a few moments to familiarize yourself with the icons used in this book and its conventions. If you have questions or comments, visit the related Prentice Hall MOUS Essentials Web site: www.prenhall.com/mousessentials.

Each MOUS Essentials text consists of modular lessons that are built around a series of numbered step-by-step procedures that are clear, concise, and easy to review. Brief explanations are provided at the start of each lesson and, as needed, between steps. Many lessons contain additional notes and tips.

A MOUSEssentials book includes 15 to 21 projects, two appendixes and a glossary. Each project covers one area (or a few closely related areas) of application functionality, and is divided into lessons related to that topic. For example, a project on improving the appearance of a worksheet includes lessons on formatting numbers, aligning cell contents, changing font and font size, applying bold and italic, adding color, adding borders, using Format Painter and removing formatting. Each lesson presents a specific task or closely related set of tasks in a manageable chunk that's easy to assimilate and retain.

Each element in a MOUS Essentials title is designed to maximize your learning experience. Here's a list of the MOUS Essentials project elements and a description of how each element can help you:

  • Required MOUS Objectives Table. These tables are organized into three columns: Objective, Required Activity for MOUS, and Exam Level. The objective column lists the general objectives of the project. The associated MOUS requirements for each objective are listed in the Required Activity for MOUS column. The particular exam levels of those activities7#151;Core or Expert—are listed in the Exam Level column. Look over the objectives and MOUS requirements on the opening page of each project before you begin, and review them after completing the project to identify the main goals for each project.
  • Key Terms. This book includes useful vocabulary words and definitions specific to the application. Key terms introduced in each project are listed in alphabetical order on the opening page of the project. These key terms then appear in bold italic within the text and are defined during their first occurrence in the project.
  • Why Would I Do This? You are studying Excel to accomplish useful tasks in the real world. This brief section at the beginning of each project tells you why these tasks or procedures are important. What can you do with the knowledge? How can these application features be applied to everyday tasks?
  • MOUS Core Objective Icon. This icon indicates that a lesson relates to a specific MOUS Core-level skill. MOUS skills may be covered by a whole lesson or perhaps just a single step within a lesson.
  • MOUS Expert Objective Icon. This icon indicates that a lesson relates to a MOUS Expert-level skill. There may be a mix of Core and Expert objectives within a project. Some objectives are both Core and Expert, as well.
  • Lessons. Each lesson contains one or more tasks that correspond to an objective or MOUS requirement, which are listed on the opening page of the project. A lesson consists of step-by-step tutorials, associated screen captures, and the sidebar notes of the types described later. Though each lesson often builds on the previous one, the lessons have been made as modular as possible. For example, you can skip tasks that you've already mastered and begin a later lesson, if you choose.
  • Step-by-Step Tutorial. The lessons consist of numbered, bolded step-by-step instructions that show you how to perform the procedures in a clear, concise, and direct manner. These hands-on tutorials, which are the "essentials" of each project, let you "learn by doing." A short paragraph may appear after a step to clarify the results of the step. Screen captures are provided after key steps so that you can compare the results on your monitor. To review the lesson, you can easily scan the bold, numbered steps.
  • Exam Note. These sidebars provide information and insights on topics covered on MOUS exams. You can easily recognize them by their distinctive icon. It's well worth the effort to review these crucial notes again after completing a project.
  • Inside Stuff. Inside Stuff comments provide extra tips, shortcuts, alternative ways to complete a process, as well as special hints. You may safely ignore these for the moment to focus on the main task at hand, or you may pause to learn and appreciate these tidbits.
  • If You Have Problems... These short troubleshooting notes help you anticipate or solve common problems quickly and effectively. Even if you don't encounter the problem at this time, do make a mental note of it so that you know where to look when you find yourself having difficulties.
  • Summary. This section provides a brief recap of the activities learned in the project. The summary often includes suggestions for expanding your knowledge.
  • Checking Concepts and Terms. This section offers optional true/false and multiple choice questions designed to check your comprehension and assess retention. If you need to refresh your memory, the relevant lesson number is provided after each question. For example, L5 directs you to review Lesson 5 for the answer.
  • Skill Drill. This section enables you to check your comprehension, evaluate your progress, and practice what you've learned. The exercises in this section build on and reinforce what you have teamed in each project. Generally, the Skill Drill exercises include step-by-step instructions. A Core or Expert icon indicates whether a MOUS required activity is introduced in a Skill Drill exercise.
  • Challenge. This section provides exercises that expand on or relate to the skills practiced in the project. Each exercise provides a brief narrative introduction followed by instructions. Although the instructions are written in a step-by-step format, the steps are not as detailed as those in the Skill Drill section. Providing fewer specific steps helps you learn to think on your own.
  • Discovery Zone. These exercises require advanced knowledge of project topics or application of skills from multiple lessons. Additionally, these exercises might require you to research topics in Help or on the Web to complete them. This self-directed method of learning new skills emulates real-world experience. A Core or Expert icon indicates if a MOUS required activity is introduced in a Discovery Zone exercise.
  • Pin Point Assessment. Each project ends with a reminder to use MOUS Pinpoint training and testing software to supplement the projects in the book. The software aids you in your preparation for taking and passing the MOUS exams. A thorough explanation of how to use the Pinpoint software is provided in Appendix A, "Using the MOUS Pinpoint Training and Testing Software."
Typeface Conventions Used in this Book

We have used the following conventions throughout this book so that certain items stand out from the rest of the text:

  • Key terms appear in bold italic the first time they are defined.
  • Monospace type appears frequently. It is used to indicate I ) text that you are instructed to key in, 2) text that appears onscreen as warnings, confirmations, or general information, 3) the name of a file to be used in a lesson or exercise, and 4) text from a dialog box that is referenced within a sentence, when that sentence might appear awkward if the dialog box text were not set off.
  • Hotkeys are indicated by underline. Hotkeys are the underlined letters in menus, toolbars, and dialog boxes that activate commands and options, and are a quick way to choose frequently used commands and options. Hot keys look like this: File, Save.
How To Use Student Data Files on the CD-ROM

The CD-ROM accompanying this book contains Pinpoint as well as all the data files for you to use as you work through the step-by-step tutorials within projects and the Skill Drill, Challenge, and Discovery Zone exercises provided at the end of each project. The CD contains separate parallel folders for each project.

The names of the student data files correspond to the filenames called for in the textbook. Each filename includes six characters—an initial letter indicating the application, a dash, two digits indicating the project number, and two digits indicating the file number within the project. For example, the first file used in Excel Project 2 is named e-0201. The third file in Excel Project 14 is named e-1403. The Word document named e-stufiles.doc on the companion Web site (www.prenhall.com/mousessentials) provides a complete listing of data files by project, including the corresponding names used to save each file.

Please refer to the Readme file on the CD for instruction on how to use the CD-ROM. Supplements

  • Instructor's Resource CD-ROM—The Instructor's Resource CD-ROM includes the entire Instructor's Manual for each application in Microsoft Word format and also contains screen shots that correspond to the solutions for the lessons in the book. A computerized testbank is included to create tests, maintain student records, and to provide online practice testing. Student data files and completed solution files are also on the CD-ROM. PowerPoint slides, which elaborate on each project, are also included.
  • Companion Web Site (www.prenhall.com/mousessentials)—For both students and instructors, the companion Web site includes all the ancillary material to accompany the MOUS Essentials series. Students can find additional test questions that evaluate their understanding of the key concepts of each application and also instant feedback on their results. Instructors will find the data and solution files, Instructor's Manual, and PowerPoint slides for each application.
Read More Show Less

Table of Contents



1. Getting Started with Excel 2000.

Exploring the Excel Work Area. Entering Text and Numbers. Saving a Workbook. Getting Help. Entering a Formula. Preparing a Worksheet for Printing. Printing a Worksheet. Closing a File and Exiting Excel.

2. Modifying a Worksheet.

Opening an Existing Worksheet. Selecting Worksheet Items. Using AutoFill. Inserting and Deleting Rows and Columns. Copying and Moving Cell Contents. Using AutoSum. Copying a Formula with Relative References. Spell-Checking a Worksheet.

3. Improving the Appearance of a Worksheet.

Formatting Numbers. Aligning Cell Contents. Changing Font and Font Size. Applying Bold, Italic, and Underline. Adding Color. Adding Borders. Using Format Painter. Removing Formatting.

4. Entering Formulas in Well-Designed Worksheets.

Working with Operators and Order of Precedence. Using Type-and-Point to Enter Formulas. Comparing Absolute and Relative Cell References. Creating and Copying Formulas with Absolute or Relative Cell References. Freezing and Splitting Worksheet Display. Hiding and Unhiding Rows and Columns. Displaying Formulas Instead of Formula Results. Using Save As to Change File-name, File Type or Storage Location.

5. Working with Functions.

Analyzing Data with AVERAGE, MAX and MIN. Calculating a Loan Payment with PMT. Creating a Loan Payment Table. Evaluating Investment Plans with FV Function. Using IF to Display Messages. Using IF to Calculate. Using NOW to Display the Current Date. Using VLOOKUP to Convert Data.

6. Creating and Modifying Charts.

Identifying Common Chart Types and Features. Using Chart Wizard to Create anEmbedded Pie Chart. Using Chart Wizard to Create an Embedded Column Chart. Changing Chart Type. Charting Nonadjacent Data Series. Modifying Chart Formulas. Adding, Reordering and Deleting a Data Series. Creating and Printing a Combination Chart.

7. Developing a Multiple-Sheet Workbook.

Copying Data from Another Application. Inserting, Moving and Renaming Worksheets. Editing Multiple Worksheets Simultaneously. Subtotaling Data. Linking Worksheets. Applying Conditional Formatting. Using a Worksheet to Solve a Problem. Saving a Worksheet with Chart as a Web Page.

8. Working with Custom Formats, Auto Formats, Styles, and Templates.

Inserting and Deleting Cells. Replacing and Rotating Text. Creating a Custom Format. Applying an AutoFormat. Creating and Using Styles. Copying a Worksheet. Emailing a Workbook or Worksheet within Excel. Creating and Using a Template.

9. Creating Special Effects in a Worksheet.

Creating WordArt. Inserting and Rotating an AutoShape. Creating a Text Box. Grouping Objects. Adding Emphasis with Lines and Arrows. Adding Emphasis with Callouts. Inserting a Graphics File. Embedding Sound.

10. Sorting, Filtering, and Editing Lists.

Using an Excel List as a Database. Sorting Records on the Contents of One Field. Sorting Records on the Contents of Two or More Fields. Using AutoFilter with One Search Condition. Using Custom AutoFilter with OR Search Criteria. Using Custom AutoFilter with AND Search Criteria. Adding and Deleting Records by Using a Form. Editing Records by Using a Form.

11. Documenting and Protecting Worksheets and Workbooks.

Creating and Using Range Names. Attaching Comments to a Cell. Getting Help on Security Features in Excel. Protecting Worksheet Contents and Objects. Unlocking Cells. Unlocking Objects. Viewing and Setting File Properties. Requiring a Password.

12. Guiding Cell Entry with Data Validation.

Attaching an Input Message to a Cell. Restricting Cell Entries to Data from a List. Restricting Cell Entries to Whole Numbers within Specified Limits. Creating a User-Specified Error Alert Message. Copying Data Restrictions and Messages to Other Cells. Using Audit Tools to Find Invalid Data. Editing Errors Including Validation Settings. Finding Cells That Have Data Restrictions or Messages.

13. Creating PivotTable and PivotChart Reports.

Displaying Help on Pivot Tables and Related Charts. Creating a Pivot Table. Expanding a Pivot Table. Removing, Hiding, and Showing Data. Refreshing a Pivot Table. Creating a Chart from Pivot Table Data. Applying Predefined Formats to a Pivot Table. Displaying Pivot Tables on the Web.

14. Creating Consolidated Data, Outlines, Views, and Reports.

Consolidating Data in Multiple Worksheets. Consolidating Multiple Workbooks. Creating an Auto Outline. Creating a Manual Outline. Creating and Using Custom Views. Creating Reports Using Report Manager. Editing and Printing Reports Using Report Manager. Saving a Group of Workbooks in a Workspace File.

15. Automating Tasks with Macros.

Preparing to Record a Macro. Recording a Macro. Playing a Macro. Recording a Macro in a Personal Macro Workbook. Playing a Macro from the Personal Macro Workbook. Unhiding and Editing the Personal Macro Workbook. Creating a Macro Button in a Workbook.

16. Using Auditing Tools, Goal Seek, Data Tables, Scenarios, and Solver.

Using Auditing Tools to Interpret Error Messages. Using Auditing Tools to Check Worksheet Formulas. Using Auditing Tools to Reverse Engineer a Worksheet. Using Goal Seek in Revenue Analysis. Performing a What-if Analysis with a Data Table. Using Scenarios to Perform What-If Analysis. Using Solver to Maximize Profits.

17. Using Collaborative Tools, Extracting Data, and Creating HyperLinks.

Tracking Changes in a Workbook. Accepting or Rejecting Changes. Editing a Shared Workbook. Extracting Data Using Advanced Filter. Using Hyperlinks within a Workbook. Using a Hyperlink in a Word Document to Reference Excel Data. Using a Hyperlink in a PowerPoint Slide to Reference Excel Data.

18. Integrating Applications.

Linking Excel Data to a Word Document. Embedding Excel Data in a Word Document. Linking Excel Data to a PowerPoint Slide. Linking an Excel Chart to a PowerPoint Slide. Converting an Excel List to an Access Database. Importing Data from a Text File. Editing an HTML File Using Excel. Getting External Data from Access into Excel.

Appendix A: Using the MOUS PinPoint 2000 Training and Testing Software.

Introduction to PinPoint 2000. Running PinPoint 2000. Installing the Launcher to Your Computer. Preparing to Run the PinPoint 2000 Launcher. Starting the PinPoint 2000 Launcher. Starting the PinPoint 2000 Trainers and Evaluations. Running a Trainer. Running an Evaluation. Viewing Reports in the Launcher. Recovering from a Crash during a Trainer or Evaluation. Removing PinPoint 2000.

Appendix B: Preparing for MOUS Certification.


Glossary.


Index.

Read More Show Less

Preface

PREFACE

Introduction

Essentials courseware from Prentice Hall is anchored in the practical and professional needs of all types of students. Each title in the series reflects a "learning-by-doing" approach that encourages you to grasp application-related concepts as you expand your skills through hands-on tutorials.

The MOUS Essentials series has an added focus—preparing you for certification as a Microsoft Office User Specialist. The Specialist designation distinguishes you from your peers as knowledgeable in using Office products, which can also make you more competitive in the job market.

The Specialist program is available for many Office 2000 applications at both Core and Expert User levels. You can learn more about the Specialist program in Appendix B, "Preparing for MOUS Certification," and at the www.mous.net Web site.

How To Use this Book

You have selected a book providing a comprehensive approach to learning Excel, with emphasis on skill sets designated by Microsoft as Care or Expert for purposes of certification as a Microsoft Office User Specialist. Please take a few moments to familiarize yourself with the icons used in this book and its conventions. If you have questions or comments, visit the related Prentice Hall MOUS Essentials Web site: www.prenhall.com/mousessentials.

Each MOUS Essentials text consists of modular lessons that are built around a series of numbered step-by-step procedures that are clear, concise, and easy to review. Brief explanations are provided at the start of each lesson and, as needed, between steps. Many lessons contain additionalnotes and tips.

A MOUS Essentials book includes 15 to 21 projects, two appendixes and a glossary. Each project covers one area (or a few closely related areas) of application functionality, and is divided into lessons related to that topic. For example, a project on improving the appearance of a worksheet includes lessons on formatting numbers, aligning cell contents, changing font and font size, applying bold and italic, adding color, adding borders, using Format Painter and removing formatting. Each lesson presents a specific task or closely related set of tasks in a manageable chunk that's easy to assimilate and retain.

Each element in a MOUS Essentials title is designed to maximize your learning experience. Here's a list of the MOUS Essentials project elements and a description of how each element can help you:

  • Required MOUS Objectives Table. These tables are organized into three columns: Objective, Required Activity for MOUS, and Exam Level. The objective column lists the general objectives of the project. The associated MOUS requirements for each objective are listed in the Required Activity for MOUS column. The particular exam levels of those activities7#151;Core or Expert—are listed in the Exam Level column. Look over the objectives and MOUS requirements on the opening page of each project before you begin, and review them after completing the project to identify the main goals for each project.
  • Key Terms. This book includes useful vocabulary words and definitions specific to the application. Key terms introduced in each project are listed in alphabetical order on the opening page of the project. These key terms then appear in bold italic within the text and are defined during their first occurrence in the project.
  • Why Would I Do This? You are studying Excel to accomplish useful tasks in the real world. This brief section at the beginning of each project tells you why these tasks or procedures are important. What can you do with the knowledge? How can these application features be applied to everyday tasks?
  • MOUS Core Objective Icon. This icon indicates that a lesson relates to a specific MOUS Core-level skill. MOUS skills may be covered by a whole lesson or perhaps just a single step within a lesson.
  • MOUS Expert Objective Icon. This icon indicates that a lesson relates to a MOUS Expert-level skill. There may be a mix of Core and Expert objectives within a project. Some objectives are both Core and Expert, as well.
  • Lessons. Each lesson contains one or more tasks that correspond to an objective or MOUS requirement, which are listed on the opening page of the project. A lesson consists of step-by-step tutorials, associated screen captures, and the sidebar notes of the types described later. Though each lesson often builds on the previous one, the lessons have been made as modular as possible. For example, you can skip tasks that you've already mastered and begin a later lesson, if you choose.
  • Step-by-Step Tutorial. The lessons consist of numbered, bolded step-by-step instructions that show you how to perform the procedures in a clear, concise, and direct manner. These hands-on tutorials, which are the "essentials" of each project, let you "learn by doing." A short paragraph may appear after a step to clarify the results of the step. Screen captures are provided after key steps so that you can compare the results on your monitor. To review the lesson, you can easily scan the bold, numbered steps.
  • Exam Note. These sidebars provide information and insights on topics covered on MOUS exams. You can easily recognize them by their distinctive icon. It's well worth the effort to review these crucial notes again after completing a project.
  • Inside Stuff. Inside Stuff comments provide extra tips, shortcuts, alternative ways to complete a process, as well as special hints. You may safely ignore these for the moment to focus on the main task at hand, or you may pause to learn and appreciate these tidbits.
  • If You Have Problems... These short troubleshooting notes help you anticipate or solve common problems quickly and effectively. Even if you don't encounter the problem at this time, do make a mental note of it so that you know where to look when you find yourself having difficulties.
  • Summary. This section provides a brief recap of the activities learned in the project. The summary often includes suggestions for expanding your knowledge.
  • Checking Concepts and Terms. This section offers optional true/false and multiple choice questions designed to check your comprehension and assess retention. If you need to refresh your memory, the relevant lesson number is provided after each question. For example, L5 directs you to review Lesson 5 for the answer.
  • Skill Drill. This section enables you to check your comprehension, evaluate your progress, and practice what you've learned. The exercises in this section build on and reinforce what you have teamed in each project. Generally, the Skill Drill exercises include step-by-step instructions. A Core or Expert icon indicates whether a MOUS required activity is introduced in a Skill Drill exercise.
  • Challenge. This section provides exercises that expand on or relate to the skills practiced in the project. Each exercise provides a brief narrative introduction followed by instructions. Although the instructions are written in a step-by-step format, the steps are not as detailed as those in the Skill Drill section. Providing fewer specific steps helps you learn to think on your own.
  • Discovery Zone. These exercises require advanced knowledge of project topics or application of skills from multiple lessons. Additionally, these exercises might require you to research topics in Help or on the Web to complete them. This self-directed method of learning new skills emulates real-world experience. A Core or Expert icon indicates if a MOUS required activity is introduced in a Discovery Zone exercise.
  • Pin Point Assessment. Each project ends with a reminder to use MOUS Pinpoint training and testing software to supplement the projects in the book. The software aids you in your preparation for taking and passing the MOUS exams. A thorough explanation of how to use the Pinpoint software is provided in Appendix A, "Using the MOUS Pinpoint Training and Testing Software."

Typeface Conventions Used in this Book

We have used the following conventions throughout this book so that certain items stand out from the rest of the text:

  • Key terms appear in bold italic the first time they are defined.
  • Monospace type appears frequently. It is used to indicate I ) text that you are instructed to key in, 2) text that appears onscreen as warnings, confirmations, or general information, 3) the name of a file to be used in a lesson or exercise, and 4) text from a dialog box that is referenced within a sentence, when that sentence might appear awkward if the dialog box text were not set off.
  • Hotkeys are indicated by underline. Hotkeys are the underlined letters in menus, toolbars, and dialog boxes that activate commands and options, and are a quick way to choose frequently used commands and options. Hot keys look like this: File, Save.

How To Use Student Data Files on the CD-ROM

The CD-ROM accompanying this book contains Pinpoint as well as all the data files for you to use as you work through the step-by-step tutorials within projects and the Skill Drill, Challenge, and Discovery Zone exercises provided at the end of each project. The CD contains separate parallel folders for each project.

The names of the student data files correspond to the filenames called for in the textbook. Each filename includes six characters—an initial letter indicating the application, a dash, two digits indicating the project number, and two digits indicating the file number within the project. For example, the first file used in Excel Project 2 is named e-0201. The third file in Excel Project 14 is named e-1403. The Word document named e-stufiles.doc on the companion Web site (www.prenhall.com/mousessentials) provides a complete listing of data files by project, including the corresponding names used to save each file.

Please refer to the Readme file on the CD for instruction on how to use the CD-ROM.

Supplements

  • Instructor's Resource CD-ROM—The Instructor's Resource CD-ROM includes the entire Instructor's Manual for each application in Microsoft Word format and also contains screen shots that correspond to the solutions for the lessons in the book. A computerized testbank is included to create tests, maintain student records, and to provide online practice testing. Student data files and completed solution files are also on the CD-ROM. PowerPoint slides, which elaborate on each project, are also included.
  • Companion Web Site (www.prenhall.com/mousessentials)—For both students and instructors, the companion Web site includes all the ancillary material to accompany the MOUS Essentials series. Students can find additional test questions that evaluate their understanding of the key concepts of each application and also instant feedback on their results. Instructors will find the data and solution files, Instructor's Manual, and PowerPoint slides for each application.
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)