Adrian Has Made a List of His Family's Grocery Expenses

question 1

Multiple Choice

Adrian has made a list of his family's grocery expenses over the past year.He wants to highlight all the weeks where expenses exceeded the grocery budget so he can budget more accurately for the coming year.Which spreadsheet tool will allow him to do this automatically?

• A) Sorting
• B) Conditional formatting
• C) Filtering
• D) Font formatting

---

Definitions:

Quantity Change

A variation in the amount of goods or services produced or supplied, often measured to assess economic shifts or business performance.

Industry

A sector of the economy that involves the production and manufacturing of goods or the provision of services.

Long Run

A period during which all factors of production and costs are variable, in contrast with the short run where some costs are fixed.

Short Run

A period in economics during which at least one input, such as plant and equipment, is fixed, focusing on immediate effects of economic decisions.