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:

Expiratory Reserve Volume

The additional amount of air that can be forcefully exhaled after a normal exhalation, used to measure lung function.

Inspiratory Reserve Volume

The additional amount of air that can be inhaled after a normal inhalation, contributing to the total lung capacity.

Peak Expiratory Flow

A measure of the fastest speed at which a person can exhale air after a maximal inhalation, often used in diagnosing and monitoring asthma.

Tidal Volume

The volume of air moved into or out of the lungs during a normal breath at rest.