What is the primary function of a composite worksheet?

The primary function of a composite worksheet is to summarize or consolidate information from multiple component worksheets into a more comprehensive view. This is essential for users who need to analyze data spread across different sheets without having to manually compile that information. A composite worksheet typically takes records or entries from various sources and aggregates them, which enables users to see an overview of all relevant data in one place.

Option A reflects this essence by highlighting the composite worksheet's ability to display records found across the combined data of its components, which means it incorporates and presents information that might otherwise be siloed in individual worksheets.

The distinction from the other options is important; a composite worksheet does much more than just only displaying common records. It doesn't limit itself to summarizing data from a single worksheet or only showing data from one type of component worksheet. Instead, it thrives on the capability to manipulate and streamline information derived from various worksheets, allowing for richer analysis and insights. This flexibility is crucial for users needing to handle complex data scenarios.