Computer Concepts Module 5 Practice Test 2026 – Complete Exam Preparation

Filtering lets you specify a condition, such as sales above a threshold, and the view shows only the rows that meet that condition. This is exactly what’s described when you want to see only the values you care about—the data that doesn’t meet the rule is hidden from view.

The other options don’t fit as neatly: sorting changes the order of rows but doesn’t remove anything from the display, and grouping collects items into categories or summaries rather than filtering the dataset. Hiding can conceal items, but it usually isn’t driven by a reusable rule like a threshold and isn’t the standard way to isolate data for analysis.