1. 1

    When creating a Data Validation list, you are able to provide a list of items without linking to cells. What character is used to separate the individual items?

  2. 2

    When you want to use the values in the column of a table to drive a Data Validation list, it’s a good idea to provide a name for those cells. What is the fastest way to do this?

  3. 3

    The workbook designer set up a Data Validation message with a custom error alert as shown in the image below. Which type of message style did they use to prevent you from putting in invalid data?