Explore EPROVED
Login

Purchase test

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

Excel 2 - SV - EN settings

Swedish
Excel
Global
30 min
Functions | Data Management

Test in Swedish with Excel in English settings. Specialised in functions and data management. Suitable for candidates handling large data sets.
Example question
Bild Data Functions & Logical Functions - Nya plattformen (ENG settings)
Example report

2295 SEK /test

Included Show more Show less
  • 10% off – test 2 candidates – code ‘X2SETEST2’ at checkout
  • 15% off – test 3 candidates – code ‘X2SETEST3’ at checkout
  • 20% off – test 4+ candidates – code ‘X2SE4PLUS’ at checkout

Candidate information

Candidate 1 Show more Show less
Scroll down

Test in Swedish with Excel in English 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.

Bild References & Text Functions - Nya plattformen (ENG settings)

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
Bild Data Functions & Logical Functions - Nya plattformen (ENG settings)

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.
Bild Tables & Charts - Nya plattformen (ENG settings)

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.
Bild Organise Data - Nya plattformen (ENG settings)

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.
✔ All changes have been saved!
Cookies

This website uses cookiesfor statistics and user experience.

This website uses cookies to improve your user experience, to provide a basis for improvement and further development of the website and to be able to direct more relevant offers to you.

Feel free to read ours privacy notice. If you agree to our use, choose Accept all. If you want to change your choice afterwards, you will find that option at the bottom of the page.