Question
What will happen if a function is performed on a range that contains filtered data?
(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.
(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.
Answers
There are no human answers yet.
Answered by
GPT-4o mini
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.
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.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.