Excel测试

Q: 我可以在同一个测试中评估 Excel 和 SQL 技能吗？

是的。我们支持在同一次测试中评估多种技能。您可以查看我们的 SQL 测试 以了解将使用哪些类型的问题来评估 SQL。

Q: What topics are covered in the Excel测试?

基本公式（匹配；索引） 数学公式（总和; min; avg） 高级公式（如果; vlookup; hlookup） 数据类型 分析数据（Pivots;过滤器;） 可视化数据（图表；图） 与日期和时间合作 数据验证 错误处理 插入和格式表 闪光和数据栏 用户形式控件 3-DATA合并 与宏自动化

About the test:

Excel测试使用基于方案的MCQ问题来评估候选人与Excel中的大型数据集合作，导航多个电子表格，使用高级公式并创建报告的能力。测试屏幕的分类/过滤数据，使用Pivottables分析数据，使用图表创建仪表板，为用户输入提供表格，并记录/修改/写入宏。

Covered skills:

基本公式（匹配；索引）
高级公式（如果; vlookup; hlookup）
分析数据（Pivots;过滤器;）
与日期和时间合作
错误处理
闪光和数据栏
3-DATA合并

数学公式（总和; min; avg）
数据类型
可视化数据（图表；图）
数据验证
插入和格式表
用户形式控件
与宏自动化

Preview this test

查看样本记分卡

9 reasons why

Adaface Excel测试 is the most accurate way to shortlist 数据分析师s

Reason #1

Tests for on-the-job skills

The Excel测试 helps recruiters and hiring managers identify qualified candidates from a pool of resumes, and helps in taking objective hiring decisions. It reduces the administrative overhead of interviewing too many candidates and saves time by filtering out unqualified candidates at the first step of the hiring process.

The test screens for the following skills that hiring managers look for in candidates:

能够使用基本公式（例如匹配和索引）执行数据查找和检索的能力
能够使用数学公式（例如总和，最小值和AVG）进行数据分析
能够使用高级公式，例如if，vlookup和hlookup进行复杂计算
能够使用各种数据类型来操纵和分析数据
能够使用枢轴表和过滤器等工具分析数据
能够使用图表和图形可视化数据
在Excel中与日期和时间合作的能力
能够验证数据以确保准确性和一致性
处理公式中的错误和例外的能力
能够为数据组织插入和格式表
能够使用闪光和数据栏进行目视表示数据的能力
能够使用用户形式控件进行交互数据输入
能够使用数据合并技术从不同来源合并数据
能够使用Excel中的宏来自动化任务

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.

View sample questions

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

Preview this test

查看样本记分卡

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.

How we design questions

这些只是我们库中有10,000多个问题的一个小样本。关于此的实际问题 Excel测试将是不可行的.

🧐 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?
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: 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: Here’s the expected data format: 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)). 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
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?
	Medium Organization data Data transformation	3 mins Excel	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: 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	2 mins Excel	Solve
Here’s a sample Excel data source: Here’s the expected data format: 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	2 mins Excel	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)). 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	💪 Difficulty	⌛ Time
	MATCH INDEX LOOKUP	Excel	Medium	2 mins	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?
	Organization data Data transformation	Excel	Medium	3 mins	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: 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.
	Student scores Data formatting	Excel	Medium	2 mins	Solve
Here’s a sample Excel data source: Here’s the expected data format: 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
	VLOOKUP blood donor	Excel	Medium	2 mins	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)). 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)

Reason #4

1200+ customers in 75 countries

借助 Adaface，我们能够将初步筛选流程优化达 75% 以上，为招聘经理和我们的人才招聘团队节省了宝贵的时间！

Brandon Lee, 人事主管, Love, Bonito

Preview this test

查看样本记分卡

Reason #5

Designed for elimination, not selection

The most important thing while implementing the pre-employment Excel测试 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.

Science behind Adaface tests

Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the Excel测试 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 & benchmarks

查看样本记分卡

Preview this test

查看样本记分卡

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

Learn more

Preview this test

查看样本记分卡

About the Excel测试

Why you should use Excel测试?

The Excel测试 makes use of scenario-based questions to test for on-the-job skills as opposed to theoretical knowledge, ensuring that candidates who do well on this screening test have the relavant skills. The questions are designed to covered following on-the-job aspects:

基本公式（匹配;索引） - 使用匹配和索引（例如匹配和索引）从Excel电子表格检索数据的能力。
数学公式（总和; min; avg） - 使用诸如总和，最小值和AVG之类的数学公式在Excel中执行计算。
高级公式（如果; vlookup; hlookup） - 熟悉高级公式，例如if，vlookup和hlookup，用于excel中复杂数据操作的hlookup。
数据类型 - 了解Excel中的不同数据类型，包括数字，文本，日期和公式。
分析数据（枢轴；过滤器） - 使用Excel中的枢纽和过滤器等功能来分析和操纵数据的能力。
可视化数据（图表；图） - 创建和解释图表和图形以可视化Excel中的数据的能力。
使用日期和时间 - 在Excel中使用日期和时间进行处理和执行计算的能力。
数据验证 - 实施数据验证规则的知识以确保Excel中的数据完整性和准确性。
错误处理 - 识别和处理可能出现在Excel公式和功能中的错误的能力。
插入和格式化表 - 能够创建和格式化表以在Excel中有效组织和呈现数据的能力。

Once the test is sent to a candidate, the candidate receives a link in email to take the test. For each candidate, you will receive a detailed report with skills breakdown and benchmarks to shortlist the top candidates from your pool.

What topics are covered in the Excel测试?

