Question

choose the correct answer. true or false: the aggregate function always includes hidden and filtered data. true false

Explanation:

The Aggregate function in Excel, for example, does not always include hidden and filtered data. It depends on the specific function and settings. Some functions like SUBTOTAL can be configured to include or exclude hidden/filtered rows, while others like SUM (if used in a normal range reference without special handling for filtering) might include all data in the range regardless. But the statement "always" is incorrect.

Answer:

False