Quiz

  1. 1
    Beginner

    Which of the following is true about the SUMIF function?

  2. 2
    Beginner

    The syntax of SUMIF is SUMIF(Range,Criterion,Sum_Range). Which argument is not necessarily required?

  3. 3
    Beginner

    In this example, Business Units A, B, C and D make sales as recorded. What should the amount be displayed in cell G5 if the formula is =SUMIF(B5:B16,B12,C5:C16)?