Using Excel 2019, the problem in question 1 could have been solved using which of the following: (Multiple answers may apply.)
Yes, that is correct.
Yes, that is correct.
Yes, that is correct.
No, that is not correct, JOIN is not a function in Excel.