Search test library by skills or roles
⌘ K

About the test:

The Excel test uses scenario-based MCQ questions to evaluate a candidate's ability to work with large datasets in Excel, navigate multiple spreadsheets, use advanced formulas and create reports. The test screens for the ability to sort/filter data, analyze data using PivotTables, create dashboards using charts, provide forms for user inputs, and record/ modify/ write macros.

Covered skills:

  • Basic formulas (MATCH; INDEX)
  • Advanced formulas (IF; VLOOKUP; HLOOKUP)
  • Math formulas (SUM; MIN; AVG)
  • Data types
See all covered skills

9 reasons why
9 reasons why

Adaface Excel Test is the most accurate way to shortlist Data Analysts



Reason #1

Tests for on-the-job skills

Microsoft Excel在线评估测试由行业专家设计和验证,以帮助招聘人员和雇用经理评估候选人的Excel技能。

Excel测试筛选候选人的招聘经理在候选人中寻找的以下技能:

  • 诸如总和,索引,ifError vs if + iseror,间接和偏移等公式的使用情况
  • 使用与匹配的Vookup这样的查找公式
  • 细胞和范围对象的高级用法
  • 使用枢轴表和枢轴图表利用数据
  • 添加过滤器以报告菜单以缩小记录
  • 使用Excel功能创建强大的计算
  • 使用相对,绝对和混合参考
  • 使用分类,小计和过滤等数据工具
  • 使用图表和图表表示表格数据
  • 数据清理和转换(删除重复项,换台,冻结)
  • 与宏自动化
  • 处理错误
  • 3-DATA合并
  • 数据清洁的组合技术
Reason #2

No trick questions

Traditional assessment tools use trick questions and puzzles for the screening, which creates a lot of frustration among candidates about having to go through irrelevant screening assessments.

The main reason we started Adaface is that traditional pre-employment assessment platforms are not a fair way for companies to evaluate candidates. At Adaface, our mission is to help companies find great candidates by assessing on-the-job skills required for a role.

Why we started Adaface ->
Reason #3

Non-googleable questions

We have a very high focus on the quality of questions that test for on-the-job skills. Every question is non-googleable and we have a very high bar for the level of subject matter experts we onboard to create these questions. We have crawlers to check if any of the questions are leaked online. If/ when a question gets leaked, we get an alert. We change the question for you & let you know.

These are just a small sample from our library of 10,000+ questions. The actual questions on this Excel Test will be non-googleable.

🧐 Question

Medium

MATCH INDEX LOOKUP
Solve
Some friends live in adjacent apartments in a building in Central Perk, New York. We want to write a function to search the apartment number by name. Which of the following functions should we use?
 image

Medium

Organization data
Data transformation
Solve
We have two Excel files with organization data. One file has Organization ID and Organization Name fields, whereas the second file has Organization ID, Organization Name and Country fields. We wrote a query to retrieve the data from both files. Here’s a sample of the data retrieved:
 image
We want to ensure Organization ID field is unique. Which of the following is the ideal solution that ensures Organization ID field is unique while retaining Country data?

A: Select the Organization ID and Country columns, and then click Keep Duplicates.
B: Select the Organization ID and Country columns, and then click Remove Duplicates.
C: Use Group BY function to group the rows by Organization ID. Specify output columns for Organization Name and Country using MAX operation.
D: Select Organization ID column and then click Remove Duplicates. Then specify output columns for Country using MAX operation.

Medium

Student scores
Data formatting
Solve
Here’s a sample Excel data source:
 image
Here’s the expected data format: 
 image
Which of the following is the correct way to transform the data from the query editor to achieve the result?

A: Columns to Select: Student Only
B: Columns to Select: Student and Student ID
C: Columns to Select: Primary and Secondary
D: Command to Use: Pivot Column
E: Command to Use: Reverse Rows
F: Command to Use: Unpivot Columns

Medium

VLOOKUP blood donor
Solve
We are looking to find the contact number of the only blood donor with blood group O-. Which function should we use to look up the correct contact number? Here's the documentation for VLOOKUP: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).
 image
A: =VLOOKUP("O-", A1:E10, 3, TRUE)
B: =VLOOKUP("O-", A1:E10, 3, FALSE)
C: =VLOOKUP("O-", D1:D10, 4)
D: =VLOOKUP("O-", D1:D10, 3)
E: =VLOOKUP("O-", A1:E10, 4, TRUE)
F: =VLOOKUP("O-", A1:E10, 4, FALSE)
G: =VLOOKUP("Kane", A1:E10, 4)
🧐 Question🔧 Skill

Medium

MATCH INDEX LOOKUP
2 mins
Excel
Solve

Medium

Organization data
Data transformation
3 mins
Excel
Solve

Medium

Student scores
Data formatting
2 mins
Excel
Solve

Medium

VLOOKUP blood donor
2 mins
Excel
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
MATCH INDEX LOOKUP
Excel
Medium2 mins
Solve
Organization data
Data transformation
Excel
Medium3 mins
Solve
Student scores
Data formatting
Excel
Medium2 mins
Solve
VLOOKUP blood donor
Excel
Medium2 mins
Solve
Reason #4

1200+ customers in 75 countries

Brandon

With Adaface, we were able to optimise our initial screening process by upwards of 75%, freeing up precious time for both hiring managers and our talent acquisition team alike!


Brandon Lee, Head of People, Love, Bonito

Reason #5

Designed for elimination, not selection

