CUET Preparation Today
Which of the following is NOT a method to create a drop-down list for data validation? |
Typing a list of values separated by commas Selecting a range of cells containing list values Using a Named Range to refer to list values Creating a pivot table |
Creating a pivot table |
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 |
