What data-management tool is used to organize and sort data in a worksheet?

• A. PivotTable
• B. Chart
• C. Filter
• D. Table

Answer: (D)

Organizing data in a worksheet is best done by converting the data range into a Table. A Table creates a structured dataset with a header row and built-in sorting and filtering right in each column header. As you add rows, the table expands automatically and keeps formulas consistent through structured references. This keeps data tidy and sortable in one place. Other options serve different purposes: a PivotTable summarizes data into totals and is not used to organize the raw worksheet data; a Chart visualizes data; a Filter hides rows that don’t meet criteria, but it doesn’t provide the sustained structured organization and automatic expansion of a Table. So the tool that best fits organizing and sorting data in a worksheet is the Table.