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:

IR Spectrum

A graphical representation of infrared light absorption by molecules, used to identify and study chemical substances based on their vibrational transitions.

Organic Compound

Chemical compounds made primarily of carbon atoms in structures like chains or rings, often containing hydrogen and possibly oxygen, nitrogen, or other elements.

Absorptions

The process by which substances take in or soak up energy or material from their surroundings, often observed in spectroscopy.

IR Absorption

The process by which molecules absorb infrared light at frequencies characteristic of their structure, used in infrared spectroscopy.