Search test library by skills or roles
⌘ K

About the test:

The Business Analyst Excel Test uses scenario-based MCQs to evaluate candidates on their proficiency in using Microsoft Excel for data analysis and visualization. The test assesses candidates on their knowledge of Excel formulas and functions, such as SUM, AVERAGE, and VLOOKUP, as well as their ability to create and modify Excel charts and graphs. It also evaluates their familiarity with Excel features, such as pivot tables, conditional formatting, and data validation, and their ability to use Excel for financial modeling and forecasting.

Covered skills:

  • Business Cases
  • Worksheet and Charts
  • Stakeholder Processes
  • Operators
See all covered skills

9 reasons why
9 reasons why

Adaface Business Analyst Excel Test is the most accurate way to shortlist Business Analysts



Reason #1

Tests for on-the-job skills

The Business Analyst Excel 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.

The Adaface Business Analyst Excel Online Test screens candidates for the typical skills recruiters look for Business Analyst roles:

  • Experience in an analytics and systems development capacity
  • Proficiency with SQL language and database management
  • Proven analytical abilities
  • Experience generating process documentation and reports

The insights generated from this assessment can be used by recruiters and hiring managers to identify the best candidates for Business Analyst roles. Anti-cheating features enable you to be comfortable with conducting assessments online. The Business Analyst Excel Online Test is ideal for helping recruiters identify which candidates have the skills to do well on the job.

Reason #2

No trick questions

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 Business Analyst Excel Test will be non-googleable.

🧐 Question

Medium

PV of customer segments
Market Segmentation
ROI
CLV
Solve
A retail company is exploring new customer segments to increase sales. You are provided with the following data on three potential customer segments:

Segment A:

- Average annual revenue per customer: $500
- Average customer retention rate: 80%
- Average customer acquisition cost: $200
- Expected segment size: 2,000 customers

Segment B:

- Average annual revenue per customer: $750
- Average customer retention rate: 70%
- Average customer acquisition cost: $300
- Expected segment size: 1,500 customers

Segment C:

- Average annual revenue per customer: $1,000
- Average customer retention rate: 60%
- Average customer acquisition cost: $400
- Expected segment size: 1,000 customers
Assuming a 10% discount rate, which customer segment should the company target to maximize the return on investment? A target customer segment would have higher customer lifetime value (CLV). Note that CLV is calculated by using the following formula:

CLV = (Average Annual Revenue per Customer * Gross Margin %) * (Retention Rate / (1 + Discount Rate - Retention Rate)) - Customer Acquisition Cost

Easy

Supply Chain Management
Cost Reduction
Solve
A company is considering two options to optimize its supply chain and reduce costs. The following data has been provided for each option:

Option Alpha:

- Annual transportation cost reduction: $300,000
- Annual inventory carrying cost increase: $250,000
- One-time implementation cost: $100,000

Option Beta:

- Annual transportation cost reduction: $200,000
- Annual inventory carrying cost increase: $150,000
- One-time implementation cost: $50,000

As a business analyst, determine which option provides a higher net cost reduction over a 3-year period.
A: Option Alpha provides a higher net cost reduction.
B: Option Beta provides a higher net cost reduction.
C: Both options provide the same net cost reduction.
D: Neither option provides a net cost reduction.
E: The net cost reduction cannot be determined with the given data.

Medium

Multi Select
Solve
Consider the following SQL table:
 image
How many rows does the following SQL query return?
 image

Medium

Select & IN
Solve
Consider the following SQL table:
 image
Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
 image

Hard

With, AVG & SUM
Solve
Consider the following SQL table:
 image
How many tuples does the following query return?
 image

Medium

Dividends
Line Charts
Solve
Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?
 image
 image

Medium

Laptop Brands
Missing data
Solve
Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?
 image

Medium

Median
Percentages
median
Solve
 Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.
 image

Medium

Emma's cafe business
Solve
Emma's cafe has been operating successfully for the last 6 years. Profits have been growing every year, with this year (2020) being their best year so far. As a thank you, Emma treated her staff to a meal at a Michelin star restaurant. 
 image
Below are 3 statements about Emma, her staff and her cafe. Can you help us decide whether the 3 statements are "True", "Probably True", "Insufficient Data to Say True or False", "Probably False", or "False".

1. Emma's staff members are happy.
2. Emma's cafe did well in 2016.
3. Emma is rich.

A: True
B: False
C: Probably True
D: Probably False
E: Insufficient Data

Easy

Ivory's new startup
Solve
Statement: Ivory started a new startup. We know for a fact that almost all startups fail within the first 2 years. 
Conclusion: Ivory's startup will fail.
Does the conclusion follow from the statement?

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

PV of customer segments
Market Segmentation
ROI
CLV
3 mins
Business Analysis
Solve

Easy

