Quiz

  1. 1
    Intermediate

    Assume we have the following values 10, 20, 30 ,40 in the range A1:A4. What will the following function return? =VLOOKUP(15,A1:A4,1,TRUE)

  2. 2
    Intermediate

    Assume we have the following values 10, 30, 20 ,40 in the range A1:A4. What will the following function return? =VLOOKUP(25,A1:A4,1,TRUE)

  3. 3
    Intermediate

    Assume we have the following values 10, 40, 20 ,30 in the range A1:A4. What will the following function return? =VLOOKUP(42,A1:A4,1,TRUE)