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

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

Which of the following tools in Excel can be used for data validation?Pivot tableData validation toolConditional formattingFilter tool

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

Question 4A data analyst selects Format Cells and the option Text Is Exactly Baseball. This changes the color of all the cells that contain the word “Baseball.” What spreadsheet tool is the analyst using?1 pointConditional formattingData validationFilteringCONVERT

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