Excel & SQL Test

About the test:

The Excel SQL Test uses scenario-based MCQs to evaluate candidates on their proficiency in using Microsoft Excel and SQL for data analysis and reporting. The test assesses candidates' ability to query and analyze data using SQL, import and export data between Excel and SQL databases, and create and manage Excel reports and dashboards. The test focuses on data modeling, database design, data validation and normalization, SQL functions and procedures, data visualization, and data manipulation.

Covered skills:

数据类型
数学公式（总和; min; avg; sumifs）
分析数据（Pivots;过滤器;）
枢轴图表和表格
条件格式
数据操纵
错误处理
闪光和数据栏
与宏自动化
基于公式的条件格式
关系模型
SQL功能
数据查询语言
SQL过滤 /在哪里语句
索引
SQL加入
日期过滤和时间戳
操作员优先
通过...分组
自下而上的设计
正常化
多桌选择
备份策略
数据类型
碎片
备份
分布式与集中数据库
SQL注射

基本公式（匹配；索引）
高级公式（如果; vlookup; hlookup）
可视化数据（图表；图）
查找和参考
数据摘要
与日期和时间合作
插入和格式表
3-DATA合并
3-DATA合并
形式和动作
SQL基础知识
数据修改语言
克鲁德
子征服
3个有价值的逻辑
窗口功能
聚合功能
顺序
自上而下的设计
实体关系图
数据库类型
许可管理
交易
视图
复制
垂直 +水平缩放
数据库安全性
访问控制

See all covered skills

Preview this test

查看样本记分卡

9 reasons why

Adaface Excel & SQL Test is the most accurate way to shortlist SQL Developers

Reason #1

Tests for on-the-job skills

The Excel & SQL Test 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.

Non-googleable questions & proctoring features enable you to be comfortable with conducting assessments online. The Excel & SQL Test is ideal for helping recruiters identify which candidates have the skills to do well on the job.

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.

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

🧐 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)
Medium Multi Select JOIN GROUP BY	Solve
Consider the following SQL table: How many rows does the following SQL query return?
Medium nth highest sales Nested queries User Defined Functions	Solve
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
Medium Select & IN Nested queries	Solve
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
Medium Sorting Ubers Nested queries Join Comparison operators	Solve
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
Hard With, AVG & SUM MAX() MIN() Aggregate functions	Solve
Consider the following SQL table: How many tuples does the following query return?

	🧐 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)
	Medium Multi Select JOIN GROUP BY	2 mins SQL	Solve
Consider the following SQL table: How many rows does the following SQL query return?
	Medium nth highest sales Nested queries User Defined Functions	3 mins SQL	Solve
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
	Medium Select & IN Nested queries	3 mins SQL	Solve
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
	Medium Sorting Ubers Nested queries Join Comparison operators	3 mins SQL	Solve
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
	Hard With, AVG & SUM MAX() MIN() Aggregate functions	2 mins SQL	Solve
Consider the following SQL table: How many tuples does the following query return?

	🧐 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)
	Multi Select JOIN GROUP BY	SQL	Medium	2 mins	Solve
Consider the following SQL table: How many rows does the following SQL query return?
	nth highest sales Nested queries User Defined Functions	SQL	Medium	3 mins	Solve
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
	Select & IN Nested queries	SQL	Medium	3 mins	Solve
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
	Sorting Ubers Nested queries Join Comparison operators	SQL	Medium	3 mins	Solve
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
	With, AVG & SUM MAX() MIN() Aggregate functions	SQL	Hard	2 mins	Solve
Consider the following SQL table: How many tuples does the following query return?

Reason #4

1200+ customers in 75 countries

借助Adaface，我们能够优化我们的初始筛查过程超过75％，从而为招聘经理和我们的人才获取团队提供了宝贵的时间！

Brandon Lee, 人的负责人, Love, Bonito

Reason #5

Designed for elimination, not selection

The most important thing while implementing the pre-employment Excel & SQL 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 & SQL 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 & benchmarks

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

Preview this test

查看样本记分卡

What topics are covered in the Excel & SQL Test?

数据类型

基本公式（匹配；索引）

数学公式（总和; min; avg; sumifs）

高级公式（如果; vlookup; hlookup）

分析数据（Pivots;过滤器;）

可视化数据（图表；图）

枢轴图表和表格

查找和参考

条件格式

数据摘要

数据操纵

与日期和时间合作

错误处理

插入和格式表

闪光和数据栏

3-DATA合并

与宏自动化

3-DATA合并

基于公式的条件格式

形式和动作

关系模型

SQL基础知识

SQL功能

数据修改语言

数据查询语言

克鲁德

SQL过滤 /在哪里语句

子征服

索引

3个有价值的逻辑

SQL加入

窗口功能

日期过滤和时间戳

聚合功能

操作员优先

顺序

通过...分组

自上而下的设计

自下而上的设计

实体关系图

正常化

数据库类型

多桌选择

许可管理

备份策略

交易

数据类型

视图

碎片

复制

备份

垂直 +水平缩放

分布式与集中数据库

数据库安全性

SQL注射

访问控制

Preview this test

查看样本记分卡

招聘经理认为，通过小组访谈中他们提出的技术问题，他们能够分辨哪些候选人的得分更好，并且与未得分的人有区别。他们是非常满意随着候选人的质量入围了Adaface筛选。

85%

减少筛查时间

查看完整的案例研究

常见问题解答

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

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

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

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

不可解决的问题
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/）。

我可以免费试用吗？

是的，您可以[免费注册]（https://app.adaface.com/app/dashboard/login?show=signup）并预览此测试。

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

这是[如何要求自定义评估]（https://help.adaface.com/en/articles/6324286-requesting-a-custom-test）的快速指南。

Preview this test

查看样本记分卡

Excel & SQL Test

Adaface Excel & SQL Test is the most accurate way to shortlist SQL Developers

Tests for on-the-job skills

No trick questions

Non-googleable questions

1200+ customers in 75 countries

Designed for elimination, not selection

1 click candidate invites

Detailed scorecards & benchmarks

High completion rate

Advanced Proctoring

What topics are covered in the Excel & SQL Test?

常见问题解答

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

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

如何解释考试成绩？

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

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

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

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

我可以免费试用吗？

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

相关测试

Excel测试

SQL在线测试