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
12 May 2025
Candidate: |
Henrik Dennerheim |
Competence: |
Basic Proficiency - level: 2 of 4 |
Time spent: |
04:09 of 30:00 |
Issuer: |
Demo Kunskapstest, EPROVED |
The candidate has basic knowledge of payroll administration.
Beginner
0% - 24%
Basic Proficiency
25% - 49%
Competent
50% - 76%
Skilled
77% - 100%
The candidate exhibits basic knowledge of labour law, including an understanding of various laws, types of employment, and vacation rights.
The candidate has basic knowledge of leave and absence, with a broad understanding of holidays, sick leave, deductible period, care of sick child (SV: VAB), parental leave, and more.
The candidate demonstrates strong knowledge of compensation and taxes, including tax-exempt benefits, gifts, employer contributions, gross and net salary deductions, tax tables, tax-free per diems, and mileage allowances.
The candidate demonstrates strong knowledge in payroll calculation and accounting, being capable of performing calculations for payroll deductions and additions during vacation, managing earned and advance vacation leave, applying the percentage rule, handling care of sick child (SV: VAB), sick leave during the waiting period, and accounting for salary, changes in vacation pay liability, income tax, employer contributions, and more.
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 (Payroll Administration - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Payroll Administration - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Payroll Administration - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Payroll Administration - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Payroll Administration - Specialist, 4-6 yrs) to generate a meaningful comparison.
Question | Question area | Question type | Time | Status | Level |
---|---|---|---|---|---|
5 | Compensation & Tax |
Travel expenses, calculate tax-free per diem between two dates
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:07 | Difficult | |
6 | Employment Law |
Benefit and Defined Contribution Pension Plans & Special Payroll Tax
0 of 1 correct answers and 1 wrong and got 0 out of 3 points |
00:06 | Difficult | |
9 | Compensation & Tax |
External representation, management of personal expenses and approval
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:13 | Difficult | |
10 | Leave & Absence |
Parental leave, calculation of hourly wage deduction
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:10 | Difficult | |
15 | Employment Law |
Overtime Regulations and Shift Differential Compensation (SV: "OB-ersättning")
1 of 2 correct answers and 1 wrong and got 0 out of 3 points |
00:06 | Difficult | |
16 | Salary Calculation & Accounting |
Managing accrued vacation and paid advance vacation, termination vs. terminated
0 of 1 correct answers and 1 wrong and got 0 out of 3 points |
00:04 | Difficult | |
17 | Salary Calculation & Accounting |
Account for salary, income tax, vacation accrual, and employer contributions (posting)
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:19 | Difficult | |
18 | Leave & Absence |
Vacation year vs. earning year, paid & unpaid vacation days
1 of 2 correct answers and 1 wrong and got 0 out of 3 points |
00:08 | Difficult | |
1 | Salary Calculation & Accounting |
Calculate gross salary, sick pay deductions including waiting period
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
2 | Leave & Absence |
Compensation for short-term sick leave, waiting period, and compensation level
0 of 1 correct answers and 1 wrong and got 0 out of 1 points |
00:07 | Easy | |
7 | Salary Calculation & Accounting |
Existence of salary components
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:08 | Easy | |
11 | Compensation & Tax |
Tax-exempt benefits
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:13 | Easy | |
14 | Employment Law |
Various Employment Types
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:12 | Easy | |
19 | Employment Law |
Existence of Various Laws and Regulations
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:12 | Easy | |
22 | Leave & Absence |
Annual leave in accordance with the Annual Leave Act
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:10 | Easy | |
23 | Compensation & Tax |
Tax table, calculate preliminary tax at a specific salary
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:13 | Easy | |
3 | Leave & Absence |
The rules of the Social Insurance Agency (SV: "Försäkringskassan") regarding Temporary Parental Leave to Care for a Sick Child (SV: "VAB")
0 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:09 | Intermediate | |
4 | Employment Law |
Employee Rights According to the Vacation Act (SV: "Semesterlagen")
1 of 2 correct answers and 0 wrong and got 1 out of 2 points |
00:08 | Intermediate | |
8 | Salary Calculation & Accounting |
Calculate gross salary, vacation supplement & salary deductions during parental leave (SV: "VAB")
0 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:14 | Intermediate | |
12 | Compensation & Tax |
Mileage reimbursement, tax-exempt amount
0 of 1 correct answers and 2 wrong and got 0 out of 2 points |
00:16 | Intermediate | |
13 | Salary Calculation & Accounting |
Account for salary, income tax & employer contributions (posting)
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:09 | Intermediate | |
20 | Compensation & Tax |
Employer contributions, level & salary vs. benefits
0 of 2 correct answers and 2 wrong and got 0 out of 2 points |
00:07 | Intermediate | |
21 | Employment Law |
Meaning of Collective Agreements, Organised vs. Unorganised
2 of 3 correct answers and 0 wrong and got 1,3 out of 2 points |
00:08 | Intermediate | |
24 | Leave & Absence |
Compensation during parental leave
1 of 2 correct answers and 1 wrong and got 0 out of 2 points |
00:08 | Intermediate |
Correct answer
Weighted point, partly right on the question
Wrong answer
Either skipped or out of time
TEST AREAS
"FROM LAW TO PAYROLL PRACTICE"
Payroll test in English on Swedish regulations, covering key areas such as employment law, leave and absence management, compensation and tax calculations, as well as payroll processing and accounting practices.
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.
Employment Law
The candidate's knowledge pertaining to various laws - for example, the Holiday Act and the Employment Protection Act (SV: LAS) - different types of employment contracts, the significance of collective bargaining agreements, regulations concerning overtime, occupational pensions, benefit- and contribution-defined pension plans, among others.
Leave & Absence
Basic and advanced knowledge regarding compensation and payroll deductions in the event of leave and absence, for example, holiday pay, holiday compensation, holiday year versus earning year, paid and unpaid holiday days, parental leave, deductible period, and the Swedish Social Insurance Agency's regulations (SV: "Försäkringskassan") for care of sick child (VAB), among other aspects.
Compensation & Tax
The candidate's knowledge regarding various compensations, such as tax-exempt benefits, mileage allowance, tax-free per diems, personal expenses and travel expense reports, as well as taxes like preliminary income tax, tax tables, employer contributions, special payroll tax on pensions, etc.
Salary Calculation & Accounting
Calculations of gross and net salaries under various conditions, for example, during vacation, sick leave, parental leave, as well as laws and collective agreements as the basis for daily and hourly calculations for salary additions and deductions, handling of accrued vacation and paid advance vacation, as well as accounting for salary, income tax, vacation accrual, and employer contributions, 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 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