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 |
Competent - Level: 3 of 4 |
| Time spent |
04:44 of 40:00 |
| Issuer |
Demo Kunskapstest, EPROVED |
The candidate demonstrates strong knowledge of financial management and business analysis and is proficient in financial analysis, budgeting and forecasting, business monitoring and investment appraisal.
Beginner
0% - 24%
Basic Proficiency
25% - 49%
Competent
50% - 76%
Skilled
77% - 100%
The candidate demonstrates basic knowledge of the income statement and balance sheet, including format, equity and liabilities, and the ability to distinguish between key items.
The candidate demonstrates extensive and in-depth knowledge of financial analysis and masters the underlying relationships, such as the leverage formula, DuPont, adjusted equity and the impact of working capital on cash flow.
The candidate demonstrates strong knowledge of financial management and can handle operational risk, cost structures, full costing and budget processes, and understand their impact on profitability.
The candidate has basic knowledge of business monitoring and can interpret commonly used charts and tables and assess profitability and growth.
The candidate has basic knowledge of investment analysis, understands break-even, contribution margin and payback, and can assess investment options at a general level.
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 - Manager, 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 - Manager, 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 - Manager, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Manager, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Manager, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Manager, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Manager, 10+ yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Other - Manager, 10+ yrs) to generate a meaningful comparison.
| Question | Question area | Question type | Time | Status | Level |
|---|---|---|---|---|---|
| 5 | Business Monitoring |
Analysis, deriving revenue through margin and growth
0 of 1 correct answers and 1 wrong and got 0 out of 3 points |
00:07 | Difficult | |
| 6 | Financial Analysis |
Calculate the Impact of Working Capital on Cash Flow
1 of 2 correct answers and 0 wrong and got 1.5 out of 3 points |
00:06 | Difficult | |
| 7 | Investment Analysis |
Charts, evaluate the profitability of a customer order for the selling company (given various 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 | Financial Management |
Margins in the value chain, identify product(s) for price increase through analysis of product mix and sales
0 of 1 correct answers and 1 wrong and got 0 out of 3 points |
00:08 | Difficult | |
| 10 | Financial Analysis |
The Components of the Leverage Relationship
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:07 | Difficult | |
| 11 | Financial Management |
Transfer pricing between divisions: avoiding sub-optimisation
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:07 | Difficult | |
| 16 | Business Monitoring |
Analysis of employee turnover, derive the number of employed personnel over a year
0 of 1 correct answers and 1 wrong and got 0 out of 3 points |
00:07 | Difficult | |
| 18 | Income Statement & Balance Sheet |
Operating Lease, Impact on Income Statement and Balance Sheet
1 of 2 correct answers and 1 wrong and got 0 out of 3 points |
00:33 | Difficult | |
| 19 | Investment Analysis |
Charts, assess the rolling 12-month revenue trends of different product categories and internal allocation
1 of 2 correct answers and 1 wrong and got 0 out of 3 points |
00:07 | Difficult | |
| 26 | Income Statement & Balance Sheet |
Meaning of Comprehensive Income
1 of 3 correct answers and 1 wrong and got 0 out of 3 points |
00:07 | Difficult | |
| 1 | Financial Management |
Various performance metrics, calculate the size of depreciation based on a Financial Statement (Residual Value)
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:11 | Easy | |
| 2 | Financial Management |
Forecast vs budget, handling a deviation
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
| 9 | Investment Analysis |
Investment calculations, necessary information for conducting a present value calculation
2 of 2 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
| 13 | Income Statement & Balance Sheet |
Order of current assets in the balance sheet under the ÅRL format
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
| 15 | Income Statement & Balance Sheet |
Year-end appropriations, group contributions
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
| 20 | Investment Analysis |
Investment appraisal: calculate the payback period
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
| 27 | Business Monitoring |
Charts, interpretation of a progressive curve
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
| 28 | Financial Analysis |
Calculate Debt-to-Equity Ratio
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
| 29 | Financial Analysis |
Calculate Interest Coverage Ratio
0 of 1 correct answers and 1 wrong and got 0 out of 1 points |
00:07 | Easy | |
| 30 | Business Monitoring |
Evaluating profitability, highest earnings in SEK vs. highest margin in percentage
0 of 1 correct answers and 1 wrong and got 0 out of 1 points |
00:32 | Easy | |
| 3 | Financial Management |
Selecting situations when data should be presented on a rolling 12-month basis, considering seasonal variations
1 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:07 | Intermediate | |
| 4 | Investment Analysis |
Product costing, calculate & assess profitability
2 of 2 correct answers and 0 wrong and got 2 out of 2 points |
00:07 | Intermediate | |
| 12 | Investment Analysis |
Investment calculations, assessing the year for break-even (when the investment becomes profitable)
0 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:07 | Intermediate | |
| 14 | Income Statement & Balance Sheet |
Income Statement in the Parent Company
1 of 2 correct answers and 0 wrong and got 1 out of 2 points |
00:07 | Intermediate | |
| 17 | Financial Management |
Full costing: calculate the unit cost using overhead rates
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:07 | Intermediate | |
| 21 | Income Statement & Balance Sheet |
Meaning of Free Cash Flow
2 of 3 correct answers and 0 wrong and got 1.3 out of 2 points |
00:07 | Intermediate | |
| 22 | Business Monitoring |
Actual vs. budget, explain deviations in operating income
1 of 2 correct answers and 0 wrong and got 1 out of 2 points |
00:07 | Intermediate | |
| 23 | Business Monitoring |
Variance analysis: split the deviation against budget into volume and price variances
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:07 | Intermediate | |
| 24 | Financial Analysis |
Derive Purchases through the Income Statement and Balance Sheet
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:07 | Intermediate | |
| 25 | Financial Analysis |
Accounts Receivable, Calculate Credit Period
1 of 1 correct answers and 0 wrong and got 2 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
“BUSINESS PARTNER”
A test in English for finance managers acting as business partners to management, based on Swedish GAAP. Covers the financial statements and their analysis, financial management and control, business monitoring and follow-up, and investment analysis.
Income Statement & Balance Sheet
The candidate's knowledge of the income statement and balance sheet, ranging from presentation formats under the Swedish Annual Accounts Act (ÅRL), the order of fixed assets, restricted equity, short-term liabilities and year-end appropriations, to performance measures, funds and new issues, free cash flow, customer advances and accrued income, provisions, capitalised tax loss carryforwards, comprehensive income, leases and the ability to identify misclassifications in a balance sheet.
Financial Analysis
Proficiency in recognised financial key ratios such as solvency, debt-to-equity ratio, interest coverage ratio, quick ratio and return measures, the indirect cash flow method, credit periods and capital lock-up, and deriving purchases from the financial statements. Additionally, more complex analysis such as the leverage formula, the DuPont relationship (profit margin and asset turnover over several years), adjusted equity, deriving total assets from key ratios and the impact of working capital on cash flow.
Financial Management
The candidate's skills in management control, including Key Performance Indicators (KPIs), budget and forecast, operational risk, variable and fixed costs, full costing with overhead rates, budget processes and rolling forecasts, rolling 12-month reporting, margins in the value chain, choosing KPIs for a business unit, transfer pricing and sub-optimisation, forecast revisions and cash budgets.
Business Monitoring
The candidate's knowledge ranges from interpreting charts and tables, assessing profitability and growth, the meaning of correlation, calendar effects and holiday pay liability, to variance analysis against budget, forecast and prior year (including volume and price variances), deriving revenue through margin and growth, analysing underlying revenue and key performance indicators, and deriving headcount from staff turnover.
Investment Analysis
The candidate's proficiency in investment and product calculations, including key parameters, present value, payback period, break-even and contribution margin, assessing when an investment becomes profitable, product profitability with limiting factors, market entry assessment, net present value comparisons, required price levels and customer profitability in the value chain, rolling 12-month trends and sensitivity analysis of price increases.
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 five 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.
30 Questions and Multimedia Options
A total of 30 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