> > >

Excel MCQs

How do you create a dynamic drop-down menu in Excel that automatically detects if new options (strings) were added to the source list?

Go to Data Validation, select list and highlight the source list.

Go to Data Validation, select list and in the source use offset(Source, 0, CountA(Source),0,1).

Go to Data Validation, select list and in the source use Offset(Source,0,0,CountA(Source),1).

Go to Data Validation, select list and in the source use offset(Source, 0, 0,CountA(Source),0).

Answer

Correct Answer: Go to Data Validation, select list and in the source use Offset(Source,0,0,CountA(Source),1).

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it