Which of the Following VBA Keywords Is a Declaration Statement

question 64

Multiple Choice

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

• A) Option Compare Database
• B) Option Compare Text
• C) On Text GoTo
• D) Select Case

---

Definitions:

Long Term Capital Gain

Profit earned from the sale of an asset held for more than a year, subjected to preferential tax rates.

Tax Bracket

A range of income subject to a particular tax rate under a progressive tax system, where higher income levels are taxed at higher rates.

Inheritance

Assets received from someone who has died, possibly subject to taxes depending on the value and the beneficiary's relationship to the deceased.

Holding Period

The length of time an investment is held by an investor, influencing tax treatment of gains or losses upon disposal.