Solved

All of the Following Statements Are TRUE About Conditional Aggregate

Question 1

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.

Correct Answer:

verifed

Verified

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents