Welcome to your Advanced Excel Assessment - Please note that you will only have one chance to answer the questions within the 15-minute time limit, please take care when answering - as one wrong question is the difference between passing or failing.
The timer will start as soon as you click next.
Good Luck!
Name & Surname
Email
1.
A debtor has not paid an invoice, and you have sent them a statement of account showing the outstanding amount. However, the debtor claims to have already paid the invoice. What should you do?
3.
What is the purpose of the "Age Analysis" report in Sage Pastel?
4.
Which of the following is a common method for debt collection?
5.
Which of the following is a common feature in Sage Pastel's debtors module?
6.
What is the purpose of a credit application form?
7.
Which of the following is an example of an unsecured debt?
8.
You are a Debtors Clerk at a bank in South Africa and have been tasked with creating a credit risk assessment report using GreatSoft for a potential borrower. The borrower has applied for a loan of R500,000 and has provided financial statements and other supporting documentation. Use GreatSoft to create a credit risk assessment report and evaluate the borrower's creditworthiness. Please list the steps and explain the process.
9.
Which of the following documents can be created in Sage Pastel?
10.
You are an debtor's clerk at a small business in South Africa and have been tasked with creating a batch of invoices for multiple debtors in Sage Pastel. The invoices need to be created for goods sold during the month of April 2023, with a total value of R50,000. Use Sage Pastel to create the batch of invoices for the multiple debtors. Please list and explain your process.
11.
Which of the following is NOT a common debt collection method?
12.
Which of the following is NOT a common cause of bad debts?
13.
You are a bookkeeper at a small business in South Africa and have been tasked with running an age analysis in Sage Pastel for a customer who owes the business money. The customer's account has an outstanding balance of R10,000 and has been overdue for 90 days. Use Sage Pastel to run an age analysis and determine how much of the customer's account is overdue and by how many days. Please explain your process and the steps taken to run the report
14.
Which financial document is used to record sales transactions?
15.
What is the purpose of the "Customers" module in Sage Pastel?
16.
What is the purpose of a debtor's age analysis report?
