Microsoft Office Specialist: Excel Exam Preparation 2026

This course is for people preparing for exam MO-210, the Microsoft Office Specialist exam for Excel (Microsoft 365 Apps). Five lessons follow the five skill areas in Microsoft's skills outline, each with a practical exercise you do in Excel. Each lesson has an untimed topic quiz with explanations, and a timed 35-question final assessment unlocks a certificate of completion when you score 80% or more.

课程
加拿大
90道题
核对于2026年10月13日
事实核查：2026年10月13日

快速解答

这门免费课程包括约300分钟的课程、5个不限时的专题测验（共90道题），以及一次随机抽取35道题的限时期末评估。期末评估得分达到80%或以上即可下载结业证书（私人颁发，未经认证）。已于2026年10月13日根据官方资料核对。

从课文开始Microsoft Office Specialist: Excel Exam Preparation: Lessons：阅读时间约300分钟。测试中的每道题在课文中都有讲解。

你将学到什么

Describe the MO-210 exam format, timing, scoring and five skill areas
Import data, navigate workbooks, and set views, print settings, headers and footers
Prepare a workbook for sharing with the right file format, the Document Inspector, comments and notes
Fill and format cells with Paste Special, Auto Fill, SEQUENCE, named ranges, sparklines and conditional formatting
Create, change, sort and filter Excel tables with a total row
Write formulas with relative, absolute, mixed and structured references and the functions on the skills list
Create and format charts and chart sheets, including alt text

得分达到80%或以上即可下载证书。

你的学习计划

阅读每一课，完成对应的专题测验（不限时，有解释），然后参加限时的期末评估。每次都会抽取新的题目组合。你的进度保存在此浏览器中。

专题测验1：Manage worksheets and workbooks

考前须知

Passing exam MO-210: Microsoft Excel (Microsoft 365 Apps) earns the Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) certification.
Microsoft lists five skill areas: manage worksheets and workbooks (25–30%), manage data cells and ranges (25–30%), manage tables and table data (10–15%), formulas and functions (15–20%) and charts (15–20%).
You have 50 minutes to complete the exam. Certiport lists 33–37 questions for the Excel exam, and the time covers the timed portion only, not check-in and the tutorial.
Certiport describes Microsoft Office Specialist exams as performance-based, with hands-on, live-in-the-application testing.
Certiport reports scores on a 1–1000 scale, and the passing value is always equated to 700.
If you do not pass, you must wait 24 hours before a second attempt, then 2 days (48 hours) before each later retake.
Microsoft suggests candidates have about 150 hours of instruction and hands-on experience with Excel.

常见问题

Is this the official MO-210 exam?

No. This is an independent practice course with original questions. The real exam is taken in Excel itself, proctored, and booked through Certiport.

What does the certificate of completion show?

It shows that you finished this course and scored at least 80% on its final assessment. It is not the Microsoft Office Specialist certification and is not issued by Microsoft or Certiport.

How is the real exam scored?

Certiport reports scores on a scale of 1 to 1000, and the passing value is always equated to 700. Your score report shows the passing score for your exam.

How long is the real exam?

Microsoft gives 50 minutes for the exam, and Certiport lists 33–37 questions for Excel. Plan extra time at the test centre for check-in and the tutorial.

How is this course different from the general Excel courses?

It follows the MO-210 skills outline closely, including printing, sharing, tables and charts, and uses the exam's own skill areas as its topics. The final assessment is 35 questions in 50 minutes to match the exam's pace.

Can my practice score predict my exam result?

No. The real exam is hands-on and scaled, so practice scores here are feedback only. Practise each task in Excel until you can do it quickly.

这份证书是否经过认证或获得官方认可？

不是。这是一份私人颁发的结业证书，仅用于知识学习。它未获得任何政府、执照发放机构、监管机构或教育机构的认可、认证或批准，也不能替代法律要求的任何执照、资格证书或培训。