Quiz

  1. 1
    Beginner

    In the example, what formula might be in cell C9?

  2. 2
    Beginner

    If lookup data is in ascending, rather than strict ascending, order (e.g. 1, 2, 3, 3, 3, 4, 5), how does the LOOKUP function behave when searching for one of the duplicate values?

  3. 3
    Beginner

    In modeling, which of the following three functions is recommended for looking up data?