Excel Test

Pre-employment skills assessment test powered by AI chatbot

Adaface Excel Online Test will be customized to accurately evaluate on-the-job skills required for your role. This assessment test is useful when you are hiring candidates for roles like - Data Analyst, Business Analyst, Accountant, Financial Analyst, Market Research Analyst and can test candidate skills on topics like Core Java, Data Types, Threads, Servlets, General Aptitude;OOPs, classes, etc.

  • amazon
  • paypal
  • ef
  • lovebonito
  • singapore-government
  • niyo
  • optimum
1. Scorecards
Ada creates a detailed scorecard for every conversation with section wise breakdown and a pass/ fail recommendation.
1
Scorecards
Ada creates a detailed scorecard for every conversation with section wise breakdown and a pass/ fail recommendation.

Adaface is your new secret weapon

Custom assessments

We create custom assessments based on your ideal developer persona. Check out our library of 700+ skills.

Higher test taking rate

Average test taking rate of 86% as compared to an industry standard of 50%. Read more about candidate friendly features here.

Friendly talent brand

Our AI chatbot Ada leaves your candidate with a smile at the end of the chat. Check out our candidate wall of love here.

"Chatbot format of coding assessments is amazing!"

"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

"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."


- Human Resources Manager, Singapore Government

Why You Should Use This Test

The 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 expensive time by filtering out unqualified candidates before interviews.

The Adaface tests screen candidates for the typical skills recruiters look for in Excel experts:

  • Deep expertise with Excel Functions and Formulas
  • Ability to analyse data efficiently
  • Experience with functions for data cleaning and manipulation: Concatenation, LEN, Find & Replace, Filter & Sort, Conditional Formatting, Index Match, Remove Duplicates and Logic Functions
  • Familiarity with using text strings, customising charts and data validation.

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

About This Test

The Excel test will consist of ~25 MCQs/ scenario based questions crafted by experts and will cover a broad spectrum of topics within Excel. Use this Excel test to streamline your hiring process.

The Excel Test helps you screen candidates and enables you to identify the candidates with proven hands-on technical expertise in Excel before the interview.

Here is a list of topics (only for reference, actual topics and questions for your custom assessment will be chosen by our subject matter experts based on your job description/ ideal candidate persona).

Number Charts Formulae Hyperlinks
Cells Columns Rows Ranges
Pivot Tables Filters Macros VBA
Sorting VLOOKUP CONCATENATE IF
MATCH INDEX Conditional Formatting Nesting
Date/ Time Arithmetic Data Manipulation Data Summarization
Get started for free

(100% free to get started, no credit card required)

Sample Excel Test Question

Which formula would you use to find the price for the selected product?

Options: 

A: =INDEX(C2:C7,MATCH(A10,A2:A7,0))

B: =VLOOKUP(A10,A2:C7,3,FALSE)

C: Both of the above

D: None of the above

What Are Conversational Assessments

Conversational assessments are the most candidate friendly way to get insights into a candidate's on-the-job skills and suitability for a role, while providing for a delightful candidate experience.

Candidates love conversational assessments because they are fast, intuitive and feel like an interview rather than a test.

Tired of traditional assessments with trick questions and low completion rates?

traditional assessments cons

Adaface conversational assessments are reflective of on-the-job skills and see an 86% completion rate as compared to ~50% for traditional assessment platforms.

conversational assessments pros

Read more about conversational assessments.

Get started for free

(100% free to get started, no credit card required)

Score Distribution

You should expect ~20% of the candidates to do well on Adaface assessments.

The score distribution for our assessments follow the normal curve. This is a good sign- tandardized tests like SAT and GRE follow the normal distribution (bell curve).

Status quo assessments typically have the exact opposite of the bell curve (too many candidates getting close to 0, too many candidates getting close to 100 and too few candidates in the middle). This is typically because they focus on theoretical questions or trick questions, which are very binary in nature- either you know the trick/ theory or you don’t.

FAQs

What is a custom assessment?

Every role is different and requires a custom assessment to identify top candidates efficiently. Adaface subject matter experts understand your job description/ role requirements and pick the most relevant questions from our library of 5000+ questions to create a technical assessment that helps you find the qualified candidates in your candidate pipeline quickly. All custom assessments are set up based on the job description, role requirements, must-have skills, experience level and salary range within a maximum of 48 hours and you will get an email notification once it goes live.

Check out a sample assessment here (no credit card required).

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.

How is Adaface different from other assessment tools?

We believe that status quo tech assessment platforms are not a fair way for companies to evaluate engineers because they focus on trick questions/ puzzles/ niche algorithms. We started Adaface to help companies find great engineers by assessing on-the-job skills required for a role. Read more about what we do differently at Adaface here.

Do you have any anti-cheating features in place?

We have the following anti-cheating features in place:

  1. Web proctoring
  2. Webcam proctoring
  3. Plagairism detection
  4. Non-googleable questions
  5. Secure browser

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. As in an assessment is optimizing to help you eliminate candidates who are not technically qualified for the role, it is not optimized to help you find the best developer for the role. So the ideal way to use an assessment is to decide a threshold score (typically 60%, 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 developer persona (our subject matter experts will pick the right questions for your assessment from our library of 5000+ questions). This assessment can be customized for Java developer roles for any experience level (unless the role is primarily a leadership/ non-programming role, we do not recommend you a use any automated assessments in that case).

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 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 an engineer. Can I try a practice test?

No. Unfortunately, we do not support practice tests at the moment.

What is the cost for using the Excel Online Test?

Please get in touch, we'll create a custom plan for you based on the number of assessments you need.

Can I get a free trial?

You can sign up for free and check out the platform here. The dashboard has a sample assessment for you to review the quality of questions and check out the candidate experience of a chat based assessment. Since our questions are premium, we are unable to share sample questions for a particular skill/ technology.

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

Check out our quick guide on requesting a custom assessment here.

How do I use this?

Step 1

You request a custom assessment via the dashboard.

Step 2

Our subject matter experts review your assessment request and select the right questions to evaluate candidates for that role from our library of 5000+ questions.

Step 3

You get an email when the assessment is ready for use (within a maximum 48 hours of creating the request).

Step 4

Voila! You can start inviting candidates. You can read more about custom assessments here.

Get started for free

(100% free to get started, no credit card required)

About The Role

Microsoft Excel is a software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.

Some of the roles that might Microsoft Excel skills are:

  • Accountants and auditors
  • Marketing, sales, training and administrative managers
  • Project coordinators, project and construction managers
  • Data analysts
  • Investment bankers and financial analysts
  • Market research, business and management analysts
  • Cost estimators

Shortlist the best talent today

Get started for free

(100% free to get started, no credit card required)



Adaface

32 Carpenter St, Singapore 059911
Innov8 Coworking, 20th Main Rd, 7th Block, Koramangala, Bangalore, Karnataka, India 560095
© 2020 Adaface Pte. Ltd.

Company
About Us Join Us
Partners
sap.io
Contact
Email Us
Adaface

32 Carpenter St, Singapore 059911
Innov8 Coworking, 20th Main Rd, 7th Block, Koramangala, Bangalore, Karnataka, India 560095
© 2020 Adaface Pte. Ltd.

Partners
sap.io
Contact Us
Email Us