Supply Chain Management
Cost Reduction
2 mins
Business Analysis
Solve

Medium

Multi Select
2 mins
SQL
Solve

Medium

Select & IN
3 mins
SQL
Solve

Hard

With, AVG & SUM
2 mins
SQL
Solve

Medium

Dividends
Line Charts
3 mins
Data Interpretation
Solve

Medium

Laptop Brands
Missing data
2 mins
Data Interpretation
Solve

Medium

Median
Percentages
median
3 mins
Data Interpretation
Solve

Medium

Emma's cafe business
2 mins
Critical Thinking
Solve

Easy

Ivory's new startup
2 mins
Critical Thinking
Solve

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
PV of customer segments
Market Segmentation
ROI
CLV
Business Analysis
Medium3 mins
Solve
Supply Chain Management
Cost Reduction
Business Analysis
Easy2 mins
Solve
Multi Select
SQL
Medium2 mins
Solve
Select & IN
SQL
Medium3 mins
Solve
With, AVG & SUM
SQL
Hard2 mins
Solve
Dividends
Line Charts
Data Interpretation
Medium3 mins
Solve
Laptop Brands
Missing data
Data Interpretation
Medium2 mins
Solve
Median
Percentages
median
Data Interpretation
Medium3 mins
Solve
Emma's cafe business
Critical Thinking
Medium2 mins
Solve
Ivory's new startup
Critical Thinking
Easy2 mins
Solve
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

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 Business Analyst 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 Business Analyst 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.

invite candidates
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.

test completion rate
Reason #9

Advanced Proctoring


About Business Analyst Roles

Business analysis is a methodical strategy to initiating and managing change in companies, whether for-profit, government, or non-profit organisations. Business analysis is used to discover and express the need for change in how businesses operate, as well as to help organisations implement that change.

A Business Analyst assists organisations in improving their processes and systems. They undertake research and analysis to provide answers to business challenges and assist in the implementation of these systems into organisations and their customers.

Typical Business Analyst responsibilities include:

  • Analyzing the structure of a business
  • Identifying problems within a business, including through using data modelling techniques
  • Formulating ways for businesses to improve, based on research findings
  • Persuading internal and external stakeholders of the benefits of new technology and strategies
  • Overseeing the implementation of new technology and systems

What roles can I use the Business Analyst Excel Test for?

  • Business Analyst

What topics are covered in the Business Analyst Excel Test?

Numbers, Percentages, Dates and Sometimes Texts

Data Formats
Cell References
Key
Combination Keys
Function
LOOKUP
VLOOKUP
HLOOKUP
Comment
Note

Visual Basic for Applications

VBA
Conditional Formatting
COUNTA
COUNT
Data Import
Data Storage
Data Protection
SUM Function
IF Function
AVERAGE Function
MAX and MIN Functions
Pivot Tables
Charts
Calculated Items
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

FAQs

Can I combine multiple skills into one custom assessment?

Yes, absolutely. Custom assessments are set up based on your job description, and will include questions on all must-have skills you specify.

Do you have any anti-cheating or proctoring features in place?

We have the following anti-cheating features in place:

  • Non-googleable questions
  • IP proctoring
  • Web proctoring
  • Webcam proctoring
  • Plagiarism detection
  • Secure browser

Read more about the proctoring features.

How do I interpret test scores?

The primary thing to keep in mind is that an assessment is an elimination tool, not a selection tool. A skills assessment is optimized to help you eliminate candidates who are not technically qualified for the role, it is not optimized to help you find the best candidate for the role. So the ideal way to use an assessment is to decide a threshold score (typically 55%, we help you benchmark) and invite all candidates who score above the threshold for the next rounds of interview.

What experience level can I use this test for?

Each Adaface assessment is customized to your job description/ ideal candidate persona (our subject matter experts will pick the right questions for your assessment from our library of 10000+ questions). This assessment can be customized for any experience level.

Does every candidate get the same questions?

Yes, it makes it much easier for you to compare candidates. Options for MCQ questions and the order of questions are randomized. We have anti-cheating/ proctoring features in place. In our enterprise plan, we also have the option to create multiple versions of the same assessment with questions of similar difficulty levels.

I'm a candidate. Can I try a practice test?

No. Unfortunately, we do not support practice tests at the moment. However, you can use our sample questions for practice.

What is the cost of using this test?

You can check out our pricing plans.

Can I get a free trial?

Yes, you can sign up for free and preview this test.

I just moved to a paid plan. How can I request a custom assessment?

Here is a quick guide on how to request a custom assessment on Adaface.

customers across world
Join 1200+ companies in 75+ countries.
Try the most candidate friendly skills assessment tool today.
g2 badges
Ready to use the Adaface Business Analyst Excel Test?
Ready to use the Adaface Business Analyst Excel Test?
Chat with us
logo
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
✖️