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 (BPAY sheet). This information must be matched to the system data that has been downloaded into Excel (SYS DATA sheet) and a report produced that will be uploaded to the school system.
Go to the Upload sheet (this is where all calculations are to be done). You will see that the BpayReference has already been populated. The next column needs to contain the TransactionReference, which is made up of the MERCHANT, followed by the SETTLEMENT DATE, followed by the MERCHANT REFERENCE from the BPAY Bank File sheet, with no space between them, e.g. ANB20201002120026834. Create a calculation in B2 that will join these values together and then copy the formula down.
What is the value of Check Digit 1 in cell T13?
Â
2. Question 2 What is the major source of competition for motor carrier? 2 points   Cost  Â
3. Question 3 Which tracking method is best for teams with a lot of people and projects with many tasks or milestones that are dependent on one another? 1 / 1 point  …
6. Question 6 Data analysts create hierarchies to organize their folders. How are folder hierarchies structured? 1 / 1 point  Broad topics at the right, then more specific topics at the left…
6. Question 6 The Contract Award Stage is the final stage of procurement. 1 / 1 point  True  False
4. Question 4 This month, a company receives $10,000 from a regular customer, of which $6,000 is for products delivered last month and $4,000 is for products that will be…
4. Question 4 The spaceships of Bob and Alice sit side-by-side at a spaceport. They measure them and both agree that each spaceship is 26 meters long. Alice takes off…
