Adaface is the most candidate friendly skills assessment tool on the market. Learn more.

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
JavaScript C C# COBOL C++ R Java Go Kotlin Embedded C Perl PHP Python Ruby Scala Rust Swift TypeScript CSS HTML/CSS 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 Azure AWS Windows Administration Computer Networks Azure Data Factory Selenium Testing PowerShell Shell Scripting Jest Linux Jenkins JUnit Protractor UX SEO Product Management Business Analysis 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 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 Dynamics 365 SCM Dynamics 365 Finance 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 Amazon Redshift 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

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

Adaface Excel questions are used by enterprises worldwide

Morgan Stanley
SG Government
Ernst and Young
Optimum Solutions
Love Bonito

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

🧐 Test 🔧 Sample Topics 💪 Useful for hiring
Business Intelligence Analyst Test
logistic concepts
microsoft office
Analytical thinking
operations concepts
written communication
Senior Business Intelligence Business Analyst (1-3 years experience)
Junior Business Intelligence Business Analyst (0-2 years experience)
Business Analyst - Analytics
Business Analyst - Data and Technology
Business Intelligence Analyst
Business Analyst Aptitude Online Assessment Test
Analytical Thinking
Data Interpretation
Data Sufficiency
Listening Skills
Writing Skills
Junior Business Analyst
Senior Business Analyst
Financial Risk Management Test
Capital Budgeting
Risk and Return
Types of Risk
Systematic and Unsystematic Risk
Unexpected Loss
Risk Management Officer
Risk Management Analyst
Finance Risk Manager
Financial Risk Analyst
Data Interpretation Test
Pie Chart
Bar Chart
Line Chart
ratio- proportion problems on the data
percentage increase-decrease problems
Data Scientists
Data Analysts
Research Analyst
Lead –Data Analyst
Excel Online Assessment Test
data manipulation
conditional formatting
data summarization
pivot tables
Data Analyst
Business Analyst
Financial Analyst
Market Research Analyst
Microsoft Office 365 Test
Customizations and developments
Query conditions
BCS services
Site collection
Sharepoint foundation 2013
OData connection
Sharepoint library
SharePoint Office 365 Developer
Office 365 Consultant
Basic Aptitude Test
Administrative Assistants
Pre-employment English Online Assessment Test (Advanced)
Reading comprehension
verbal reasoning
Blog Writer
Content Writer
Customer facing roles
Technical writer
Secretary positions
Fluid Intelligence Online Assessment Test
abstract reasoning
critical thinking
diagrammatic reasoning
deductive reasoning
inductive reasoning
problem solving
pattern matching
spatial reasoning
The Raven’s Progressive Matrices
Guilford’s test of Divergent Thinking
Torrance Test of Creative Thinking
Data Analyst
System Admin
Front-office roles
SQL Online Test
SQL Data Types and Literals
SQL Operators
SQL Functions
SQL Tables
Commands and clause
Junior SQL Developer
SQL Programmer
SQL Coder
SQL Database Administrator
Qlik Sense Assessment Test
QlikSense - Scripting
QlikSense - UX
QlikSense - Expressions
QlikSense - QMC
QlikSense - Publishing
Qlik Sense Developer
Qlik Sense BI Developer
Qlik Sense Consultant
Tableau Test
Tableau Marks
Geographical Data
Data Merging
Tableau Extracts
Tableau Filters
Tableau Actions
Tableau Drill
Tableau Aggregations
Tableau Developer
Business Analyst Excel Test
Business Cases
Stakeholder Processes
Worksheet and Charts
MS Excel Functions
MS Excel Formulas
Business Analyst
Advanced Excel Online Test
Auditor Excel Test
Audit of Inventories
Internal Auditing
Balance Sheet Audit
Worksheet and Charts
Internal Auditor
Logical reasoning Test
abstract reasoning
critical thinking
diagrammatic reasoning
deductive reasoning
inductive reasoning
problem solving
pattern matching
Data Analyst
System Admin
Front-office roles
Critical Thinking Online Assessment Test
Critical Thinking
Logical Reasoning
Lateral Thinking
Graphic Designer
Project Manager
Software Developer
Software Tester
Business Analyst
Data Analyst
Sales Representatives
Chief Executives
Treasurers and Controllers
Financial Analyst Online Aptitude Assessment Test
Financial Analyst Test
Financial & Excel Modeling Test
Time Value of money - net present value
internal rate of return
Financial Analysis
Asset Valuation
Stock Valuation
Risk And Return - from various asset classes
Calculation of rate of return
Capital Asset Pricing Model
Excel Macros
Financial and Modeling Analyst
Financial Modelling Consultant
Finance Research Manager
Financial Modeling Specialist
Accounting and Finance Test
Accounting Principles
journal entries
ledgers entries
trial balance
Profit & Loss Statement
Balance Sheet
provisions depreciation
Cash Flow Inventory
Valuation Ratio Analysis
Basic financial statements
fixed assets
debits and credits
chart of accounts
accounts receivable
double-entry bookkeeping
Financial Accountant
Assistant Financial Accountant
Financial Analyst
Financial Manager
Management Accountant
Staff Accountant
Financial Reporting Accountant
Senior Financial Analyst
Accounting Aptitude Test
Accounting Fundamentals
Numerical Reasoning
Verbal Reasoning
Logical Reasoning
Finance/Accounts Trainee
Accountant Associates/ Executives
Data Analyst Excel Test
MS Excel Advance
Numerical Reasoning
Data Analyst
Business Intelligence Analyst Test
View Test
Business Analyst Aptitude Online Assessment Test
View Test
Financial Risk Management Test
View Test
Data Interpretation Test
View Test
Excel Online Assessment Test
View Test
Microsoft Office 365 Test
View Test
Basic Aptitude Test
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 Test
View Test
Business Analyst Excel Test
View Test
Advanced Excel Online Test
View Test
Auditor Excel Test
View Test
Logical reasoning Test
View Test
Critical Thinking Online Assessment Test
View Test
Financial Analyst Online Aptitude Assessment Test
View Test
Financial & Excel Modeling Test
View Test
Accounting and Finance Test
View Test
Accounting Aptitude Test
View Test
Data Analyst Excel 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
  • Conditional Formatting
  • Charting
  • VBA & Macros
  • Data Tables, Simulations & Solver
  • Circular References
  • Formula Auditing
  • 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:


  • 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


  • 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
Liquid array - What would the output of th...
Shopify Easy 2 min
Linear Layout - Check the following XML lay...
Android Easy 2 min
Check if dialog dismissed - Emily is testing a web app....
Selenium Medium 2 min
Count, Distinct, SubQuery - Consider the following MySQ...
MySQL Medium 2 min
Multiple Namespaces - Class Student exists in bot...
C# Medium 2 min
Change display icon - What steps would you take t...
Tableau Easy 2 min
Emma's cafe business - Emma's cafe has been operat...
Critical Thinking 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 profile image
CTO, Affable
Use the most candidate friendly assessment tool

(100% za darmo, aby zacząć, nie wymaga karty kredytowej)

Warunki Prywatność Trust Guide