What type of worksheet can be created to summarize data from multiple sources through specified dimensions?

• A. Composite Worksheet
• B. Crosstab Worksheet
• C. Dynamic Worksheet
• D. Summary Report

Answer: (B)

A Crosstab Worksheet is specifically designed to summarize data from multiple sources through specified dimensions. It provides a means to display and analyze data by organizing information into a matrix format, allowing users to see relationships and patterns across different dimensions. This type of worksheet is particularly useful for aggregating and examining data points that fall into intersecting categories, which can facilitate insights and informed decision-making.

In contrast, while a Composite Worksheet may involve multiple elements, it does not inherently focus on summarizing dimensions in the same systematic manner as a crosstab. A Dynamic Worksheet typically allows for real-time data manipulation and interactivity but does not emphasize summarization through specified dimensions as crosstab does. Lastly, a Summary Report generally presents aggregated data but may not specifically organize it in the structured matrix format that crosstab worksheets excel in. Therefore, the crosstab format stands out for its effectiveness in summarizing across specified dimensions.