Quiz

  1. 1
    Advanced

    Given the range below, what is the result of the following function? =INDEX($A$1:$F$4,3,1)

  2. 2
    Advanced

    Given the range below, what is the result of the following function? =INDEX($A$1:$F$4,4,3)

  3. 3
    Advanced

    Given the range below, what is the result of the following function? =INDEX($B$2:$F$4,MATCH("Tent",$A$2:$A$4,0),4)