Adaface Public Excel Questions

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