MS Excel Certification Practice Test

In today’s competitive job market, passing the Microsoft Excel Certification can be the difference between getting a job offer and waiting for the phone to ring. Nearly every position in every industry uses Microsoft Excel to track figures, calculate data, or review performance.

When you earn a Microsoft Office Specialist Associate or Expert certification in Excel, you instantly become a more attractive candidate, and if you already have a job, you open new doors toward promotions. Hiring managers trust Microsoft exams and certifications because they know you can contribute to the team immediately.

Did you know?

The Excel Certification Tests provide two different certifications: (1) basic/intermediate and (2) expert. Passing scores on each test vary, but it is approximately 70%. To be successful, you must display your Excel abilities across a number of different tasks during an interactive simulation.

You can get either an Intermediate or Expert certification in Excel 2016, Excel 2019, or Microsoft 365 Excel App. The certificates are cumulative; you must first pass a basic test before being eligible to take the Intermediate certification, and you must have Intermediate certification before taking the Expert certification exam.

Preparing for the test is your best bet for success. Even if you’ve used Excel every day for the last decade, test prep courses will remind you of features and formulas that you haven’t needed in years.

So practice. And take the test. Because the best part of your career is still to come.

Excel Navigation Pad

Results scale & interpretations

Frequently asked questions

iPREP provides a top-notch preparation course for all the levels of MOS Excel certification. This is an affordable alternative, comparable to any other online course. The course includes full-length certification test simulations that strictly follow the MOS curriculum and in the same interactive format as the MOS certification test. Check the curriculum tab for more details.

Test Features

The Microsoft Excel Certification test is an interactive test. You’ll be given 25-35 questions from several different domains which need to be completed in 50 minutes.

The test is administered in a computer lab at an authorized Certiport testing center. Results of the test are available immediately following completion of the test.

The questions on each test are unique, so if you are taking the test for a second (or third time) you can expect to see different questions each time.

The following table details the domains involved in each Microsoft Excel Certification test.

After completing each project, you’ll click submit, and start the next project. You can go back and make changes to projects that have been submitted until you finish the exam or run out of time. Once you select Finish Exam you can no longer make any changes.

Before taking the test, you must show a photo ID. You may not bring pens, pencils, cameras, phones, laptops, or any type of recording or communication device into the testing room.

There is a fee to take the test, which may change in different locations. In the United States, the test costs $100. Retakes of the test also cost $100.

Passing the Certification Exams

In the next section, you’ll read about the different parts of the Microsoft 365, 2019, and 2016 Excel certification tests. You should expect the projects in the certification test to cover many of the elements listed below. Success on the certification test depends largely on your ability to use the software correctly.

If you are currently in a work environment that uses Excel 2016 or Excel 2019, taking the corresponding certification courses makes sense. However, if you are a student or attempting to enter the job market, we recommend obtaining the continuously updated Microsoft 365 apps Excel certification.

All the test versions share similarities; however, the Microsoft 365 Excel certification is the most up-to-date, encompassing all recent Excel features, including testing on features that are foundational for modern Microsoft 365 Excel work, such as working in shared cloud environments. The Excel 2019 certification focuses more on managing workflows and information, while the Excel 2016 certification emphasizes the creation of various Excel elements more significantly.

Microsoft 365 Excel Associate Certification Test (MO-210)

The Microsoft 365 Excel Associate certification test challenges test takers to complete projects that cover the following areas:

• Manage worksheets and workbooks (25–30%)
  • Import data into workbooks
  • Navigate within workbooks
  • Format worksheets and workbooks
  • Prepare workbooks for collaboration and distribution
  • Manipulate data in worksheets
  • Format cells and ranges
  • Define and reference named ranges
  • Summarize data visually
  • Create and format tables
  • Modify tables
  • Filter and sort table data
  • Insert references
  • Calculate and transform data
  • Format and modify text
  • Create charts
  • Modify charts
  • Format charts

  Microsoft 365 Excel Expert Certification Test (MO-211)

  The Microsoft 365 Excel Expert certification test challenges test takers to complete projects that cover the following areas:

  • Manage workbook options and settings (10–15%)
    • Manage workbooks
    • Prepare workbooks for collaboration
    • Fill cells based on existing data
    • Format and validate data
    • Apply advanced conditional formatting and filtering
    • Perform logical operations in formulas
    • Look up data by using functions
    • Use advanced date and time functions
    • Perform data analysis
    • Troubleshoot formulas
    • Create and modify simple macros
    • Create and modify advanced charts
    • Create and modify PivotTables
    • Create and modify PivotCharts

    2019 Excel Intermediate Certification Test (MO-200)

    The 2019 Excel intermediate test challenges test takers to complete projects that cover the following areas:

    • Manage worksheets and workbooks
      • Import data into workbooks
      • Navigate within workbooks
      • Format worksheets and workbooks
      • Customize options and views
      • Configure content for collaboration
      • Manipulate data in worksheets
      • Format cells and ranges
      • Define and reference named ranges
      • Summarize data visually
      • Create and format tables
      • Modify tables
      • Filter and sort table data
      • Insert references
      • Calculate and transform data
      • Format and modify text
      • Create charts
      • Modify charts
      • Format charts

      2019 Excel Expert Certification Test (MO-201)

      The 2019 Excel expert test challenges test takers to complete projects that cover the following areas:

      • Manage workbook options and settings
        • Manage workbooks
        • Prepare workbooks for collaboration
        • Use and configure language options
        • Fill cells based on existing data
        • Format and validate data
        • Apply advanced conditional formatting and filtering
        • Perform logical operations in formulas
        • Look up data by using functions
        • Use advanced date and time functions
        • Perform data analysis
        • Troubleshoot formulas
        • Create and modify simple macros
        • Create and modify advanced charts
        • Create and modify PivotTables
        • Create and modify PivotCharts

        2016 Excel Intermediate Certification Test (Exam 77-727)

        The 2016 Excel intermediate test challenges test takers to complete projects that cover the following areas:

        • Create and manage worksheets and workbooks
          • Create worksheets and workbooks
          • Navigate in worksheets and workbooks
          • Format worksheets and workbooks
          • Customize options and views for worksheets and workbooks
          • Configure worksheets and workbooks for distribution
          • Insert data in cells and ranges
          • Format cells and ranges
          • Summarize and organize data
          • Create and manage tables
          • Manage table styles and options
          • Filter and sort a table
          • Summarize data by using a function
          • Perform conditional operations by using functions
          • Format and modify text by using functions
          • Create charts
          • Format charts
          • Insert and format objects

          2016 Excel Expert Certification Test (Exam 77-728)

          The 2016 Excel expert test challenges test takers to complete projects that cover the following areas:

          • Manage workbook options and settings
            • Manage workbooks
            • Manage workbook review
            • Apply custom data formats and validation
            • Apply advanced conditional formatting and filtering
            • Create and modify custom workbook elements
            • Prepare a workbook for internationalization
            • Apply functions in formulas
            • Look up data by using functions
            • Apply advanced date and time functions
            • Perform data analysis and business intelligence
            • Troubleshoot formulas
            • Define named ranges and objects
            • Create advanced charts
            • Create and manage PivotTables
            • Create and Manage PivotCharts

            iPREP: Concise. Focused. What you need.