AC Adv Case 13-1 Eric Has Been Asked to Write

question 595

Multiple Choice

AC Adv Case 13-1 Eric has been asked to write a VBA function to calculate the average salaries for his company's salespeople for the past five years. Eric asks for your help in getting started with VBA programming using the company's salary database. Eric suspects there will be similar requests in the future and wants the function he creates to be available for various database procedures. You suggest Eric define the function in a ____.

• A) control
• B) subroutine
• C) case
• D) module

---

Definitions:

Residual Income

The income that an investment or business generates after accounting for the cost of capital.

Contribution Margin

The amount remaining from sales revenue after variable expenses have been deducted, indicating how much contributes to covering fixed costs and generating profit.

Segment Margin

The amount of profit or loss generated by a particular segment of a business, helping to assess the financial contribution of different parts of the business.

Gross Cost

The total cost incurred before any deductions or allowances.