Question

pivot tables are used for __________ the data.

• extend
• delete
• summarize
• collapse

Explanation:

Pivot tables are a data tool designed to aggregate, organize, and condense large datasets to highlight key insights, which aligns with summarizing data. The other options do not match their core function.

Answer:

Summarize