To Include Calculated Fields in Queries,enter a Name for the Calculated

question 39

Multiple Choice

To include calculated fields in queries,enter a name for the calculated field,a(n) ____,and then the expression in one of the columns in the Field row.

• A) colon (:)
• B) semi-colon (;)
• C) equal sign (=)
• D) exclamation point (!)

---

Definitions:

Fair Value

The estimated price at which an asset or liability could be bought or sold in an orderly transaction between market participants.

Goodwill

A non-physical asset that comes into existence when a company is purchased at a price higher than the fair market value of its net identifiable assets.

Book Value

The net value of a company's assets found on its balance sheet, minus liabilities, often compared to market value for analysis.

Market Value

Market value is the existing price point at which you can buy or sell an asset or service within a marketplace.