Quiz

  1. 1
    Advanced

    Assume that you have a small table set up as follows: A1 = A, A2 = B, B1 = C, C1 = D. What will the following formula return? =INDEX(A1:B2,2,1)

  2. 2
    Advanced

    Assume that A1:A4 contains the following values: Fred, Joe, Mary, John. What will the following formula return? =MATCH(“joe”,A1:A4,FALSE)

  3. 3
    Advanced

    Assume that A1:D1 contains the following values: Fred, Joe, Mary, John. What will the following formula return? =HLOOKUP(“joe”,A1:D1,1,FALSE)