The most important thing while implementing the pre-employment Excel Test in your hiring process is that it is an elimination tool, not a selection tool. In other words: you want to use the test to eliminate the candidates who do poorly on the test, not to select the candidates who come out at the top. While they are super valuable, pre-employment tests do not paint the entire picture of a candidate’s abilities, knowledge, and motivations. Multiple easy questions are more predictive of a candidate's ability than fewer hard questions. Harder questions are often "trick" based questions, which do not provide any meaningful signal about the candidate's skillset.

Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the Excel Test from your dashboard by entering their email address.

Public link: You can create a public link for each test that you can share with candidates.

API or integrations: You can invite candidates directly from your ATS by using our pre-built integrations with popular ATS systems or building a custom integration with your in-house ATS.

Reason #7

Detailed scorecards & comparative results

Reason #8

High completion rate

Adaface tests are conversational, low-stress, and take just 25-40 mins to complete.

This is why Adaface has the highest test-completion rate (86%), which is more than 2x better than traditional assessments.

Reason #9

Advanced Proctoring


如何评估高级Excel技能

这些问题将基于Advanced Excel主题:

  • 关于计算自动总和,计数,百分比和生成分组数据标题的枢轴表技巧
  • 使用变量类型:常数,静态,模块级,公共,私人,“选项私有模块”等
  • 搜索具有高级模式匹配和比较的单元格和字符串,例如操作员和仪器功能
  • 建立预测的损益表,资产负债表和现金流量
  • 使用日期和时间数学函数来计算持续时间,长度和间隔
  • 使用工作表和表单控件触发宏(按钮,形状,下拉列表,列表框,单击操作)
  • 使用BYREF和BYVAL方法将数据从一个宏发送到另一个宏
  • 预测和干扰的统计功能
  • 创建自定义功能
  • 连接到外部数据
  • 创建财务模型
  • 编程修改工作表
  • 随机数生成器

What roles can I use the Excel Test for?

  • Data Analyst
  • Senior Data Analyst
  • Data Entry (Excel)
  • Business Analyst
  • Accountant
  • Financial Analyst
  • Senior Financial Analyst

What topics are covered in the Excel Test?

数据类型
基本公式(匹配;索引)
数学公式(总和; min; avg; sumifs)
高级公式(如果; vlookup; hlookup)
Analyzing data (Pivots; Filters;)
可视化数据(图表;图)
枢轴图表和表格
查找和参考
条件格式
数据摘要
数据操纵
与日期和时间合作
错误处理
插入和格式表
闪光和数据栏
3-DATA合并
与宏自动化
3-DATA合并
基于公式的条件格式
形式和动作
Singapore government logo

The hiring managers felt that through the technical questions that they asked during the panel interviews, they were able to tell which candidates had better scores, and differentiated with those who did not score as well. They are highly satisfied with the quality of candidates shortlisted with the Adaface screening.


85%
reduction in screening time

Excel Test FAQs

我可以在同一测试中评估Excel和SQL技能吗?

是的。我们支持在同一测试中评估多种技能。您可以查看我们的[SQL Test](https://www.adaface.com/assessment-test/sql-online-test),以了解将使用哪种问题来评估SQL。

我可以将多个技能结合在一起,为一个自定义评估吗?

是的,一点没错。自定义评估是根据您的职位描述进行的,并将包括有关您指定的所有必备技能的问题。

您是否有任何反交换或策略功能?

我们具有以下反交易功能:

  • 不可解决的问题
  • IP策略
  • Web Protoring
  • 网络摄像头Proctoring
  • 窃检测
  • 安全浏览器

阅读有关[Proctoring功能](https://www.adaface.com/proctoring)的更多信息。

如何解释考试成绩?

要记住的主要问题是评估是消除工具,而不是选择工具。优化了技能评估,以帮助您消除在技术上没有资格担任该角色的候选人,它没有进行优化以帮助您找到该角色的最佳候选人。因此,使用评估的理想方法是确定阈值分数(通常为55%,我们为您提供基准测试),并邀请所有在下一轮面试中得分高于门槛的候选人。

我可以使用该测试的经验水平?

每个ADAFACE评估都是为您的职位描述/理想候选角色定制的(我们的主题专家将从我们的10000多个问题的图书馆中选择正确的问题)。可以为任何经验级别定制此评估。

每个候选人都会得到同样的问题吗?

是的,这使您比较候选人变得容易得多。 MCQ问题的选项和问题顺序是随机的。我们有[抗欺骗/策略](https://www.adaface.com/proctoring)功能。在我们的企业计划中,我们还可以选择使用类似难度级别的问题创建多个版本的相同评估。

我是候选人。我可以尝试练习测试吗?

不,不幸的是,我们目前不支持实践测试。但是,您可以使用我们的[示例问题](https://www.adaface.com/questions)进行练习。

使用此测试的成本是多少?

您可以查看我们的[定价计划](https://www.adaface.com/pricing/)。

我可以免费试用吗?

我刚刚搬到了一个付费计划。我如何要求自定义评估?

Join 1200+ companies in 75+ countries.
Try the most candidate friendly skills assessment tool today.
Ready to use the Adaface Excel Test?
Ready to use the Adaface Excel Test?
Chat with us
40 min tests.
No trick questions.
Accurate shortlisting.
Terms Privacy Trust Guide

🌎 Pick your language

English Norsk Dansk Deutsche Nederlands Svenska Français Español Chinese (简体中文) Italiano Japanese (日本語) Polskie Português Russian (русский)
Ada
Ada
● Online
Previous
Score: NA
Next
✖️