All of the Following Statements Are TRUE About Conditional Aggregate

question 53

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.

---

Definitions:

Sensorimotor

Relating to or involving both sensory and motor functions or pathways.

Preoperational

A stage in Jean Piaget’s theory of cognitive development where children aged 2 to 7 years old are able to use symbols and language but do not yet understand concrete logic.

Concrete Operational

A stage in Piaget's theory of cognitive development (typically age 7-12) where children gain the ability to think logically about concrete (physical and visible) events.

Ejaculation

Ejaculation is the discharge of semen from the male reproductive tract as a result of sexual arousal.