Excel Functions Quiz

What is the primary purpose of the `SUMIF` function in Excel?

• To count cells that meet a criterion

• To sum values based on a single criterion

• To calculate the average of a range

• To apply formatting to cells

Which of the following is the correct syntax for the `SUMIF` function?

• =SUMIF(range, criteria, sum_range)

• =SUMIF(criteria, sum_range, range)

• =SUMIF(range, sum_range, criteria)

• =SUMIF(sum_range, range, criteria)

In the formula `=SUMIF(A2:A10, ">50", B2:B10)`, what does `A2:A10` represent?

• The range of values to sum

• The range where the criteria will be applied

• The sum range

• The result cell

Which of these functions is used to sum values based on multiple criteria?

• SUM

• SUMIF

• COUNTIF

• SUMIFS

In the `SUMIFS` function, the order of criteria ranges and criteria must:

• Be in any order

• Match exactly

• Be reversed

• Have only one criteria

The formula `=SUMIF(B2:B20, "East", C2:C20)` will do what?

• Sum values in `B2:B20`

• Sum values in `C2:C20` where values in `B2:B20` equal "East"

• Count cells in `B2:B20`

• Return an error

Which of these formulas calculates the total sales for “Product A” in the “North” region?

Which formula adds values in `B2:B50` where corresponding cells in `C2:C50` equal "North"?

• =SUMIFS(B2:B50, "Product A", C2:C50, "North", D2:D50)

• =SUMIF(B2:B50, D2:D50, "Product A")

• =SUMIFS(B2:B50, C2:C50, "North")

• =SUM(D2:D50, B2:B50, C2:C50, "North")

In `SUMIF`, what happens if the `sum_range` is omitted?

• It returns 0

• It sums the `criteria_range`

• It shows an error

• It requires `sum_range` to work

Which formula adds values in `C2:C10` where corresponding cells in `B2:B10` contain "Yes"?

• =SUMIF(C2:C10, "Yes", B2:B10)

• =SUMIF(B2:B10, "Yes", C2:C10)

• =SUMIFS(B2:B10, "Yes", C2:C10)

• =SUM(C2:C10, B2:B10, "Yes")