18. Question 18 To be eligible for discount customers must have paid before the Discount Due Date and must have paid at least the full balance owing less the discount…
20. Question 20 A valid solution for Question 19 could be achieved using which of the following combinations of functions? (Multiple answers may be correct.) 1 / 1 point XLOOKUP and MATCH…
16. Question 16 Customers who pay 5 working days before the due date are eligible for a discount. In column M calculate the date 5 working days before the due…
13. Question 13 In column I, use the data in columns E and H to calculate how many days there were between when the invoice was issued and when it…
12. Question 12 Clear the filter you added in Question 11. In column H use the Customer Reference to look up the invoice date for that customer from the data…
10. Question 10 You would also like to see a breakdown of total outstanding fees and arrears. Start by naming the other columns in the SYS DATA sheet. Back in…
9. Question 9 The calculation in Column G has been done, it calculates the outstanding balance for each payee by adding up the fee, arrears, and other charges from the…
8. Question 8 In column F we need to get the payment amount from the BPAY sheet, but you will notice it is being treated as text because of the…
5. Question 5 Which of the following functions (on their own) could you have used to achieve the outcome in Question 4? 1 / 1 point SUBSTITUTE, TRIM, or LEFT SUBSTITUTE,…
2. Question 2 Using Excel 2019, the problem in question 1 could have been solved using which of the following: (Multiple answers may apply.) 1 / 1 point CONCAT Yes, that…
