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 for data validation needs a source of list values, and there are three ways to give it: type the values separated by commas, select the cells that hold them, or refer to a Named Range. A pivot table summarises data already entered; it does not supply the items of a drop-down list.
Option (1) Typing a list of values separated by commas — A method of creating the list. A delimited list such as Male, Female.
Option (2) Selecting a range of cells containing list values — A method of creating the list. The values typed in a row or column are used directly.
Option (3) Using a Named Range to refer to list values — A method of creating the list. The named range is given as the source.
NCERT (2026-27 edition):
|
