Exam 77-882

Excel 2010

Microsoft Office Specialist exams are provided by a third-party vendor. Register for an exam at Certiport's website.

Schedule now

Microsoft Office logo
  • Published: June 30, 2010
  • Languages: English
  • Audiences: Information workers
  • Technology: Microsoft Office 2010 suites
  • Credit toward certification: Microsoft Office Specialist

Convince your boss email

Copy the following content into an email message to your boss and update [the bracketed text] with the appropriate content.

Dear [your boss's name]:

I'd like to expand and prove my technical skills by earning a Microsoft Certification. My next step is taking Exam 77-882. The registration fee is {GET PRICE FROM EXAM PROVIDER}.

When I pass this certification, you'll have proof of my ability to work with Microsoft Office 2010 suites. Microsoft has training and online resources to help me prepare for the exam. I believe I'll be more effective and productive after achieving this valuable technical certification.

Let me know if you have any questions. In the meantime, you can find out more about this exam at http://www.microsoft.com/learning/en-us/exam-77-882.aspx. As you can see, the exam validates skills that are crucial to our team's success.

Thank you for your support,

[your name]

Skills measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

  • Navigate through a worksheet

    • Hot keys, name box

  • Print a worksheet or workbook

    • Printing only selected worksheets; printing an entire workbook; constructing headers and footers; applying printing options (scale, print titles, page setup, print area, gridlines)

  • Personalize environment by using Backstage

    • Manipulating the Quick Access toolbar; manipulating the ribbon tabs and groups; manipulating Excel default settings; importing data to Excel; importing data from Excel; demonstrating how to manipulate workbook properties; manipulating workbook files and folders; applying different name and file formats for different uses by using Save and Save As features

  • Construct cell data

    • Using paste special (formats, formulas, values, preview icons, transpose rows and columns, operations, comments, validation, paste as a link); cutting, moving, and selecting cell data

  • Apply AutoFill

    • Copying data using AutoFill; filling series using AutoFill; copying or preserving cell format with AutoFill; selecting from drop-down list

  • Apply and manipulate hyperlinks

    • Creating a hyperlink in a cell; modifying hyperlinks; modifying hyperlinked-cell attributes; removing a hyperlink

  • Apply and modify cell formats

    • Aligning cell content; applying a number format; wrapping text in a cell; using Format Painter

  • Merge or split cells

    • Using Merge & Center, Merge Across, Merge Cells, and Unmerge Cells

  • Create row and column titles

    • Printing row and column headings; printing rows to repeat with titles; printing columns to repeat with titles; configuring titles to print only on odd or even pages; configuring titles to skip the first worksheet page

  • Hide and unhide rows and columns

    • Hiding a column; unhiding a column; hiding a series of columns; hiding a row; unhiding a row; hiding a series of rows

  • Manipulate page setup options for worksheets

    • Configuring page orientation; managing page scaling; configuring page margins; changing header and footer size

  • Create and apply cell styles

    • Applying cell styles; constructing new cell styles

  • Create and format worksheets

    • Inserting worksheets; deleting worksheets; copying, repositioning, copying and moving, renaming, grouping; applying coloring to worksheet tabs; hiding worksheet tabs; unhiding worksheet tabs

  • Manipulate window views

    • Splitting window views; arranging window views; opening a new window with contents from the current worksheet

  • Manipulate workbook views

    • Using Normal, Page Layout, and Page Break workbook views; creating custom views

  • Create formulas

    • Using basic operators; revising formulas

  • Enforce precedence

    • Order of evaluation, precedence using parentheses, precedence of operators for percent vs. exponentiation

  • Apply cell references in formulas

    • Relative, absolute

  • Apply conditional logic in a formula

    • Creating a formula with values that match your conditions; editing defined conditions in a formula; using a series of conditional logic values in a formula

  • Apply named ranges in formulas

    • Defining, editing, and renaming a named range

  • Apply cell ranges in formulas

    • Entering a cell range definition in the formula bar; defining a cell range using the mouse; defining a cell range using a keyboard shortcut

  • Create charts based on worksheet data

  • Apply and manipulate illustrations

    • Clip Art, SmartArt, shapes, screenshots

  • Create and modify images by using the Image Editor

    • Making corrections to an image (sharpening or softening an image, changing brightness and contrast); using picture color tools; changing artistic effects on an image

  • Apply Sparklines

    • Using Line, Column, and Win/Loss chart types; creating a Sparkline chart; customizing a Sparkline; formatting a Sparkline; showing or hiding data markers

  • Share spreadsheets by using Backstage

    • Sending a worksheet via email or OneDrive; changing the file type to a different version of Excel; saving as PDF or XPS

  • Manage comments

    • Inserting, viewing, editing, and deleting comments

  • Filter data

    • Defining, applying, removing, searching, filtering lists using AutoFilter

  • Sort data

    • Using sort options (values, font color, cell color)

  • Apply conditional formatting

    • Applying conditional formatting to cells; using the Rule Manager to apply conditional formats; using the IF Function and Apply Conditional Formatting, icon sets, data bars, clear rules

Preparation options

Buy a practice test for Exam 77-882 from:

Cover of 'MOS 2010 Study Guide for Microsoft Word, Excel, PowerPoint, and Outlook'

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

Published: March 2011

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. 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.

Buy this book at the Microsoft Press Store

Who should take this exam?

The core-level Microsoft Office Excel 2010 user should be able to navigate Microsoft Office Excel 2010 software at the feature and functional level. They should be familiar with and know how to use at least 80 percent of the features and capabilities of Microsoft Office Excel 2010. The core-level user should be able to use Microsoft Office Excel 2010 to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life.

More information about exams

We recommend that you review this exam preparation guide in its entirety and familiarize yourself with the resources on this website before you schedule your exam. See the Microsoft Certification exam overview for information about registration, videos of typical exam question formats, and other preparation resources. For information on exam policies and scoring, see the Microsoft Certification exam policies and FAQs.

This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format. To help you prepare for this exam, Microsoft recommends that you have hands-on experience with the product and that you use the specified training resources. These training resources do not necessarily cover all of the topics listed in the "Skills measured" section.