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…
1. Question 1 You have been asked by a school to help automate their accounts processing. Every few days they receive a text file from the bank detailing payments received…
17. Question 17 Discounts are calculated as a percentage of the balance owed, rates vary depending on how large the balance is. The lookup table in S2:T5 details what percentage…
4. Question 4 We didn’t quite get the results we wanted in the last question and on closer inspection we discover that there is a space at the end of…
3. Question 3 The Customer Reference number is how we identify customers in our system. The BPAY reference appears to consist of the 9 digit School identifier, followed by the…
19. Question 19 Where there is more than one student enrolled, customers are given a 5% sibling discount. This is applied to the fees up front but as part of…
14. Question 14 The due date for invoices is 21 working days after invoices are issued. This has already been calculated in column J. In column K we would like…
11. Question 11 You realise you could make your life a little easier and your solution more robust by working in a table. Convert the data in A1:Q69 to a…
7. Question 7 In column E use a calculation to convert the paid date in the BPAY sheet to a valid Excel date. Formats will differ for different regions, but…
