Sumif

Multiple Choice

What does the SUMIF function do?

• The SUMIF function finds the maximum value in a range based on a condition.

• The SUMIF function averages values based on a specified condition.

• The SUMIF function sums values based on a specified condition.

• The SUMIF function counts the number of cells that meet a condition.

Multiple Choice

_____ function is used to count the number of times a specified value as a criteria has been repeated within the specified range of cells.

• COUNT BLANK

• COUNTA

• COUNT IF

• COUNT

Multiple Choice

How would you write a formula to sum the values in cells B1 to B5?

• =SUM(B1:B5)

• =AVERAGE(B1:B5)

• =COUNT(B1:B5)

• =IF(B1:B5)

File

​https://we.tl/t-AqPfFdgxJO



https://we.tl/t-AqPfFdgxJO

Multiple Choice

How would you use SUMIF to sum values greater than 10?

• =SUMIF(range, ">5")

• =SUMIF(range, "10")

• =SUMIF(range, ">10")

• =SUMIF(range, "<=10")

Multiple Choice

What is the purpose of the SUMIF function in Excel?

• To sum all values in a range

• To count the number of cells

• To find the average of a range

• To sum values based on a condition