Welcome to our new website!

Test

Excel 2 - SV - EN settings

For Data-Heavy Tasks

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.
Se exempelfråga
Example report

SINGLE PURCHASE

SEK 2,295 / TEST

  • Full refund if not satisfied
  • Free help interpreting results
Purchase test

SUBSCRIPTION

FR. SEK 995 / MONTH

Pricing
Scroll down

What our test covers

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

  • Absoluta och relativa referenser vid kopiering av celler
  • Förståelse av cirkelreferenser samt konsekvenser för formler vid borttagning av rader eller kolumner
  • Användning av textfunktioner som LEFT, RIGHT, TRIM, CLEAN, CONCATENATE
  • Ersätta text i en textsträng med MID och REPLACE
  • Konvertera text till tal med VALUE
  • Olika datumfunktioner som 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 PowerPivot
  • 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.

References

We have assisted numerous clients in achieving better recruitment outcomes. Let us help you too!

"Vi har använt EPROVED:s redovisningstest i samband med två nyligen gjorda rekryteringar. Det är ett värdefullt komplement vid en rekrytering. Forskning visar att ett arbetstest är en väldigt viktig del för en lyckad rekrytering."
screenshot-196-

Anders Eckerwall

Head of Finance

"The Excel proficiency test played a key role in ensuring the quality of our recruitment. We were very satisfied with the service and received prompt, professional attention. The results were a crucial component in our final selection process."
anna-hemmingsson-hr-manager-com-hem-originalbild

Anna Hemmingsson

HR Manager

"We are very pleased with the tests and believe they provide a solid foundation as part of our candidate evaluation process."
madelene-steinert

Madelene Steinert

Talent Search & Recruitment Specialist

"Our partnership with EPROVED has successfully met our expectations in our recruitment efforts. Their attentiveness to our requirements have left us thoroughly impressed!"
ihm-anna-w-portrattbilder-8955

Anna Weinsjö

Antagningsansvarig

"We've utilised the accounting proficiency test multiple times and are extremely pleased with its outcomes and the service provided. This tool has been instrumental in enhancing the quality of our recruitment process, especially for senior roles. We wholeheartedly endorse it."
inez-andersson-recruitment-consultant-newsec-originalbild

Inez Andersson

Recruitment Consultant

"EPROVED's accounting test offers user-friendly management, enabling us to efficiently distribute it to our candidates – a significant advantage for us. Additionally, we've been able to tailor the test to meet our specific needs, such as aligning it with our candidates' experience levels."
beatrice-magnusson-bild

Beatrice Magnusson

Recruiter

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 policy. 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.