Summer Reading B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Lists | July 16, 2015

    Annie Liontas: IMG "You Want Me to Smell My Fingers?": Five Unforgettable Greek Idioms



    The word "idiom" originates in the Greek word ídios ("one's own") and means "special feature" or "special phrasing." Idioms are peculiar because,... Continue »
    1. $18.20 Sale Hardcover add to wish list

      Let Me Explain You

      Annie Liontas 9781476789088

    spacer
Qualifying orders ship free.
$44.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
9 Remote Warehouse Computer Certification- MCSE
15 Remote Warehouse Computers Reference- General

Mos 2010 Study Guide for Microsoft Word, Excel, PowerPoint, and Outlook

by

Mos 2010 Study Guide for Microsoft Word, Excel, PowerPoint, and Outlook Cover

 

Synopses & Reviews

Publisher Comments:

'

Demonstrate your expertise with the 2007 Microsoft Office system! This comprehensive study guide covers all the Microsoft Certified Application Specialist exams for Microsoft Office, including Word 2007, Excel 2007, Outlook 2007, PowerPoint 2007, and Access 2007. For each exam, youll build the skills and knowledge measured by its objectives through a series of step-by-step exercises, practice questions, and real-world scenarios. Easy-to-follow screen shots and explanations bring key concepts to life and expertly guide you through the material. The CD includes the practice files for all the book\'s lessons. Youll even get a voucher for a practice pre-test. Earn the premier credential and showcase your expertise in the popular Microsoft Office programs!

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

'

Synopsis:

Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams.

With the MOS 2010 Study Guide, you get full, objective-by-objective coverage for:

  • Exam 77-881: Microsoft Word 2010
  • Exam 77-882: Microsoft Excel 2010
  • Exam 77-883: Microsoft PowerPoint 2010
  • Exam 77-884: Microsoft Outlook 2010
Use the book’s easy-to-follow procedures and illustrations to review the essential skills measured by the MOS exams. And you can apply what you’ve learned hands-on—using the downloadable files for all the book’s practice tasks.

About the Author

Joan Lambert is the author of more than a dozen books about Microsoft Office and Windows, including several popular Step by Step titles from Microsoft Press. Joyce Cox has 20+ years’ experience developing training materials on technical subjects for non-technical audiences, including dozens of books about Office and Windows.

Table of Contents

