Elance Exams Answers PDF file

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

A drop down menu contains "Sum","Average" and "Max", a table exists mapping these values to 1,2 and 3 respectively. What function next to the drop-down will Sum, Average or Max A1:A100 based on the drop-down input?

=VLOOKUP(input cell, mapping table, 1, FALSE), SUM(A1:A100),Average(A1:A100),Max(A1:A100)
=VLOOKUP(input cell, mapping table, 2, FALSE), SUM(A1:A100),Average(A1:A100),Max(A1:A100)
=CHOOSE(IF(input cell = mapping table, 1,2),SUM(A1:A100),Average(A1:A100),Max(A1:A100))
=CHOOSE(VLOOKUP(input cell, mapping table, 2, FALSE), SUM(A1:A100),Average(A1:A100),Max(A1:A100))
=CHOOSE(VLOOKUP(input cell, mapping table, 1, FALSE), SUM(A1:A100),Average(A1:A100),Max(A1:A100))
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon