TEST AREAS
"FOR DATA-HEAVY TASKS"
Test in English with Excel in English settings. Specialised in functions and data management. Suitable for candidates handling large data sets.
References & Text Functions
Absolute and relative references when copying cells, the meaning of circular references, consequences on formulas when deleting rows or columns, etc, as well as the use of text functions such as LEFT, RIGHT, TRIM, CLEAN, CONCATENATE, replacing text as part of a text string with MID and REPLACE, converting text to numbers with VALUE, and various date functions such as MONTH, EOMONTH, NETWORKDAYS, etc.
Data Functions & Logical Functions
The usage of various data functions like SUM, COUNT, AVERAGE, VLOOKUP, COLUMN, HLOOKUP, INDEX, MATCH, LEFT, RIGHT, and various logical functions – for example, IF, AND, OR, summation with a criterion using SUMIF, COUNTIF, and summation with multiple criteria through SUMIFS, COUNTIFS, etc.
Tables & Charts
Skills in data summarisation, such as creating charts and tables, pivot tables, managing various chart types, interpreting charts, filtering and sorting tables, multi-level filtering, varying pivot tables, knowledge of PowerPivot, basic commands for SQL databases, etc.
Organise Data
Skills in handling and structuring data in spreadsheets, such as selecting cells and copying or moving data, inserting notes, searching and replacing text in cells, converting text to columns, removing duplicates, grouping rows and columns, linking to other worksheets and workbooks, "Paste Special," transposing data, advanced filtering, data validation, etc.
TEST QUESTIONS
In this Excel test, English settings are used.
Multiple Choice
Our tests are mainly based on multiple-choice questions where the number of correct answer options varies. Each question has four answer options.
Questions by Area and Difficulty
The tests are divided into four question areas and questions are categorised into three difficulty levels: easy, intermediate and difficult.
Randomised Test Generation
Questions within each area and difficulty level are randomly selected from a question bank, ensuring that each test receives a unique set of questions. Additionally, the order of answer options is randomised so that the correct answer for each question never appears in the same position.
24 Questions and Multimedia Options
A total of 24 questions are generated and must be answered within 30 minutes. During the test, candidates can skip questions and come back to them later. They also have access to a timer and a progress indicator. The test will automatically close when the maximum time limit is reached.
Test questions and answer options can consist of text, images, or a combination of text and images.
Example Question
