Multiple Choice
All of the following statements are TRUE about the SUMIF and SUMIFS functions EXCEPT:
A) The SUMIF and SUMIFS functions select values from a range of data based on criteria, and then add those values.
B) SUMIF functions are based on one criterion.
C) The SUMIF and SUMIFS arguments are very dissimilar.
D) The SUMIFS function allows for more than one filtering criteria.
Correct Answer:

Verified
Correct Answer:
Verified
Q34: The correct syntax for the COUNTIF function
Q35: The AVERAGEIFS function expands on the AVERAGEIF
Q36: Which of the following is an example
Q37: A nested IF requires one or more
Q38: The function =IF(SUM(Trans_Qty)>E20,"Goal Met","Under Goal")is an example
Q40: Data that is manually calculated and typed
Q41: All of the following statements are TRUE
Q42: The IF function provides two outcomes,one when
Q43: Match the following terms to their description.
Q44: The _ function returns the value of