TEST AREAS
"THE EVERYDAY EXCEL USER"
Test in English with Excel in English settings. Ideal for candidates with limited data-intensive tasks or complex models. Assesses general proficiency in everyday use.
Functions
Testing of absolute and relative cell references when copying cells, understanding circular references, consequences on formulas when removing rows or columns, as well as the use of functions such as SUM, AVERAGE, MIN, MAX, and various logical functions – for example, VLOOKUP, IF, AND, OR, SUMIF, COUNTIF, SUMIFS, and more. Text, data, and date-related functions are also assessed, including LEFT, RIGHT, CONCATENATE, TEXT, REPLACE, as well as INDEX, MATCH, VLOOKUP, and NETWORKDAYS.
Formatting
The candidate's proficiency in both basic and advanced Excel formatting will be assessed. This includes simple formatting tasks such as changing font color, adjusting column width, modifying decimals, text alignment in cells, wrapping text, and copying formats. Additionally, the candidate's skills in advanced formatting techniques will be evaluated, including but not limited to Paste Special, AutoFormat, Conditional Formatting, sheet protection, locked cells, ClipArt, SmartArt, and more.
Data Management
Skills in both basic data management such as creating charts and tables, different types of charts, filtering and sorting tables to more advanced data management – for example, creating and managing PivotTables, data validation, grouping rows and columns, external data with links to other worksheets and workbooks, advanced filtering, Goal Seek, etc.
Methods
This includes managing the software such as opening and saving workbooks including older versions, prints and print areas, page layout, freezing and arranging panes, protecting worksheets and workbook, external data sources, importing data, form controls, macros, 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
