Quiz

  1. 1
    Beginner

    Suppose customer numbers (IDs) are in column A, invoice numbers in column B and total invoice amounts in column C. Which function returns the number of times a specific customer made a purchase?

    Supporting image for quiz question

  2. 2
    Beginner

    Suppose customer numbers (IDs) are in column A, invoice numbers in column B and total invoice amounts in column C. Which function returns the total value of goods purchased by a specific customer?

    Supporting image for quiz question

  3. 3
    Beginner

    Suppose customer numbers (IDs) are in column A, invoice numbers in column B and total invoice amounts in column C. Which function is the easiest for discovering the total value of goods purchased by customers with a customer number above 1000?

    Supporting image for quiz question