Quiz

  1. 1
    Advanced

    Suppose there is a small table with these values for the cells: A1 = A, A2 = B, B1 = C, B2=D. What does the formula =INDEX(A1:B2,2,1) return?

    Supporting image for quiz question

  2. 2
    Advanced

    Suppose cells A1:A4 contain these values: Fred, Joe, Mary, John. What does the formula =MATCH(“joe”,A1:A4,FALSE) return?

    Supporting image for quiz question

  3. 3
    Advanced

    Suppose cells A1:A4 contain these values: Fred, Joe, Mary, John. What does the formula =HLOOKUP(“joe”,A1:A4,1,FALSE) return?

    Supporting image for quiz question