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:33 of 35:00 |
Issuer: |
Demo Kunskapstest, EPROVED |
The candidate has basic knowledge as an Accounting Assistant, handling tasks such as accounts receivable and payable, invoice processing, expenses, bookkeeping, and more.
Beginner
0% - 24%
Basic Proficiency
25% - 49%
Competent
50% - 76%
Skilled
77% - 100%
The candidate demonstrates strong knowledge in accounts receivable and accounts payable, including invoice handling, ledger reconciliation, payments, accounting adjustments, and has a solid understanding of related processes and routines.
The candidate demonstrates basic knowledge of expense management, including the ability to differentiate between VAT rates, familiarity with the necessary information on receipts for accounting purposes, and the capability to handle representation and travel expenses at an overall level.
The candidate demonstrates strong proficiency in accounting, including posting customer and supplier invoices, handling representation, receipts, expenses, accounting corrections, payroll, accrued vacation pay, and more.
The candidate has introductory knowledge of processes and procedures, such as the meaning of authorisation and the registration of incoming invoices.
Points
Time
Henrik Dennerheim's score was 12% above the average of all other test-takers.
At present, there is not enough benchmark data collected for the profile (Financial Administration (Accounting Assistant) - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Financial Administration (Accounting Assistant) - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Financial Administration (Accounting Assistant) - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Financial Administration (Accounting Assistant) - Specialist, 4-6 yrs) to generate a meaningful comparison.
At present, there is not enough benchmark data collected for the profile (Financial Administration (Accounting Assistant) - Specialist, 4-6 yrs) to generate a meaningful comparison.
Question | Question area | Question type | Time | Status | Level |
---|---|---|---|---|---|
7 | Bookkeeping |
Supplier invoices, foreign currency
0 of 1 correct answers and 1 wrong and got 0 out of 3 points |
00:07 | Difficult | |
8 | Processes & Procedures |
Rules for Approving Payments
0 of 1 correct answers and 0 wrong and got 0 out of 3 points |
00:10 | Difficult | |
9 | Expense Management |
Receipts, rules for archiving
1 of 4 correct answers and 0 wrong and got 0,8 out of 3 points |
00:14 | Difficult | |
10 | Accounts Receivable & Payable |
International payments, SWIFT/BIC
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:19 | Difficult | |
11 | Bookkeeping |
VAT, VAT rates, and various account numbers
1 of 1 correct answers and 0 wrong and got 3 out of 3 points |
00:15 | Difficult | |
16 | Processes & Procedures |
Identify and Manage Fraudulent Invoice
0 of 1 correct answers and 1 wrong and got 0 out of 3 points |
00:07 | Difficult | |
17 | Accounts Receivable & Payable |
Reconciliation of accounts receivable
1 of 2 correct answers and 0 wrong and got 1,5 out of 3 points |
00:06 | Difficult | |
18 | Expense Management |
Foreign supplier invoice, reverse charge
0 of 2 correct answers and 0 wrong and got 0 out of 3 points |
00:05 | Difficult | |
1 | Expense Management |
VAT rate on meals
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:09 | Easy | |
2 | Bookkeeping |
Rules for correcting incorrectly recorded transactions, including reverse debit and credit
1 of 3 correct answers and 1 wrong and got 0 out of 1 points |
00:10 | Easy | |
5 | Bookkeeping |
Record supplier invoice, invoice method for VAT taxable sales (posting) *
3 of 3 correct answers and 0 wrong and got 1 out of 1 points |
00:45 | Easy | |
12 | Accounts Receivable & Payable |
Accounts payable ledger, meaning and information
0 of 1 correct answers and 1 wrong and got 0 out of 1 points |
00:07 | Easy | |
13 | Processes & Procedures |
Authorisation, Meaning and Purpose
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:10 | Easy | |
22 | Expense Management |
Receipts, required information for creating a voucher
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:07 | Easy | |
23 | Processes & Procedures |
Posting, Debit and Credit
0 of 1 correct answers and 0 wrong and got 0 out of 1 points |
00:03 | Easy | |
24 | Accounts Receivable & Payable |
Accounts receivable, meaning and purpose in accounting
1 of 1 correct answers and 0 wrong and got 1 out of 1 points |
00:11 | Easy | |
3 | Accounts Receivable & Payable |
Ledger reconciliation, variance in balance
1 of 3 correct answers and 0 wrong and got 0,7 out of 2 points |
00:07 | Intermediate | |
4 | Expense Management |
Recording representation, meals
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:17 | Intermediate | |
6 | Bookkeeping |
Record customer invoice, credit invoice under the invoice method, and VAT taxable sales (posting) *
0 of 3 correct answers and 0 wrong and got 0 out of 2 points |
00:03 | Intermediate | |
14 | Accounts Receivable & Payable |
Accounts payable ledger, meaning and purpose
0 of 2 correct answers and 0 wrong and got 0 out of 2 points |
00:04 | Intermediate | |
15 | Bookkeeping |
Record representation expenses, alcoholic beverages (posting)
1 of 1 correct answers and 0 wrong and got 2 out of 2 points |
00:12 | Intermediate | |
19 | Processes & Procedures |
Authorisation and Necessary Information on Receipt
0 of 2 correct answers and 1 wrong and got 0 out of 2 points |
00:06 | Intermediate | |
20 | Processes & Procedures |
Authorisation, Meaning and Purpose
0 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:10 | Intermediate | |
21 | Expense Management |
Recording representation, alcoholic beverages
0 of 1 correct answers and 1 wrong and got 0 out of 2 points |
00:13 | Intermediate |
* - Questions with this symbol are account distribution questions.
Correct answer
Weighted point, partly right on the question
Wrong answer
Either skipped or out of time
The supplier invoice above has been received. How is it booked if the company makes sales subject to VAT and uses the accrual method?
Account | Account name | Debet | Credit |
---|---|---|---|
TEST AREAS
"BEYOND LEDGERS INTO BOOKS"
Test in English on Swedish GAAP. Differentiates candidates with experience limited to ledgers and payments from those with bookkeeping skills and familiarity with processes and procedures in larger companies.
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.
Bookkeeping
Testing of both basic bookkeeping, e.g. common customer and supplier invoices, representation and receipts, correction of a recorded transaction, credit invoices etc, to more advanced accounting - e.g. salaries, accrued vacation pay, invoices in foreign currency, tax revenues, etc.
Accounts Receivable & Payable
The candidate's knowledge ranges from basic understanding and handling of ledgers, invoices, input and output VAT, accounts, manual reconciliation, payments, bank transfers, accounting dates, etc., to more advanced aspects such as discrepancies, credit invoices, accrual of customer and supplier invoices, incorrect invoices, international payments, etc.
Expense Management
The candidate's knowledge regarding receipt management, representation, archiving rules, various VAT rates, accounting for representation of meals and alcoholic beverages, travel expenses, tax-free per diems, foreign invoices, reverse charge, etc.
Processes & Procedures
Refers to an understanding of the meaning and purpose of authorisation, the process for the arrival registration of invoices, necessary information in accounting records, rules regarding authorisation, invoice registration, and the double-entry principle, identification and handling of fraudulent invoices, delegated authorisation authority and immediate superior, rules for approving payments, etc.
TEST QUESTIONS
Multiple Choice and Manual Entry Questions
Our tests are mainly based on multiple-choice questions where the number of correct answer options varies. Each question has four answer options. Some questions require manual recording of a business transaction, and the candidate is provided with a chart of accounts for assistance.
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 35 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