Test

Excel 1 - EN - EN settings

The Everyday Excel User

English

Excel

Global

30 MIN

Functions | Formatting | Data Management | Methods

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.

Example report

SINGLE PURCHASE

1 995 SEK / 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 English 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.

Functions

Absolute and relative cell references when copying cells
Understanding circular references and the consequences for formulas when deleting rows or columns
Use of functions such as SUM, AVERAGE, MIN, MAX
Logical functions – VLOOKUP, IF, AND, OR, SUMIF, COUNTIF, SUMIFS, etc.
Text, data, and date functions – LEFT, RIGHT, CONCATENATE, TEXT, REPLACE, INDEX, MATCH, VLOOKUP, and NETWORKDAYS

Data Management

Create charts and tables, different types of charts
Filter and sort tables
Create and manage 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 colour, adjusting column width, modifying decimals
Text alignment in cells, wrapping text, and copying formats
Advanced formatting techniques – Paste Special, AutoFormat, Conditional Formatting
Worksheet protection, locked cells
ClipArt, SmartArt, and more

Methods

Opening and saving workbooks, including older versions
Printing and print areas
Page layout, freezing and arranging panes
Protecting worksheets and workbooks
External data sources, importing data
Form controls, macros, etc.

References

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

Request a Live Demo

Let us know that you're interested in a live demo, and we will get back to you as soon as possible to schedule it with you.

CONTACT DETAILS

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

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

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

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!"

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

"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

Recruiter

This website uses cookiesfor statistics and user experience.