_______ allows you to synthesize and analyze data from list or existing table.

Question

Accepted Answer

The correct option is (4):
A **Pivot table** is the definitive and most powerful tool for this purpose. Its core function is to take large, complex raw data from an existing list or table and quickly synthesize it, or 'pivot' it, into a meaningful summary report for analysis. This process involves aggregating data (such as calculating sums, averages, or counts), grouping data based on categories, and creating multi-dimensional views to uncover trends and patterns. Essentially, a Pivot table transforms detailed transactional records into a compact, easily understandable analytical overview, making it the correct choice for actively performing both synthesis and analysis.

The incorrect option is (1):
A simple **Table** is the fundamental data structure where raw information is stored, organized into rows and columns. Its primary purpose is the initial *storage* and *organization* of data. While it contains the data that will be analyzed, the table itself does not possess the inherent functionality to summarize, aggregate, or dynamically reshape the data for synthesis and high-level analysis in the way a Pivot table does.

The incorrect option is (2):
The term **Merged table** typically refers to the output of a data preparation step where data from multiple sources has been combined, either by joining corresponding columns or stacking rows. This action is concerned with *consolidation* and *data integration*. Although it results in a new table, merging is a precursor to analysis; it does not perform the synthesis (grouping and summarizing) of the combined data, which is a feature of an analytical tool.

The incorrect option is (3):
A **Header table** (or, more commonly, a header row) simply refers to the top row(s) of a data table that contains the descriptive titles or labels for each column. Its purpose is purely *descriptive* and *organizational*, ensuring the fields of the dataset are correctly identified. A header has no independent functional capability to manipulate, synthesize, aggregate, or analyze the numerical or categorical values stored beneath it.