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.

Question

Quizplus · Accepted Answer

The SUBTOTAL function in Excel is designed to calculate an aggregate (such as sum, average, count, etc.) for a range of values, excluding any rows that are not visible in a filtered list or table. This makes it particularly useful for analyzing data that has been filtered or hidden. Options A, B, and D describe functionalities more aligned with conditional formatting, cell formatting based on value comparison, and defining named ranges or table references, respectively, rather than the SUBTOTAL function's primary purpose.

The SUBTOTAL Function