Excel 1 - SV - SV settings
The Everyday Excel UserTest in Swedish with Excel in Swedish settings. Ideal for candidates with limited data-intensive tasks or complex models. Assesses general proficiency in everyday use.
Date
16 Nov 2026
| Candidate |
Henrik Dennerheim (mock-up) |
| Competence |
Basic Proficiency - Level: 2 of 4 |
| Time spent |
05:08 of 40:00 |
| Issuer |
Demo Kunskapstest, EPROVED |
The candidate demonstrates basic knowledge of business control.
Beginner
0% - 24%
Basic Proficiency
25% - 49%
Competent
50% - 76%
Skilled
77% - 100%
The candidate demonstrates strong knowledge in business performance monitoring and, in addition to interpreting charts and tables, can provide in-depth explanations of variances, such as deviations from the budget or forecast. They can analyse the reasons for deviations in results, assess underlying revenue, and derive insights into revenue through margin and growth, among other factors.
The candidate has basic knowledge of financial management and understands commonly used performance metrics, ratios, and Key Performance Indicators (KPIs). They are also familiar with concepts such as budget and forecast.
The candidate demonstrates strong knowledge in investment analysis and is proficient in product and investment calculations at an advanced level. They are capable of performing sensitivity analysis, assessing the impact of price increases on sales volume and profitability, and determining necessary price levels based on the distribution of profits in the value chain, among other skills.
The candidate demonstrates a basic level of proficiency, with a solid understanding of fundamental functions such as SUM, COUNT, and AVERAGE. While they show some familiarity with logical functions, there is clear room for improvement in their ability to apply more advanced functions, including VLOOKUP, HLOOKUP, and IF.
N/A - Coming soon
Unfortunately there isn't enough data for the candidate profile yet.
At present, there is not enough benchmark data collected for the test-takers to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Specialist, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the test-takers to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Specialist, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the test-takers to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Specialist, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Specialist, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Specialist, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Specialist, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Specialist, 10+ yrs) to generate a meaningful comparison.
| Question | Question area | Question type | Time | Status | Level |
|---|---|---|---|---|---|
| 5 | Investment Analysis |
Charts: evaluating the profitability of a customer order for the selling company (given different costs in the value chain)
1 of 2 correct answers and 0 wrong and got 1.5 out of 3 points |
00:07 | Difficult | |
| 8 | Functions in Excel |
INDEX, MATCH
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:07 | Difficult | |
| 12 | Business Monitoring |
Staff turnover analysis: deriving the number of people recruited during a year
0 of 1 correct answers and 1 wrong and got 0 out of 3 points |
00:07 | Difficult | |
| 14 | Functions in Excel |
DGET
0 of 1 correct answers and 1 wrong and got 0 out of 3 points |
00:10 | Difficult | |
| 16 | Investment Analysis |
Investment appraisal: calculating and assessing investment options
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:06 | Difficult | |
| 17 | Financial Management |
Change in working capital: impact on cash flow
0 of 2 correct answers and 1 wrong and got 0 out of 3 points |
00:08 | Difficult | |
| 20 | Financial Management |
Capital tied up: assessing the effects on profitability and cash flow
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:07 | Difficult | |
| 21 | Business Monitoring |
Analysis: deriving net sales from margin and growth
0 of 1 correct answers and 1 wrong and got 0 out of 3 points |
00:07 | Difficult | |
| 1 | Functions in Excel |
XLOOKUP
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
01:16 | Easy | |
| 2 | Functions in Excel |
COUNT
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
| 6 | Business Monitoring |
Charts: interpreting a progressive curve
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
| 13 | Investment Analysis |
Product costing: understanding contribution margin
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:06 | Easy | |
| 18 | Financial Management |
Key ratios: calculating the equity/assets ratio
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
| 19 | Financial Management |
Profit measures: calculating the amount of depreciation from a set of financial statements (residual value)
0 of 1 correct answers and 1 wrong and got 0 out of 1 points |
00:07 | Easy | |
| 22 | Business Monitoring |
Charts: illustrating sales in SEK and margin in percentage in the same chart
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:06 | Easy | |
| 24 | Investment Analysis |
Investment appraisal: understanding break-even
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
01:01 | Easy | |
| 3 | Business Monitoring |
Calculating purchases of goods from the income statement and balance sheet (using opening and closing inventory and cost of goods sold)
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:08 | Intermediate | |
| 4 | Investment Analysis |
Investment appraisal: assessing in which year break-even is reached (when the investment becomes profitable)
0 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:07 | Intermediate | |
| 7 | Financial Management |
Choosing situations in which data should be presented on a rolling 12-month basis, taking account of seasonal variations
1 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:08 | Intermediate | |
| 9 | Functions in Excel |
IF
0 of 2 correct answers and 1 wrong and got 0 out of 2 points |
00:06 | Intermediate | |
| 10 | Business Monitoring |
Table: assessing revenue per consultant against the previous year (with calendar effect)
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:07 | Intermediate | |
| 11 | Investment Analysis |
Product costing: assessing the most profitable product (contribution margin and break-even in relation to fixed costs and profit)
0 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:07 | Intermediate | |
| 15 | Financial Management |
Key ratios: calculating the operating margin as a decimal
0 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:07 | Intermediate | |
| 23 | Functions in Excel |
COUNTIF / Counting with one criterion
0 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:07 | Intermediate |
Correct answer
Weighted point, partly right on the question
Wrong answer
Either skipped or out of time
TEST AREAS
"REPORTING VS. BUSINESS-ORIENTED PROFILES"
A test in English that differentiates candidates handling basic follow-up tasks from those with strategic, business-oriented profiles experienced in working with and analysing large datasets.
Business Monitoring
The candidate's knowledge, ranging from basic aspects such as interpreting and understanding charts, assessing profitability, the meaning of correlation, variance against budget, forecast, and prior year, explaining deviations, evaluating key performance indicators in the business etc, to more advanced areas – for example analysis of underlying revenue, deriving revenue through margin and growth, deriving purchases, calculating the number of employees in an equilibrium state, etc.
Financial Management
Skills in various performance metrics in the business, Key Performance Indicators (KPIs), commonly accepted ratios, budget, forecast, operational risk, capital allocation, credit terms, etc.
Investment Analysis
The candidate's proficiency in investment calculations – including understanding of key parameters, Present Value, and break-even analysis – as well as the ability to evaluate various investment options from a profitability perspective, product costing, contribution margin, price adjustments with sensitivity analysis, and identifying profits in the value chain, among other aspects.
Functions in Excel
Usage of various data functions such as SUM, COUNT, AVERAGE, VLOOKUP, HLOOKUP, DGET, INDEX, MATCH, and various logical functions – for example, IF, AND, OR, summation with one criterion through SUMIF, COUNTIF, and summation with multiple criteria through SUMIFS, COUNTIFS, etc.
TEST QUESTIONS
Multiple Choice
Our tests are mainly based on multiple-choice questions where the number of correct answer options varies. Each question has four answer options.
Questions by Area and Difficulty
The tests are divided into four question areas and questions are categorised into three difficulty levels: easy, intermediate and difficult.
Randomised Test Generation
Questions within each area and difficulty level are randomly selected from a question bank, ensuring that each test receives a unique set of questions. Additionally, the order of answer options is randomised so that the correct answer for each question never appears in the same position.
24 Questions and Multimedia Options
A total of 24 questions are generated and must be answered within 40 minutes. During the test, candidates can skip questions and come back to them later. They also have access to a timer and a progress indicator. The test will automatically close when the maximum time limit is reached.
Test questions and answer options can consist of text, images, or a combination of text and images.
Example Question