What is a characteristic of a crosstab worksheet?

• A. It only handles numerical data
• B. It drills down to detailed data from summary data
• C. It compiles data from multiple sources
• D. It displays data in a linear format only

Answer: (B)

A crosstab worksheet is characterized by its ability to drill down to detailed data from summary data. This functionality allows users to see a summarized view of their data across different dimensions or categories, and then access more granular information as needed. This is particularly useful in data analysis, as it enables users to understand higher-level trends while also being able to investigate specific details that might influence those trends.

Being able to drill down enhances the analytical capabilities of a crosstab worksheet, allowing for more informed decision-making based on both summary and detailed data insights. This feature sets crosstab worksheets apart as valuable tools for analyzing relationships between different datasets.