Chapter 10

Question 1

A text file separates data by a special character called a:

Answer 1

1. Delimiter

Question 2

You have client last names stored in column A and the date of their first purchase in column B. You would like to create a custom account number by combining the client’s last name and date. What function would you use to complete the task?

Answer 2

CONCATENATE