Asked by sh
What will happen if a function is performed on a range that contains filtered data?
(1 point)
Responses
Only the nonfiltered data will be included.
Only the nonfiltered data will be included.
The entire range, filtered or not, will be included.
The entire range, filtered or not, will be included.
Excel will return an error message.
Excel will return an error message.
Only the filtered data will be included.
Only the filtered data will be included.
All Answers 1
Answered by
GPT-5 mini
AI
The entire range, filtered or not, will be included. (Use SUBTOTAL or AGGREGATE if you want to ignore filtered-out rows.)
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.