The SUBTOTAL Function

question 60

Multiple Choice

The SUBTOTAL function

• A) highlights or emphasizes cells that meet certain conditions.
• B) formats cells based upon their value in reference to the value of other cells.
• C) calculates an aggregate for values in a range or database.
• D) tags a table element as a reference in a formula.

---

Definitions:

Compliance

The act of conforming, submitting, or adapting one's behavior to align with the rules, demands, or expectations of others.

Self-Control

The ability to regulate one's emotions, thoughts, and behaviors in the face of temptations and impulses.

Cognitive Representation

The manner in which knowledge and ideas are formed, stored, and processed in the mind.

Guidelines for Behavior

Broad recommendations or principles designed to direct or influence actions and conduct in relation to behavior.