Excel SUMIF Function Quiz

What does the SUMIF function do in Excel?

• Adds all values in a range

• Adds values in a range that meet a specified condition

• Counts cells with numbers in a range

• Finds the maximum value in a dataset

What is the correct syntax for the SUMIF function?

• SUMIF(range, sum_range, criteria)

• SUMIF(criteria_range, sum_range, criteria)

• SUMIF(range, criteria, [sum_range])

• SUMIF(range, criteria)

In the formula `=SUMIF(A1:A10, ">50", B1:B10)`, what is the purpose of `A1:A10`?

• It is the range of values to add.

• It is the range where the criteria will be checked.

• It is the cell that stores the result.

• It is a fixed reference.

Which of the following best describes the third argument in the `SUMIF` function?

• The cell range to apply the criteria to

• The condition to apply to the range

• The range to be summed

• The entire data range

True or False: The SUMIF function can be used without a `sum_range`.

• True

• False

In the formula `=SUMIF(B2:B15, ">=100")`, what happens if all values in 'B2:B15' are below 100?

• It will return the sum of all values.

• It will return 0.

• It will return an error.

• It will return the total of values closest to 100.

Which of these formulas correctly sums values in `C2:C10` where the corresponding cells in 'B2:B10' contain "Pass"?

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

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

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

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

Which of the following is a valid use of the SUMIF function?

• =SUMIF(A:A, ">0")

• =SUMIF(A1:A10, B1:B10, ">0")

• =SUMIF(A1:A10, ">10", C1:C10)

• =SUMIF(A1, "A10", ">=50")

How does Excel treat text in the SUMIF criteria?

• Text criteria are ignored.

• Text criteria must be in quotation marks.

• Text criteria are case-sensitive.

• Text criteria only apply to numeric values.

What would `=SUMIF(B2:B15, "North", C2:C15)` do in an Excel sheet with regional sales data?

• Sum sales values in `B2:B15` for the "North" region.

• Sum values in `C2:C15` where `B2:B15` is "North."

• Count values in `C2:C15` where `B2:B15` is "North."

• Return 0 if no values are found.