Elance Exams Answers PDF file

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

Given an Excel spreadsheet: A B C D E ----------------------------------------------------------------------------------- | ID Lastname First name Role Birth Date 1 | 101, Davis, Sara, Sales Rep, 12/08/1968 2 | 102, Fontana, Olivier, VP Sales, 12/19/1952 3 | 103, Leal, Karina, Sales Rep, 08/30/1963 You want to find the first name of the person with the lastname = "Fontana"

=VLOOKUP("Fontana",B2:B7,2,FALSE)
=VLOOKUP("Fontana",B2:C7,1,FALSE)
=VLOOKUP("Fontana",C2:C7,1,TRUE)
=VLOOKUP("Fontana",B2:E7,2,FALSE)
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon