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:

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

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

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

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

Question 3You prepare a project tracker spreadsheet. Next to each project is the name of the team member responsible. What spreadsheet tool will create a drop-down list with team member names to save you time when assigning the projects?1 pointConditional formattingFindPop-up menusData validation