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

Purchase test

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

Excel 1 - SV - SV settings

Swedish

Excel

Sweden

30 min

Functions | Formatting | Data Management | Methods

Test in Swedish with Excel in Swedish settings. Ideal for candidates with limited data-intensive tasks or complex models. Assesses general proficiency in everyday use.

Example question

Example report

1995 SEK /test

Included Show more Show less

10% off – test 2 candidates – code ‘X1SSTEST2’ at checkout
15% off – test 3 candidates – code ‘X1SSTEST3’ at checkout
20% off – test 4+ candidates – code ‘X1SS4PLUS’ 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.

Functions

Absolute and relative cell references when copying cells
Understanding circular references, consequences on formulas when removing rows or columns
The use of functions such as SUM, AVERAGE, MIN, MAX
Logical functions – VLOOKUP, IF, AND, OR, SUMIF, COUNTIF, SUMIFS, and more
Text, data, and date-related functions – LEFT, RIGHT, CONCATENATE, TEXT, REPLACE, INDEX, MATCH, VLOOKUP, and NETWORKDAYS

Data Management

Creating charts and tables, different types of charts
Filtering and sorting tables
Creating and managing PivotTables
Data validation, grouping rows and columns
External data with links to other worksheets and workbooks
Advanced filtering, Goal Seek, etc.

Formatting

Simple formatting tasks such as changing font color, adjusting column width, modifying decimals
Text alignment in cells, wrapping text, and copying formats
Advanced formatting techniques – Paste Special, AutoFormat, Conditional Formatting
Sheet protection, locked cells
ClipArt, SmartArt, and more

Methods

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.