Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers
elance-zoho-creator-exam.pdf

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).
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon