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:

Standards Gap

The discrepancy that occurs when the perceived quality or performance of a product or service falls short of the expected or promised standards.

Knowledge Gap

The divergence in information that occurs when one party possesses more or superior information compared to another, often leading to unequal opportunities and outcomes.

Delivery Gap

The discrepancy between a company's service quality specification and the actual service delivery, often leading to customer dissatisfaction.

Perishable

Describes goods that have a limited lifespan and can deteriorate quickly if not consumed or used within a certain period, such as food products.