Microsoft Office Specialist: Excel Exam Preparation：结业考试 2026

每次从课程中随机抽取一套新的35道题。得分达到80%或以上即可下载证书。答案将在最后显示。

本模拟考试的规则

每次作答都会从本测试全部 90 道题中随机抽取 35 道题，因此每次都不一样。

官方考试包括以下部分：

Manage worksheets and workbooks (25–30%)
Manage data cells and ranges (25–30%)
Manage tables and table data (10–15%)
Perform operations by using formulas and functions (15–20%)
Manage charts (15–20%)

结束后可以看到得分、每道题的答案和解析。最好成绩会保存在此浏览器中，你可以反复练习，直到稳妥通过。

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%或以上即可下载证书。