Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers

In the formula "=VLOOKUP(A3,$J$3:$K$12,2,TRUE)", the 4th argument of the VLOOKUP function, "TRUE", indicates

that the table array for the look up has already been validated
to ignore blank values in the index column and return the next value in the index column when a blank is encountered
to only look up values that are greater than zero
to use an exact look up, only returning exact matches to the lookup value
to use a range look up, returning the closest matches to the lookup values
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon