Which of the following is NOT a method to create a drop-down list for data validation?
Answer & explanation
Correct answer: option 4
The correct answer is Option 4: Creating a pivot table
A drop-down list can be prepared in three different ways which can be used for data validation
• Type a list of values separated by commas, i.e. using delimited list e.g. Male, Female
• Select the cells on the worksheet whose values can be used directly typed in a single row or single column
• Select the data in cells and create a Named Range to refer