基本公式（匹配;索引）
Excel中的基本公式，例如匹配和索引，允许用户从一系列数据范围内搜索和检索特定值。这些功能对于有效地组织和操纵数据至关重要。测量测试中的这一技能有助于招聘人员评估候选人有效地导航和利用这些基本公式的能力。
数学公式（sum; min; min; avg）
数学公式（如sum，sum，min），并且AVG对于在Excel中执行计算和总结数值数据至关重要。测量测试中的这项技能使招聘人员能够评估候选人在基本数学操作方面的熟练程度及其对数据分析技术的理解。
高级公式（如果; vlookup; vlookup; hlookup; hlookup; hlookup;就像IF一样，Vlookup和Hlookup在Excel中提供了更复杂的数据处理功能。这些功能允许用户执行有条件的计算，搜索特定值并从工作表的不同部分检索数据。评估该技能在测试中有助于招聘人员衡量候选人处理复杂数据操作和解决问题的任务的能力。</p> <h4>数据类型
了解各种数据类型，例如文本，数字，等等日期和时间在Excel中至关重要。该技能涉及识别和正确格式化不同的数据类型，以确保准确的计算和有意义的分析。评估测试中的这项技能有助于招聘人员确定候选人在管理各种数据集的熟练程度。
分析数据（Pivots; filters;）
Pivot表和过滤器在Excel中是Excel的功能强大的功能分析和从大型数据集中提取有意义的见解。了解如何创建和操纵枢轴表以及使用过滤器，使用户可以轻松识别模式，趋势和离群值。测量测试中的这一技能有助于招聘人员评估候选人从复杂数据中得出有价值信息的能力。
可视化数据（图表;图形）
通过图表和图形可视化数据是必不可少的以清晰且具有视觉吸引力的方式介绍信息。 Excel提供了广泛的图表类型和自定义选项，使用户可以创建其数据的有影响力的视觉表示。测量测试中的这一技能使招聘人员能够评估候选人通过视觉元素有效地传达数据的能力。
与日期和时间一起工作</p>
与Excel中的日期和时间一起工作涉及了解日期功能，格式化选项和执行与时间间隔相关的计算。该技能对于准确有效地处理时间敏感数据至关重要。通过评估测试中的这项技能，招聘人员可以确定候选人在管理时间数据和执行基于日期的计算方面的熟练程度。
数据验证
数据验证包括确保数据完整性和通过将预定义的规则和约束应用于输入单元。该技能涉及设置验证标准，创建错误消息和实施数据限制。测量测试中的此技能有助于招聘人员评估候选人建立可靠数据输入机制并防止错误输入的能力。
错误处理
错误处理错误是指识别和解决可能发生的错误在Excel公式和功能中。此技能需要理解常见的错误类型，例如#value！，＃div/0！和#ref！，并采用适当的错误检查技术。评估该测试中的这项技能使招聘人员能够评估候选人对公式相关错误的故障排除和解决与公式相关的错误的能力，从而确保准确的数据分析。
插入和格式化表
Excel有助于以结构化格式组织和呈现数据。此技能涉及创建桌子，应用格式选项以及自定义表设计。评估测试中的这一技能使招聘人员可以评估候选人在视觉上增强数据表的熟练程度，并使它们更加用户友好和访问。
闪光和数据栏
闪光灯和数据栏是Excel中的视觉元素，可提供单个单元内数据趋势的简洁表示。该技能涉及创建和自定义闪光和数据栏，以有效地传达信息。测量测试中的此技能有助于招聘人员评估候选人使用这些数据可视化工具来增强数据分析和呈现的能力。
用户表格控制
excel中的用户表格控制包括各种交互式元素（例如按钮，下拉列表和复选框）可以增强用户体验并简化数据输入。此技能涉及添加，自定义和链接表单控件以自动化数据输入和处理任务。评估测试中的这项技能使招聘人员能够确定候选人在创建用户友好的接口和优化工作流效率方面的熟练程度。
3-DATA合并
excel中的数据整合是指该过程将多个数据集组合到一个统一的数据集中，以进行分析或报告目的。该技能涉及利用合并工具和功能毫不费力地合并来自不同来源的数据。评估该测试中的这一技能有助于招聘人员评估候选人在合并和管理各种数据集方面的熟练程度。在Excel中记录并创建以自动化重复任务的脚本。该技能使用户可以简化工作流程，提高效率并增强自定义功能。测量测试中的这一技能有助于招聘人员评估候选人创建和实施宏以优化数据分析和操纵过程的能力。
Full list of covered topics
The actual topics of the questions in the final test will depend on your job description and requirements. However, here's a list of topics you can expect the questions for Excel测试 to be based on.
匹配
指数
和
最小
avg
如果
vlookup
hlookup
数据类型
枢轴表
过滤器
图表
图
日期
时代
数据验证
错误处理
表
闪电
数据栏
用户形式控件
数据合并
宏
查找功能
逻辑功能
文本功能
数学功能
统计功能
财务职能
条件格式
数据库功能
阵列公式
链接工作表
链接工作簿
数据分析工具
有条件的语句
逻辑操作员
图表格式
图表类型
图表元素
数据分类
数据过滤
数据分组
数据小写
数据切片机
命名范围
数据表
公式审核
方案经理
目标寻求
求解器加载项
记录宏
宏观编辑
宏观安全
ActiveX控件
形式控件
定制号码格式
条件格式规则
错误检查
合并数据
外部数据源
工作簿保护
工作表保护

Preview this test

查看样本记分卡

What roles can I use the Excel测试 for?

数据分析师
财务分析师
会计
业务分析师
数据输入（Excel）
行政助理
销售经理
营销分析师
商业顾问
运营经理

How is the Excel测试 customized for senior candidates?

For intermediate/ experienced candidates, we customize the assessment questions to include advanced topics and increase the difficulty level of the questions. This might include adding questions on topics like