All of the Following Statements Are TRUE About Auditing Formulas

question 31

Multiple Choice

All of the following statements are TRUE about auditing formulas EXCEPT:

• A)Tracing formulas draws lines from a formula to cells that supply source data and to formulas that use the result of a formula.
• B)Formula-auditing tools show you which cells are used in a formula and how they are used.
• C)When you select to trace dependents, Excel finds and marks with arrows all the cells that supply values to the active cell.
• D)Both tracing a formula and evaluating a formula are useful in understanding how a worksheet is structured, and they are particularly useful if a complex formula is not producing a correct result.

---

Definitions:

Acid Catalysis

The acceleration of a chemical reaction by an acid, which functions by donating protons (H+ ions) to transitional states or reactant molecules.

Organic Product

A compound derived from living organisms or synthetic processes designed to mimic naturally occurring compounds, often involved in various chemical reactions.

NMR Peaks

The visible peaks in a nuclear magnetic resonance spectrum, each corresponding to a different chemical environment of nuclei in a molecule.

Nitrogen-Containing

Refers to molecules or moieties that include one or more nitrogen atoms within their structure.