In a spreadsheet that contains a large amount of data, use the ____ command to summarize and rearrange data to answer specific questions, such as which course generated the greatest enrollment for which semester and for which instructor.
A) Filter
B) Mail Merge
C) PivotTable
D) Sort

Question

Quizplus · Accepted Answer

The PivotTable command is specifically designed to summarize and rearrange data based on specific questions or criteria. It allows users to easily manipulate and analyze large amounts of data, making it the best choice for answering questions such as which course generated the greatest enrollment for which semester and instructor. The Filter and Sort commands are useful for organizing and manipulating data, but they do not have the same level of functionality as PivotTable. Mail Merge is a feature that allows users to create and customize documents, but it is not related to summarizing and rearranging data within a spreadsheet.

In a Spreadsheet That Contains a Large Amount of Data