What is a characteristic of the data that can be included in a crosstab worksheet?

• A. It must consist only of numerical values
• B. It may involve multiple records for a single input
• C. It should exclude percentage calculations
• D. It must follow a strict hierarchical format

Answer: (B)

Crosstab worksheets are designed to summarize and analyze data in a tabular format, often providing insights through the relationships between different data categories. A key characteristic of a crosstab worksheet is that it can handle multiple records for a single input, allowing for comprehensive analysis. This feature enables users to view how various records interact or contribute to the overall dataset, providing a more nuanced understanding of the data trends and patterns.

By incorporating multiple records for a single input, crosstab worksheets enhance analytical capabilities. For instance, in a crosstab, you might have various sales transactions recorded for the same customer or product, thus providing a richer dataset for analysis, such as calculating totals, averages, or identifying trends over time. This flexibility in handling data makes crosstab worksheets a powerful tool in data analysis.

The other options suggest limitations that do not apply to the functionality of crosstab worksheets. They are designed to be versatile, accommodating a range of data types and calculations.