Quiz

  1. 1
    Beginner

    In the illustration, which formula typed into cell C17 would derive the same result as that already calculated in cell D15?

  2. 2
    Beginner

    In this example, the formula =SUMPRODUCT((B5:B16=J4)*(C5:C16=J5)*(D5:D16=J6)*(E5:E16=J7)*F5:F16) has been used to show an alternative to using the SUMIFS function. Which of the following is the primary reason the various arguments multiplied (e.g. (B5:B16=J4)) are delineated using brackets?

  3. 3
    Beginner

    Which of the following statements is true concerning the SUMPRODUCT function?