Adaface Public Excel Questions

Here are some sample Excel questions from our premium questions library (10273 non-googleable questions).

🧐 Question	🔧 Skill	💪 Difficulty	⌛ Time
MATCH INDEX LOOKUP - Some friends live in adjace...	Excel	Medium	2 min
VLOOKUP blood donor - We are looking to find the ...	Excel	Medium	2 min

Search Adaface Public Questions

Selenium Testing PowerShell Shell Scripting Jest Linux Jenkins JUnit Protractor JavaScript C C# COBOL C++ R Java Go Kotlin Embedded C Perl PHP Python Ruby Scala Rust Swift TypeScript Technical Aptitude Abstract Reasoning English Financial Modeling Spatial Reasoning Logical Reasoning Verbal Reasoning Diagrammatic Reasoning Critical Thinking Data Interpretation Situational Judgement Attention to Detail Numerical Reasoning Aptitude Azure AWS Windows Administration Computer Networks Azure Data Factory Terraform React Redux Angular Vue ASP.NET React Native NodeJS Android iOS Hibernate Spring Django Hadoop Laravel Magento Hive Rails CS Fundamentals Software Engineering Git Jira Microservices SOLID System Design Shopify Webpack Excel SQL MySQL PostgreSQL Oracle SQL MS SQL MongoDB Data Analysis Data Science Data Modeling Machine Learning Firestore Cassandra Tableau Power BI Terraform NumPy Kafka Pandas Qlik Sense CSS Accounting Finance Cyber Security SAP ABAP SAP HANA Salesforce Spark Adobe InDesign Oracle Hyperion Planning Customer Support ITIL LINQ Blue Prism SAS SCCM SSAS SSRS Citrix Google Adwords Weblogic UX SEO Product Management Business Analysis Dynamics 365 SCM HTML/CSS Ravens Progressive Matrices Amazon Redshift Array OOPs Cache Promises Async-Await Strings Exceptions Arrays Time Complexity Pseudo Code Logistic Regression File Handling Interfaces Concurrency Maps Garbage Collection Prototypes WebApp ER Diagram S3 Exception Database Connection Dictionary SSH Decision Tree Classifier Singleton Event Viewer Grammar Cookies liquid KStream Partition Storage

Looking to screen Excel skills? Hire great candidates with Adaface conversational assessments

All Aptitude Tests

33+ customizable tests

Cognitive Ability

19+ customizable tests

Business Skills

14+ customizable tests

All Entry Level Hiring Tests

11+ customizable tests

Entry Level Graduates

5+ customizable tests

SQL MSSQL MySQL

8+ customizable tests

All Database Skills

24+ customizable tests

Business Analyst

8+ customizable tests

All Business Skills Tests

17+ customizable tests

All Language Tests

3+ customizable tests

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

Adaface Excel ready-to-go tests are designed by experts to evaluate on-the-job skills

Aptitude/ Reasoning Tests

Analytical Skills Fluid Intelligence Business Intelligence Analyst Quantitative Aptitude (Advance) Data Interpretation, Spatial Reasoning & Verbal Reasoning Data Interpretation, Numerical Reasoning & Verbal Reasoning Data Interpretation, Numerical Reasoning & Spatial Reasoning

Excel Tests

Excel & Data Interpretation

Entry Level Developer Tests

Campus Recruitment (Aptitude) IT Freshers Technical Aptitude & Coding Computer Programmer Aptitude Technical Aptitude & JavaScript Technical Aptitude & C++ Technical Aptitude & Python Technical Aptitude & Ruby Technical Aptitude & C#

Accounting/ Finance Tests

Assistant Auditor Financial Analyst Accounting Aptitude test for Auditors

English Tests

English, Verbal Reasoning & Data Interpretation English, Verbal Reasoning & Numerical Reasoning English, Verbal Reasoning & Spatial Reasoning

Adaface Excel questions are used by enterprises worldwide

4.8/5

4.7/5

Customize Adaface Excel tests to assess multiple skills in a single assessment

🧐 Test	🔧 Sample Topics	💪 Useful for hiring
Aptitude test for Auditors
Computer Programmer Coding Aptitude Assessment Test	Computer fundamentals SQL concepts Core Java Business analysis
Business Intelligence Analyst Test	logistic concepts microsoft office database SQL SDLC Analytical thinking operations concepts written communication
Business Analyst Aptitude Online Assessment Test	Analytical Thinking Data Interpretation Data Sufficiency Listening Skills Comprehension Writing Skills
Financial Risk Management	Capital Budgeting Risk and Return Beta VaR Types of Risk Systematic and Unsystematic Risk Unexpected Loss Hedging
Data Interpretation Test	Pie Chart Bar Chart Line Chart ratio- proportion problems on the data percentage increase-decrease problems
Excel Online Assessment Test	Data manipulation Conditional formatting Formulae Macros VLOOKUP IF Data summarization Ranges VBA Pivot tables
Microsoft Office 365	Customizations and developments Query conditions Onedrive BCS services Site collection Sharepoint foundation 2013 OData connection Sharepoint library
Pre-employment English Online Assessment Test (Advanced)	Reading comprehension grammar verbal reasoning vocabulary
Fluid Intelligence Online Assessment Test	abstract reasoning critical thinking diagrammatic reasoning deductive reasoning inductive reasoning problem solving pattern matching spatial reasoning creativity The Raven’s Progressive Matrices Guilford’s test of Divergent Thinking Torrance Test of Creative Thinking
SQL Online Test	SQL Data Types and Literals SQL Operators Views Indexes Nulls SQL Functions SQL Tables Queries Commands and clause PL/SQL
Qlik Sense Assessment Test	Chart QlikSense - Scripting QlikSense - UX QlikSense - Expressions QlikSense - QMC QlikSense - Publishing
Tableau Online Test	Tableau Marks Geographical Data Data Merging Tableau Extracts Tableau Filters Tableau Actions Tableau Drill Tableau Aggregations

