In a Spreadsheet That Contains a Large Amount of Data

question 6

Multiple Choice

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

---

Definitions:

Supply

The total amount of a product or service that is available to consumers, which can vary based on price, production costs, and other factors.

Elastic

A term used in economics to describe the sensitivity of the demand or supply of a good or service to changes in its price.

Perfectly Inelastic

A situation in which the quantity demanded or supplied does not change regardless of any change in price.

Fixed Number

A specific, unchanging quantity that does not vary under different conditions or over time.