If 'Vegetables' is a category and 'Celery' is a subcategory that can be chosen from a list, we can set up a dropdown list referencing 'Vegetables' by:writing =INDIRECT(Vegetables) in the data validation option under drop down listwriting =INDEX(Vegetables) in the cell that should contain 'Celery' in a drop down listwriting =INDIRECT(Vegetables) in the cell that should contain 'Celery' in a drop down listwriting =INDEX(Vegetables) in the data validation option under drop down lis

To create a drop down list which of the following can be use? List Manager Data Validation Dlist Any Value

Which of the following functions is used to create a drop-down box in selected cells?Question 53Answera.Data > Filterb.Data > Conditional Formattingc.Pivot Tabled.Data > Data Validation

To create a Drop-down List, each distinct option is entered in the Source box in the Data Validation dialog. The items should be separated by a:

How can you create a drop-down list in Google Sheets that automatically updates itself when new values are added to the source range?*Use Data Validation with a named rangeManually update the drop-down listUse ARRAYFORMULA with Data ValidationIt's not possible to create an auto-updating drop-down list

What Excel functions will you use to create a drop-down menu shown in the image below?Data ValidationAdvanced FilterData TablePivot Table