WorksheetsSUMIFs and COUNTIFs Functions Quiz
Total questions: 10
Worksheet time: 5mins
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
