What is the definition of filtering data?

Filtering hides rows or records that do not meet the selected criteria while leaving the underlying data in the worksheet. So choice C, “to remove data that does not fit criteria from display,” is correct. Choice A describes deleting data, which filtering does not do.

AI-written and checked against the verified answer.