Excel Formulas and Data Analysis Course：结业考试 2026

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

本模拟考试的规则

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

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

Make decisions in formulas with IF, IFS, AND, OR and NOT
Add, count and average data that meets several conditions with SUMIFS, COUNTIFS and AVERAGEIFS
Look up values with XLOOKUP, VLOOKUP and INDEX/MATCH, and handle missing values with IFERROR and IFNA
Split, clean and join text, and calculate with dates and working days
Highlight data with conditional formatting, control entries with data validation and remove duplicates safely
Summarize data with PivotTables and choose charts that answer a business question

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