What type of worksheet allows for data editing?

• A. Table-based
• B. Transformation
• C. Metric
• D. Treemap

Answer: (A)

The table-based worksheet is specifically designed to allow for data editing. This type of worksheet typically presents data in a grid format, which makes it straightforward for users to manipulate and update the values directly within the cells. Users can easily enter new information, adjust existing data, or delete entries based on the requirements of their analysis or reporting needs.

In contrast, transformation worksheets generally focus on processing or converting data without direct user input, ensuring that the data workflow remains consistent and automated. Metric worksheets are used to display calculated values, often in a read-only format, which prevents direct data changes. Treemaps visualize data hierarchies and relationships in a graphical way and are not intended for editing data directly; they serve mainly for analytical purposes rather than data management. Thus, the emphasis on functionality and purpose confirms that the table-based worksheet is the correct answer for enabling data editing.