Quiz

  1. 1
    Advanced

    What is the main difference between the comma notation form of SUMPRODUCT (=SUMPRODUCT(Argument1, Argument2) and the multiplication notation form of SUMPRODUCT (=SUMPRODUCT(Argument1 * Argument2)?

  2. 2
    Advanced

    How does SUMPRODUCT treat non-numerical entries?

  3. 3
    Advanced

    Which of the following formulae would calculate the weighted average of the data correctly?