Quiz

  1. 1
    Intermediate

    Assume you have a table in cells A2:B20, which contains product numbers in column A and product prices in column B. What should you expect to be returned by the following formula? =VLOOKUP(A25,A2:B20,2,FALSE)

  2. 2
    Intermediate

    Assume you have a table in cells A2:B20, which contains product numbers in column A and product prices in column B. What should you expect to be returned by the following formula? =VLOOKUP(A25,A2:B20,1,FALSE)

  3. 3
    Intermediate

    Assume you have a table in cells A2:B20, which contains sorted product numbers in column A and product prices in column B. What should you expect to be returned by the following formula? =VLOOKUP(A25,A2:B20,2)