SUMIFs and COUNTIFs Functions Quiz

What does a formula in Excel always start with?

• A plus sign (+)

• A dollar sign ($)

• An equal sign (=)

• A minus sign (-)

Which of the following is an example of a built-in function?

• SUM

• SUBTRACT

• ADD

• MULTIPLY

What is the purpose of the SUM function?

• To count the number of cells

• To find the average of a range

• To multiply values

• To sum a range of cells

What does the SUMIF function do?

• Sums all values in a range

• Sums values that meet specific criteria

• Counts the number of cells

• Finds the maximum value

Which operator is used for multiplication in Excel formulas?

• /

• *

• -

• +

What is the syntax for the SUMPRODUCT function?

• =SUMPRODUCT(array1, [array2], ...)

• =SUM(array1, array2)

• =PRODUCT(array1, array2)

• =SUMIF(array1, criteria)

What does the COUNTIFS function do?

• Counts cells that meet multiple criteria

• Sums cells that meet multiple criteria

• Finds the average of a range

• Multiplies values in a range

What is an operand in a formula?

• A predefined formula

• A range of cells

• An operation to be performed

• Values to be operated on

Which of the following is NOT an arithmetic operator?

• >

• /

• -

• +

What happens if the sum_range argument is not used in the SUMIF function?

• It will sum only numeric values

• It will be the same as the criteria_range

• It will sum all values in the range

• It will return an error