Aptitude test for Auditors

View Test

Computer Programmer Coding Aptitude Assessment Test

View Test

Business Intelligence Analyst Test

View Test

Business Analyst Aptitude Online Assessment Test

View Test

Financial Risk Management

View Test

Data Interpretation Test

View Test

Excel Online Assessment Test

View Test

Microsoft Office 365

View Test

Pre-employment English Online Assessment Test (Advanced)

View Test

Fluid Intelligence Online Assessment Test

View Test

SQL Online Test

View Test

Qlik Sense Assessment Test

View Test

Tableau Online Test

View Test

About Adaface Excel Questions

Adaface Excel questions are designed by Excel experts to test for on-the-jobs skills, not just theoretical knowledge. Some of the popular topics the questions will cover are:

Sum or Count cells
Pivot Tables
Formulae
Drop down list
Sorting
VLOOKUP
CONCATENATE
Conditional Formatting
Charting
VBA & Macros
Data Tables, Simulations & Solver
Circular References
Formula Auditing
INDEX + MATCH
Power Query
Forecasting & Trend Analysis

Types of Excel Questions to expect at Adaface:

The following statements describe the type of Excel questions one can expect when using Adaface's pre-assessment tool:

Practical implication based Excel questions
Real on-the-job scenario-based Excel problems
Evaluations to test analytical thinking while solving problems
Progressive difficulty based Excel problems

What Topics are Adaface Excel questions based on:

Adaface Excel questions are designed by experts in Excel to test for on-the-job skills. Some of the popular topics the questions will cover are:

Cells
Rows
Columns
Unique Cell Address
Formatting
Comments
Charts
Freeze
Workbook
Spreadsheet
Formula
Ribbon
Reports
Pivot
Function
Mathematical Operations
Look Up
Macro
Vlookup
Protect workbook
Filter

How are Adaface Excel questions customized?

Adaface Excel questions are customized for different difficulty levels and solving durations
Customized to assess Ideal candidate personas for right jobs
Tests for specific on-the-job Excel skills
Non-googleable questions to prevent cheating during tests

Do’s and Don’ts of selecting Excel questions for assessments:

Do’s:

Use diversified questions from varied Excel topics to test the skill range of candidates
Utilize questions of different difficulty levels to test candidates
Include questions that are related to on-the-job skill requirements
Pick questions that are relevant for the experience level you are targeting
Make sure the questions can be understood by a non-native English speaker (easy-to-read questions because programmers should spend time solving the question, not understanding it)
Ensure that the questions have a granular (non-binary) scoring
Use aptly timed assessments that can be fulfilled within 45-60 mins to make the most optimal use of the time utilized

Don’ts:

Avoid using trick questions to test the candidates as they are ineffective in testing their on-the-job skills
Avoid using lengthy questions as they do not provide an ideal scenario to test the candidates
Avoid unnecessary puzzle trends as they are ineffective in assessing the skills required for the job
Avoid questions that test very niche concepts that a strong candidate might or might not have come across on-the-job
Do not include unnecessarily difficult questions that might or might not test the candidates potential

Want more questions? Here are some more sample questions from our library

🧐 Question	🔧 Skill	💪 Difficulty	⌛ Time
Decision Table - Check the following decisio...	Testing	Medium	3 min
Arrays and Exceptions - What is the output of the f... Arrays Exceptions	C#	Easy	2 min
With, AVG & SUM - Consider the following SQL ...	SQL	Medium	2 min
Struct Class - What will the following C++...	C++	Medium	2 min
Rebuilding index - Our Jira has 26,245 active ...	Jira	Easy	2 min
Remote network resources - Review the following exhibit:	Computer Networks	Medium	3 min
Dropdown menu UX - Your friend is trying to st...	UX	Medium	2 min

We evaluated several of their competitors and found Adaface to be the most compelling. Great default library of questions that are designed to test for fit rather than memorization of algorithms.

Swayam

CTO, Affable

Use the most candidate friendly assessment tool

TRY FOR FREE

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

The most candidate friendly assessment tool on the market

Adaface Assessments

Assessments Pricing

Singapore (HQ)
32 Carpenter Street, Singapore 059911

Contact: +65 9447 0488
India
2gethr @ HSR No.11/A-12, 14th Main Road, 4th Cross Road, Sector 5, 1st Sector, HSR Layout, Bengaluru, Karnataka 560102
Contact: +91 6305713227
US

Contact: +1 (719) 628 7485