When an Error Occurs in a Formula in a Cell

question 54

Multiple Choice

When an error occurs in a formula in a cell, Excel displays the ____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.

• A)Smart Tag Actions
• B)AutoCorrect Options
• C)Trace Error
• D)Auto Fill Options

---

Definitions:

Asset Cost

The total amount invested to acquire, produce, or improve a tangible or intangible asset, utilized for accounting and tax purposes.

Lease-Purchase Analysis

A financial evaluation technique used to determine the most cost-effective option between leasing an asset and purchasing it outright.

Sale and Leaseback

A financial transaction where one sells an asset and leases it back for the long-term; thus, one continues to be able to use the asset but does not own it.

Balance Sheet

A financial statement that provides a snapshot of a company's financial condition at a specific point in time, detailing assets, liabilities, and equity.