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
08 May 2025
Candidate: |
Henrik Dennerheim |
Competence: |
Basic Proficiency - level: 2 of 4 |
Time spent: |
04:37 of 30:00 |
Issuer: |
Demo Kunskapstest, EPROVED |
The candidate demonstrates basic knowledge of financial control in accounting and financial analysis.
Beginner
0% - 24%
Basic Proficiency
25% - 49%
Competent
50% - 76%
Skilled
77% - 100%
The candidate demonstrates basic knowledge of an income statement and a balance sheet, including their meaning, format, and the ability to distinguish between key items.
The candidate exhibits strong skills in financial analysis and is capable of managing various key ratios, assessing profitability, evaluating financial position, and analysing capital binding, among other areas.
The candidate exhibits strong proficiency in closing accounts, including reconciliations, accruals, inventory, taxes, and VAT, and is likely capable of independently managing financial closings.
The candidate demonstrates basic theoretical knowledge in accounting, including simple definitions, familiarity with accounts receivable and accounts payable, an understanding of the fundamentals of debit and credit, and knowledge of some common accounts in accounting.
N/A - Coming soon
Unfortunatly there isn't enough data for the candidateprofile 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 (Financial Control - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Financial Control - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Financial Control - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Financial Control - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Financial Control - Specialist, 4-6 yrs) to generate a meaningful comparison.
Question | Question area | Question type | Time | Status | Level |
---|---|---|---|---|---|
6 | Accounting Theory |
Consolidated financial statements, rules for when consolidation shall occur (including ownership percentage, significant influence, acquisition method)
0 of 2 correct answers and 1 wrong and got 0 out of 3 points |
00:16 | Difficult | |
9 | Closing of Accounts |
Taxable income, difference from annual profit, and various components in the calculation
1 of 2 correct answers and 0 wrong and got 1,5 out of 3 points |
00:13 | Difficult | |
11 | Financial Analysis |
Break down of profitability into profit margin and capital turnover rate
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:14 | Difficult | |
13 | Closing of Accounts |
Record recognised customer losses
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:07 | Difficult | |
15 | Accounting Theory |
Financial instruments at fair value or cost, IFRS vs. K3
0 of 2 correct answers and 0 wrong and got 0 out of 3 points |
00:04 | Difficult | |
18 | Financial Analysis |
The Components of the Leverage Relationship
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:20 | Difficult | |
21 | Income Statement & Balance Sheet |
Consolidation Principles in Group Financial Statements
0 of 2 correct answers and 0 wrong and got 0 out of 3 points |
00:04 | Difficult | |
24 | Income Statement & Balance Sheet |
Meaning of Comprehensive Income
0 of 2 correct answers and 0 wrong and got 0 out of 3 points |
00:05 | Difficult | |
1 | Closing of Accounts |
Accrual of supplier invoices at year-end, interim receivable vs. interim liability
1 of 2 correct answers and 0 wrong and got 0,5 out of 1 points |
00:14 | Easy | |
2 | Income Statement & Balance Sheet |
Format, Functional Income Statement
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:23 | Easy | |
5 | Accounting Theory |
Specify the account group, bank account in the accounting
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:08 | Easy | |
12 | Financial Analysis |
Calculate Interest Coverage Ratio
0 of 1 correct answers and 0 wrong and got 0 out of 1 points |
00:07 | Easy | |
14 | Income Statement & Balance Sheet |
Order of Fixed Assets in a Balance Sheet
0 of 1 correct answers and 1 wrong and got 0 out of 1 points |
00:16 | Easy | |
16 | Financial Analysis |
Calculate Profitability
0 of 1 correct answers and 1 wrong and got 0 out of 1 points |
00:12 | Easy | |
17 | Closing of Accounts |
Accruals, interim receivables vs. interim liabilities
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:16 | Easy | |
23 | Accounting Theory |
The meaning of accounts receivable - available information to extract
1 of 2 correct answers and 0 wrong and got 0,5 out of 1 points |
00:08 | Easy | |
3 | Income Statement & Balance Sheet |
Meaning of Free Cash Flow
1 of 3 correct answers and 0 wrong and got 0,7 out of 2 points |
00:07 | Intermediate | |
4 | Income Statement & Balance Sheet |
Various Performance Measures in Operations
3 of 3 correct answers and 0 wrong and got 2 out of 2 points |
00:13 | Intermediate | |
7 | Financial Analysis |
Capital Binding, Impact on Profitability and Cash Flow
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:20 | Intermediate | |
8 | Closing of Accounts |
Accrual of a received supplier invoice, relevant accounts for prepaid expenses
0 of 1 correct answers and 0 wrong and got 0 out of 2 points |
00:04 | Intermediate | |
10 | Closing of Accounts |
At year-end, valuation of inventory, interpret a calculation, and record an increase (posting)
0 of 1 correct answers and 0 wrong and got 0 out of 2 points |
00:08 | Intermediate | |
19 | Accounting Theory |
Costs, definition and significance in accounting
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:10 | Intermediate | |
20 | Accounting Theory |
Consolidated financial statements, how intra-group transactions are handled
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:07 | Intermediate | |
22 | Financial Analysis |
Accounts Receivable, Derive Revenue through Credit Period
0 of 1 correct answers and 0 wrong and got 0 out of 2 points |
00:05 | Intermediate |
Correct answer
Weighted point, partly right on the question
Wrong answer
Either skipped or out of time
TEST AREAS
"SEPARATING ANALYSTS FROM ACCOUNTANTS"
Test in English on Swedish GAAP, distinguishing candidates managing Closing of Accounts and Reporting from those with strong Financial Analysis skills and deep knowledge of Income Statements and Balance Sheets.
Questions and answer choices are in English to facilitate reading comprehension for candidates whose native language is not Swedish. However, images, accounting boxes, etc., remain in Swedish.
Income Statement & Balance Sheet
The candidate's knowledge relating to both simpler aspects such as different presentation formats, asset categories, short-term and long-term liabilities, equity, operational performance measures etc, as well as more advanced topics - for example fund and new issues, free cash flow, provisions, capitalised tax loss carryforwards, comprehensive income, leasing, consolidation principles in group financial statements, and more.
Financial Analysis
Proficiency in recognised financial key ratios such as solvency, debt-to-equity ratio, and interest coverage ratio, understanding and calculation of profitability, credit periods through accounts receivable and accounts payable, capital binding, and the impact of financial leasing on profitability and cash flow, among others. Also, more complex analysis such as knowledge of the components of leverage and DuPont relationships, adjusted equity, the impact of working capital on cash flow, etc.
Closing of Accounts
The candidate's knowledge regarding account reconciliations, accruals, various interim accounts and skills in closing VAT accounts, accrual of invoices, recording of taxes and inventory, computation of taxable income, and accounting for anticipated and recognised customer losses, among other things.
Accounting Theory
Understanding the meaning and purpose of verifications, monthly reconciliations, accruals, accrued and prepaid items, definitions of revenue and expenses, consolidated financial statements, elimination of internal transactions, percentage of completion, significance of various accounting principles, indirect method regarding cash flow, IFRS vs. K3 regarding financial instruments, and useful life for intangible assets, among others.
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 30 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