All of the Following Statements Are TRUE About Conditional Aggregate

Multiple Choice

All of the following statements are TRUE about conditional aggregate functions EXCEPT:

A) Conditional aggregate functions are functions that consolidate or summarize a subset of data that has been filtered based upon one or more criteria.
B) With an aggregate function, a range would still be provided, but the aggregation would only use cells that meet a given criteria.
C) Elements such as named ranges and cell references should go inside quotes.
D) The criteria can be on the data that is being aggregated or on associated data.