Quiz

  1. 1
    Beginner

    Microsoft documents that the syntax for MATCH is =MATCH(Lookup_Value, Lookup_Array, [Match_Type]). What is wrong with this syntax as it is stated?

  2. 2
    Beginner

    The default setting of Match_Type in the MATCH function is 1. What does this mean?

  3. 3
    Beginner

    In this example, the formula in cell F7 is =MATCH(F6,B6:B16). What value will the output take?