Excel 2 - SV - SV settings - Employer Solutions Nordic AB

Purchase test

Please ensure that you enter the correct email address for the candidate!

Excel 2 - SV - SV settings

Swedish

Excel

Sweden

30 min

Functions | Data Management

Test in Swedish with Excel in Swedish settings. Specialised in functions and data management. Suitable for candidates handling large data sets.

Example question

Example report

2295 SEK /test

Included Show more Show less

10% off – test 2 candidates – code ‘X2SSTEST2’ at checkout
15% off – test 3 candidates – code ‘X2SSTEST3’ at checkout
20% off – test 4+ candidates – code ‘X2SS4PLUS’ at checkout

Candidate information

Candidate 1 Show more Show less

Candidate’s name...

Candidate’s email...

Scroll down

Test in Swedish with Excel in Swedish settings. Suitable for all seniority levels. Covers four areas with 24 multiple-choice questions at easy, intermediate, and difficult levels. Questions and answer order are randomly generated, ensuring unique yet comparable tests.

References & Text Functions

Absolute and relative references when copying cells
The meaning of circular references, consequences on formulas when deleting rows or columns
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
Various date functions such as MONTH, EOMONTH, NETWORKDAYS

Data Functions & Logical Functions

The usage of various data functions like SUM, COUNT, AVERAGE, VLOOKUP, COLUMN, HLOOKUP, INDEX, MATCH, LEFT, RIGHT
Various logical functions – for example, IF, AND, OR
Summation with one criterion using SUMIF, COUNTIF
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 Power Pivot
Basic commands for SQL databases, etc.

Organise Data

Handling and structuring data in spreadsheets
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.