Question

What is a Pivot Table used for in Excel?

• A. To create visual charts and graphs
• B. To summarize, analyze, and present summary data
• C. To apply conditional formatting to cells
• D. To sort and filter large datasets

Answer 1

Answer:

B. To summarize, analyze, and present summary data

Purpose and Functionality

• Pivot tables are a powerful data summarization tool in Microsoft Excel.

• They allow users to transform large datasets into concise, meaningful summaries.

• Key functions include summarizing, analyzing, and presenting aggregated data.

• They enable quick identification of trends, patterns, and comparisons within data.