What will happen if a function is performed on a range that contains filtered data?

Question

(1 point)
Only the nonfiltered data will be included.
The entire range, filtered or not, will be included.
Excel will return an error message.
Only the filtered data will be included.

Answer 1

If a function is performed on a range that contains filtered data, only the nonfiltered data will be included.

This means that functions like SUM, AVERAGE, etc., will calculate based on the visible (nonfiltered) cells in the range, and any filtered out cells will not be included in the calculation.