'
Taking a Microsoft Certified Application Specialist Exam; The Microsoft Business Certification Program; Selecting a Certification Path; Test-Taking Tips; Certification Benefits; For More Information; Using This Book to Study for a Certification Exam; Features and Conventions of This Book; Additional Resources; Working in the Microsoft Office Fluent User Interface; Using the Companion CD; CD Contents; Minimum System Requirements; Installing the Practice Files; Using the Practice Files; Removing and Uninstalling the Practice Files; Getting Help; Getting Help with This Book and Its Companion CD; Getting Help with an Office Program; More Information; Part 77-601: Using Microsoft Office Word 2007; Chapter 1: Creating and Customizing Documents; 1.1 Create and format documents; 1.2 Lay out documents; 1.3 Make documents and content easier to find; 1.4 Personalize Word 2007; Objective Review; Chapter 2: Formatting Content; 2.1 Format text and paragraphs; 2.2 Manipulate text; 2.3 Control pagination; Objective Review; Chapter 3: Working with Visual Content; 3.1 Insert illustrations; 3.2 Format illustrations; 3.3 Format text graphically; 3.4 Insert and modify text boxes; Objective Review; Chapter 4: Organizing Content; 4.1 Structure content by using Quick Parts; 4.2 Use tables and lists to organize content; 4.3 Modify tables; 4.4 Insert and format references and captions; 4.5 Merge documents and data sources; Objective Review; Chapter 5: Reviewing Documents; 5.1 Navigate documents; 5.2 Compare and merge document versions; 5.3 Manage tracked changes; 5.4 Insert, modify, and delete comments; Objective Review; Chapter 6: Sharing and Securing Content; 6.1 Prepare documents for sharing; 6.2 Control document access; 6.3 Attach digital signatures; Objective Review; Part 77-602: Using Microsoft Office Excel 2007; Chapter 1: Creating and Manipulating Data; 1.1 Insert data by using Auto Fill; 1.2 Ensure data integrity; 1.3 Modify cell contents and formats; 1.4 Change worksheet views; 1.5 Manage worksheets; Objective Review; Chapter 2: Formatting Data and Content; 2.1 Format worksheets; 2.2 Insert and modify rows and columns; 2.3 Format cells and cell content; 2.4 Format data as a table; Objective Review; Chapter 3: Creating and Modifying Formulas; 3.1 Reference data in formulas; 3.2 Summarize data by using a formula; 3.3 Summarize data by using subtotals; 3.4 Conditionally summarize data by using a formula; 3.5 Look up data by using a formula; 3.6 Use conditional logic in a formula; 3.7 Format or modify text by using formulas; 3.8 Display and print formulas; Objective Review; Chapter 4: Presenting Data Visually; 4.1 Create and format charts; 4.2 Modify charts; 4.3 Apply conditional formatting; 4.4 Insert and modify illustrations; 4.5 Outline data; 4.6 Sort and filter data; Objective Review; Chapter 5: Collaborating and Securing Data; 5.1 Manage changes to workbooks; 5.2 Protect and share workbooks; 5.3 Prepare workbooks for distribution; 5.4 Save workbooks; 5.5 Set print options for printing data, worksheets, and workbooks; Objective Review; Part 77-603: Using Microsoft Office PowerPoint 2007; Chapter 1: Creating and Formatting Presentations; 1.1 Create new presentations; 1.2 Customize slide masters; 1.3 Add elements to slide masters; 1.4 Create and change presentation elements; 1.5 Arrange slides; Objective Review; Chapter 2: Creating and Formatting Slide Content; 2.1 Insert and format text boxes; 2.2 Manipulate text; 2.3 Add and link existing content to presentations; 2.4 Apply, customize, modify, and remove animations; Objective Review; Chapter 3: Working with Visual Content; 3.1 Create SmartArt diagrams; 3.2 Modify SmartArt diagrams; 3.3 Insert illustrations and shapes; 3.4 Modify illustrations; 3.5 Arrange illustrations and other content; 3.6 Insert and modify charts; 3.7 Insert and modify tables; Objective Review; Chapter 4: Collaborating On and Delivering Presentations; 4.1 Review presentations; 4.2 Protect presentations; 4.3 Secure and share presentations; 4.4 Prepare printed materials; 4.5 Prepare for and rehearse presentation delivery; Objective Review; Part 77-604: Using Microsoft Office Outlook 2007; Chapter 1: Managing Messages; 1.1 Create and send an e-mail message; 1.2 Create and manage your signature and automated messages; 1.3 Manage e-mail message attachments; 1.4 Configure e-mail message sensitivity and importance settings; 1.5 Configure e-mail message security settings; 1.6 Configure e-mail message delivery options; 1.7 View e-mail messages; Objjjjjjective Review; Chapter 2: Managing Scheduling; 2.1 Create appointments, meetings, and events; 2.2 Send meeting requests; 2.3 Update, cancel, and respond to meeting requests; 2.4 Customize calendar settings; 2.5 Share your calendar with other people; 2.6 View other calendars; Objective Review; Chapter 3: Managing Tasks; 3.1 Create and modify tasks, and mark tasks as complete; 3.2 Accept, decline, assign, update, and respond to tasks; Objective Review; Chapter 4: Managing Contacts and Personal Contact Information; 4.1 Create and modify contacts; 4.2 Edit and use an electronic business card; 4.3 Create and modify distribution lists; 4.4 Create a secondary address book; Objective Review; Chapter 5: Organizing Information; 5.1 Categorize Outlook 2007 items by color; 5.2 Create and manage Outlook 2007 data files; 5.3 Organize mail folders; 5.4 Locate Outlook 2007 items by using the search feature; 5.5 Create, modify, and remove rules to manage e-mail messages; 5.6 Customize your Outlook 2007 experience; Objective Review; Part 77-605: Using Microsoft Office Access 2007; Chapter 1: Structuring a Database; 1.1 Define data needs and types; 1.2 Define and print table relationships; 1.3 Add, set, change, or remove primary keys; 1.4 Split databases; Objective Review; Chapter 2: Creating and Formatting Database Elements; 2.1 Create databases; 2.2 Create tables; 2.3 Modify tables; 2.4 Create fields and modify field properties; 2.5 Create forms; 2.6 Create reports; 2.7 Modify the design of reports and forms; Objective Review; Chapter 3: Entering and Modifying Data; 3.1 Enter, edit, and delete records; 3.2 Navigate among records; 3.3 Find and replace data; 3.4 Attach documents to and detach from records; 3.5 Import data; Objective Review; Chapter 4: Creating and Modifying Queries; 4.1 Create queries; 4.2 Modify queries; Objective Review; Chapter 5: Presenting and Sharing Data; 5.1 Sort data; 5.2 Filter data; 5.3 Create and modify charts; 5.4 Export data; 5.5 Save database objects as other file types; 5.6 Print database objects; Objective Review; Chapter 6: Managing and Maintaining Databases; 6.1 Perform routine database operations; 6.2 Manage databases; Objective Review; Appendix : About the Authors; The Team; Online Training Solutions, Inc. (OTSI); Appendix : Choose the Right Book for You;
\n

'

Product Details

ISBN:
9780735648753
Author:
Lambert, Joan
Publisher:
Microsoft Press
Author:
Cox, Joyce
Subject:
Technical Skills
Subject:
Computers-Reference - General
Subject:
77-881, 77-882, 77-883, 77-884, MOS, Microsoft Office Specialist, Microsoft certification, Office certification
Subject:
Computer Certification-MCSE
Edition Description:
2007 ed.
Series:
MOS Study Guide
Publication Date:
20110331
Binding:
TRADE PAPER
Language:
English
Pages:
736
Dimensions:
9 x 7.38 in

Other books you might like

  1. Microsoft Outlook 2010 Step by Step Used Trade Paper $14.00

Related Subjects

Computers and Internet » Computer Certification » Microsoft » MCSE
Computers and Internet » Computer Certification » Microsoft » MOS
Computers and Internet » Computers Reference » General
Computers and Internet » Networking » General
Computers and Internet » Personal Computers » Desktop Applications » Suites
Computers and Internet » Personal Computers » Desktop Applications » Word Processing

Mos 2010 Study Guide for Microsoft Word, Excel, PowerPoint, and Outlook New Trade Paper
0 stars - 0 reviews
$44.99 In Stock
Product details 736 pages Microsoft Press - English 9780735648753 Reviews:
"Synopsis" by , Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams.

With the MOS 2010 Study Guide, you get full, objective-by-objective coverage for:

  • Exam 77-881: Microsoft Word 2010
  • Exam 77-882: Microsoft Excel 2010
  • Exam 77-883: Microsoft PowerPoint 2010
  • Exam 77-884: Microsoft Outlook 2010
Use the book’s easy-to-follow procedures and illustrations to review the essential skills measured by the MOS exams. And you can apply what you’ve learned hands-on—using the downloadable files for all the book’s practice tasks.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.