Microsoft Office logo

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

Excel 2010

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

    Schedule with Certiport

Skills measured

This exam measures your ability to accomplish the technical tasks listed below. View video tutorials about the variety of question types on Microsoft exams.

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

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

Managing the worksheet environment
  • 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

Preparation resources

Creating cell data
  • 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

Preparation resources

Formatting cells and worksheets
  • 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

Preparation resources

Managing worksheets and workbooks
  • 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

Preparation resources

Applying formulas and functions
  • 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

Preparation resources

Presenting data visually
  • 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

Preparation resources

Sharing worksheet data with other users
  • 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

Preparation resources

Analyzing and organizing data
  • 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 resources

Preparation options

From the community

Follow @MSLearning and @office


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

Preparing for an exam

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.