Each of the Following Statements Is TRUE About Referencing Data

question 82

Multiple Choice

Each of the following statements is TRUE about referencing data between worksheets EXCEPT:

• A)One of Excel's more powerful features is the ability to reference data between worksheets.
• B)Multiple worksheets represent a second dimension.
• C)If you think of a worksheet as a two-dimensional array, then multiple worksheets in a workbook can be thought of as a three-dimensional array.
• D)By using a 3-D formula with 3-D references, you can easily create a summary worksheet from multiple worksheets that are updated automatically as the source data is updated.

---

Definitions:

Interest Revenue

Income earned by an entity from lending money or investing in interest-bearing financial instruments.

Unearned Interest

Interest that has been collected on a loan by a lender but not yet earned because the loan principal has not been fully disbursed.

Bargain Purchase Option

A clause in a lease agreement allowing the lessee to purchase the leased asset at the end of the lease term at a price significantly below its expected fair market value.

Executory Costs

Expenses related to executing a contract, such as maintenance and insurance costs, that are typically incurred over the contract's term.