How Can You List the Records in a Query Datasheet

question 44

Multiple Choice

How can you list the records in a query datasheet in A-Z order by CustomerName?

• A) Click a value in the CustomerName field,and then click the Descending button.
• B) Click a value in the CustomerName field,and then click the Ascending button.
• C) Click the Advanced button,and then click Filter By Form.
• D) Click the CustomerName column heading.

Apply the high-low method to estimate variable and fixed components of costs from given data.

Analyze mixed costs using different approaches including the high-low method, least-squares regression, and account analysis.

Estimate the total cost, variable cost per unit, fixed costs, and contribution margin using cost-volume-profit (CVP) analysis.

Identify and analyze the limitations and strengths of various methods used in cost estimation.

---

Definitions:

Discount Rate

A percentage used to calculate the present value of future cash flows or investments.

Present Value

The current worth of a future sum of money or stream of cash flows given a specified rate of return, discounting future amounts to their present values.

Annual Rate

Typically refers to the interest rate for a whole year, often applied in terms of loans, investments, or savings.

Invests

The act of allocating resources, usually money, with the expectation of generating an income or profit.